Ok, at our work we have recently moved from excel 2003 to 2010. I have several workbooks that contain macros that look for different txt files from a users desktop and imports them and then does stuff. For example in 2003 I use the below:
Workbooks.OpenText Filename:="C:\Desktop\ADOABS19.TXT"...