It also happens across many different hardware specs. If Dir (FileNameZip) '' And Dir (FileNameXls) '' Then. When run a message is displayed telling me a library is missing. Here is the code I am using to Zip and mail a workbook. I have added to my project the Microsoft Office 16 and Microsoft Excel 16 references, removing the Office 14 and Excel 16 previous references. I am using Office 2016 with the latest updates and the test machine has 16GB of RAM so I struggle to understand how it could exhaust all that RAM if it is a memory issue. I have migrated from excel 2010 to 2016 and Excel functions in VBA do not function.
Without going into details, the cause is that Excel does not correctly save the compile state of the VBA code and 64 bit Excel cannot recover from that issue when opening the afflicted Excel file (32 bit usually can). When the filename workbook is open before running the code, the GetObject does connect with the instance of the workbook and it can proceed with the workbook operations (although, some become very slow). This affects all recent version of Excel (probably 2010 through 2016). The code throws an error message saying index out of range, which is due to Windows.Count being 0. and then run a VBA macro to dynamically change the Connection property of. From a VBA perspective, the document object model (DOM) did not change with the upgraded functionality. Then from a different excel workbook, I would extract the query From File. This was a replacement for the Lists functionality found in Excel 2003. Tables, as we know them today, first appeared in Excel 2007. They have to be closed ending the task in Task Whether you love tables as much as I do or not, this post will help you automate them with VBA. However, when I run the same code after having installed Office 2016, when the filename workbook is not opened, it opens two Excel windows, which are blank (no worksheets are displayed) and unresponsive. The following code works fine on my Windows 10 64 computer, running Visual Basic 2013 and Excel 2010