Please I need help to solve this problem that has become a big bottleneck for me. It also happens across many different hardware specs. 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. 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). The code throws an error message saying index out of range, which is due to Windows.Count being 0. They have to be closed ending the task in Task 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
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |