Sorry,
Eileen, I have tried a test macro with the same keystroke, mine works okay. Please can you reply with more details on the macro being executed.
I found the problem's solution in the Microsoft Knowledgebase -sorta. The problem stems from the fact that the shift key is part of the shortcut. The knowledgebase link is:
http://support.microsoft.com/support/kb/articles/Q175/2/23.ASP?LN=EN-US&SD=gn&FR=0
I guess it's just a matter of choosing different shortcut keys.
Greg
--
Greg Mitchell
Programmer
Potash Corporation of Saskatchewan
Greg.Mitchell@potashcorp.com
-------------------------------------------------
Sure! The macro opens a CVS file, highlights columns A-K, copies, goes back to the original spreadsheet and pastes. When I run it with the shortcut, it opens the CVS file then stalls. As I've mentioned, it works perfectly when I do the "tools/macros/run button."
Interestingly enough, I have just run into the same issue myself today. To add another twist to it, if the filname is chosen with "Application.GetOpenFilename(...)" the macro executes completely with the shortcut key.
The problem seems to occur when using a constant filename. I haven't been able to find a way to resolve this either :(
I'm actually importing a text-file that is fixed width, and it does break the file into the right columns, it just doesn't do anything else after that (Basically just adding titles to the columns)
Anyone have any ideas? We're all stumped over here.
Greg Mitchell
Programmer
Potash Corporation of Saskatchewan
Greg.Mitchell@potashcorp.com
-------------------------------------------------