macro cannot open .xlsx file help!

[mightyujin]

Hi, I have excel 2003 and i use macro to copy data from a file that ends in .xlsx. the data file is coming from a department other than mine and i used macro to automatically copy the data from the .xlsx file to my excel file. However i cannot open .xlsx file using macro, and am wondering if I need to use some special code to do; i.e.,
Workbooks.Open Filename:=MRfile, UpdateLinks:=0, WriteResPassword:="4701", converter:=true?

I never used converter before and please let me know how to approach this to automatically open .xlsx file. Thank you for your help

 

[Sektor]

You must install converter.

 

[mightyujin]

i have the converter, it just that when i try to open .xlsx with macro won't open.

 

[Sektor]

Try to delete Converter argument.

 

[mightyujin]

Hi Sektor, I have and my code is

Workbooks.Open Filename:=SIMSfile, UpdateLinks:=0, WriteResPassword:="1111", Password:="1111"

But it won't do it still I am not so sure why

 

[Sektor]

Write value of SIMSfile parameter.

 

[mightyujin]

how do you write valueSIMS parameter? Would you give me a specific code?

 

[Andrew Poulsom]

Have you tried recording a macro while opening the workbook manually?

 

[mightyujin]

yea but it won't work because recording macro did not result in any code writing.
Somehow it work at my co-workers computer but not mine. I am not sure why.

 

[Andrew Poulsom]

But you can open it manually?