View Single Post
 
Old 10-31-2022, 08:24 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,166
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

The macros will run faster if they don't have to wait for Excel to open so importing a text file source can be a lot quicker in execution.

Debugging form opening can be problematic since you just get a message that it fails showing the line of code that called the form rather than the line of code in the initialize macro where the problem resides. I usually add breakpoints in that code so I can step through the form code and isolate the issue that way.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote