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

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
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
151
kj9
K
B
  • Question
Saving Personal xlsx file so it opens with Excel
Replies
2
Views
178
bearcub
B
A
  • Question
xlsx character encoding issue on amazon file
Replies
1
Views
138
alex0182828
A
T
  • Solved
Import Data Starting from next empty row
Replies
7
Views
73
Tanne
T
L
  • Question
VBA ERROR: Cannot Paste the Selected Copied Content
Replies
7
Views
246
Joe4
Joe4

Forum statistics

Threads
1,216,099
Messages
6,128,819
Members
449,469
Latest member
Kingwi11y

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