Code will run in editor but will not run with hotkey

This is my first attempt at programming. This takes a comma delimited text file created by another program and converts into a format readable by a different program. When I run it through the editor immediate window it works just fine but when I run it with a hotkey it stops after opening the requested file. Any ideas would be appreciated. The attached file is the text file similar to the ones opened by this macro

Thanks

Please Login or Register  to view this content.

try removing the first workbook.open command

Please Login or Register  to view this content.

Hi Andy

I tried what you suggested. It still will not run off the hot key.

thanks

I think I spoke too soon. Its still not working all the way through but it is moving further through the code. I will let you know where it stopped

probably falls over at

Please Login or Register  to view this content.

the constant is xlToLeft

what is the hotkey you are using.

In my test I used CTRL+SHIFT+U and it worked fine (after corrections already detailed).

probably worth testing with a hotkey combo that doesn't use Shift

bug in excel. because shift is the key used to prevent code running automatically when you open a file, using a shortcut key with shift can stop your code in its tracks when it opens a file. I've gotta admit I didn't know it happened with opentext too

Thanks JosephP, I was testing in xl2010 and CTRL+SHIFT+M works.
But I can confirm xl2007 stops after import.