Opening .txt file in same instnace of excel

[rothj070]

Hello all,

I have dug deeply into forums about this and have yet to come up with a suitable fix for my issue. Where I work, we process lots of data that we recieve in a .txt file. I have written many macros that, once in excel, post process this data. My issue has come about when we recently upgraded from MS Excel 2003 to 2007. I used to be able to open the excel document containing the macros for post processing and then double-click on the .txt file thusly opening it in the same instance of excel that I have open. Now, when I do this same operation, the .txt file is opened in a completely different excel instance and I cannot reference my macros due to this. I have tried using the File->Open method but even then when the text import wizard brings in the file, it is not the same format that we need it to be in for our macros to work correctly. If anyone has insight on this please let me know.

Thanks in advance

 

[Richard Schollar]

I'm surprised that double-clicking on a txt file opens it up in Excel for you - have you modified your file associations to result in this behaviour?

 

[rothj070]

Yes, I have setup my file assoc. so .txt files open in excel. We recieve massive amnounts of data each morning and setting it up that way is one less step/button click we need to deal with.