Macro doesn't execute fully using shortcut
I'm baffeled - I have a macro that was written to open 4 text files as fixed
width files and place them in the same workbook on different worksheets. The
macro runs fine, but only if I launch it from the VBA Editor, or from the
Tools - Macros window and select the macro and click run. I have assigned a
shortcut key combination (CTRL+SHIFT+Q). If open Excel and use that
shortcut, the macro launches, but stops immediately after opening the first
file. No error messages or anything like that.
How do I correct this problem?
I'm running Excel 2003
The macro is in my Personal.xls, and that file is hidden
Thanks for any help,
Rich
|