Mar 18, 2015 · I accidentally moved the Locals window in my VBA Editor and now I can't get it to dock back again. I have already tried renaming the registry key then close & reopen Excel to reset the settings (the key I renamed was HKEY_CURRENT_USER\Software\Microsoft\VBA\7.0\Common\) but while some of the VBA settings reset, the window positions did not.

Feb 8, 2017 · Need of a model that does the following: Connect to the serial port. (I have completed the model for this) Send a command. Receive the answer. Put received data at X address in spreadsheet. The RS232 equipment has a button to put the data to excel, but i want to create a button in excel to do the same as the button on the equipment.

Dec 9, 2013 · Hello, so I'm not sure if this belongs in Excel General? but I have excel 2010 for PC and my "Visual basic" "macros" and "Record Macro" buttons are all greyed out. The developer tab is (of course) up, and under macro security I have "enable all macros" allowed, and I've opened a completely new workbook -- this isn't a workbook specific issue ...

May 20, 2013 · Join Date 09-27-2012 Location Manchester, GB MS-Off Ver 365,2016,2013,2010,2007,2003 Posts 17

Jul 4, 2014 · Join Date 08-13-2008 Location England MS-Off Ver 365, varying versions/builds Posts 21,998

Feb 21, 2005 · The best way to do it is to use the MSComm control that comes with Visual Basic. If you want to see how this works, load and single step through the VBTerm sample that comes with it (should be in the \samples subdirectory; if not, I think you can download it from Microsoft's Visual Basic site).

Mar 2, 2005 · Re: Call XLA function in Visual Basic Macro ? To call a subroutine in another workbook or addin you have to use the RUN method (e.g., Run "Book1.xls!SubInWorkbook1") or set a reference to the

Join Date 12-19-2010 Location Budapest, Hungary MS-Off Ver Excel 2003 Posts 2

May 1, 2015 · The VBA Editor opens only one Window for each Excel instance. If you have multiple workbooks open in the same instance of Excel, you can work on all them with the single VBA Editor window. Each workbook contains a VBA Project that will be displayed in the Project Explorer window of the VBA Editor.

Apr 6, 2012 · "The visual basic for applications (VBA) macros for this workbook are corrupted and has been deleted. The macros corruption most likely exists in the current file. To recover the macros, open up a backup copy of this file if you have one."