Debugging Excel-Start?

  • Thread starter Thread starter Florian Reiser
  • Start date Start date
F

Florian Reiser

Hello,

one excel workbook has a very long loading time.
How can I see, what excel does?

The workbook is several excel-versions old.
Maybe that is causing the long loading times.

With kind regards

Florian Reiser
 
You can add Stop statement to WorkBook_Open event or AutoOpen procedure. After that save the workbook, close and re-open. While it is opening, VBA editor will appear and code execution will stopped. Now you can trace the code execution by pressing F8.

--
Haldun Alay
"Florian Reiser" <[email protected]>, haber iletisinde þunlarý yazdý:[email protected]...
Hello,

one excel workbook has a very long loading time.
How can I see, what excel does?

The workbook is several excel-versions old.
Maybe that is causing the long loading times.

With kind regards

Florian Reiser
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel slow to open workbook when I double-click in Windows 1
excel external data range failed to refresh - second try 1
excel external data range "failed to refresh" 0
Excel 2007 print option gone 1
No New Workbook Annoyance 2
Excel 2007: Flaky Macro 2
Compile error in hidden module 1

Back
Top