View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Poody Poody is offline
external usenet poster
 
Posts: 6
Default 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