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"
However in 2010 the same workbook errors "file could not be accessed". I recorded a macro file import in 2010 and it returns the following:
ChDir "C:\Users\users.name\Desktop"
Workbooks.OpenText Filename:="C:\Users\users.name\Desktop\ADOABS19.TXT"
I understand that 2010 is now including the users name, my issue is that my workbooks are shared, so whilst I can record it in my name it won't work for another user, does anyone know who to make this for multiple users?
Regards,
Odd
Workbooks.OpenText Filename:="C:\Desktop\ADOABS19.TXT"
However in 2010 the same workbook errors "file could not be accessed". I recorded a macro file import in 2010 and it returns the following:
ChDir "C:\Users\users.name\Desktop"
Workbooks.OpenText Filename:="C:\Users\users.name\Desktop\ADOABS19.TXT"
I understand that 2010 is now including the users name, my issue is that my workbooks are shared, so whilst I can record it in my name it won't work for another user, does anyone know who to make this for multiple users?
Regards,
Odd