I'm writing several macros for someone even more computer challenged than me. I get a .txt download from our website and have to format columns so that credit card info shows as the complete number and not as scientific notation. I used the recorder and made a few changes to make it more generic and code is below. Trouble is, if I step through the macro or run it (either by using the menu option or running from VBA editor) it works fine. When I use the keyboard shortcut, it opens the file and stops (no formatting, no column setups, etc.) I don't see any errors, it just stops. I'm not even sure where to start looking for the problem.

Please Login or Register  to view this content.