macro cannot open .xlsx file help!

M

mightyujin

New Member
Joined
Jun 15, 2011
Messages
12
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 ;)
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Sort by date Sort by votes
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 :confused:
 
Upvote 0
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.
 
Upvote 0
You must log in or register to reply here.

Similar threads

K
  • Question
Macro to convert multiple CSV's into a single xlsx file with multiple workbooks (each workbook is the name of the csv file)
Replies
0
Views
103
kj9
K
B
  • Question
Saving Personal xlsx file so it opens with Excel
Replies
2
Views
142
bearcub
B
A
  • Question
xlsx character encoding issue on amazon file
Replies
1
Views
101
alex0182828
A
L
  • Question
VBA ERROR: Cannot Paste the Selected Copied Content
Replies
7
Views
194
Joe4
Joe4
P
  • Solved
VBA to open file using Cell for the path
Replies
4
Views
588
Peter Davison
P

Forum statistics

Threads
1,214,984
Messages
6,122,601
Members
449,089
Latest member
Motoracer88

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top