I have the following code in one of my workbooks, and the issue I am having is that I can step through it and make it function no problem, but when the macro is run on startup I get an application defined error. Anybody have some insight? Maybe another option? I suppose I could try On Error Resume Next, but that isn't exactly how I would like to tackle the issue.
It fails at the Export, (where does it export too?)
Please Login or Register to view this content.
Hello Shermer321,
The Kill statement is used to remove files from your disk, not modules from a VB Project. Here is the corrected code.
You don't need to worry about the hidden FRX module as this is automatically deleted with the UserForm.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks