Run-time error '1004': Method 'Open' of object 'Workbooks' failed

[krish2503]

Hi,
I have a master workbook and want to run a macro (as per below) which would open another workbook and copy data on a tab from the opened workbook into my master workbook. But each time I try to do that, I get the above 1004 error. Both the files are Binary Workbooks (to keep the file size small) but still touch 35mb each. I was wondering if the file type or file size have anythign to do with the error.

Any help will be appreciated.

Please Login or Register  to view this content.

[krish2503]

Hi, forgot to point out that the line highlighted when the error msg comes up is the

Set wb1 = Workbooks.Open(Filename:=FileToOpen)

[jaslake]

Hi Krish

Perhaps this

Please Login or Register  to view this content.

[krish2503]

Hi Jas

Have already tried that and the problem still persists.

[Parth007]

HiKrish, I am able to execute the code..
can you share the file which you will browse from the code & work upon?

[krish2503]

Hi Parth,
am afraid not! The files are just too big (35mb each, even after converting to a Binary workbook) and one reason why I was checking if the file size ot type has anything to do with the error.

[humdingaling]

not sure if it will fix it but put "" around false

Please Login or Register  to view this content.

thats the only error i got from the small scale i used

Please Login or Register  to view this content.

[Parth007]

Can you try to run the code on some small size sample sheets?
As i was able to pass through the

Please Login or Register  to view this content.

[krish2503]

Hi Parth,

I tried to pull data from an older version (33MB) and it worked....for some reason it continues to give the above error for the newer version (which is about 39MB). I am not sure if the latter file is corrupted as it does not throw up any error message when I open it. At my wits end :-(

[krish2503]

Hi Humdingaling,
Same problem continues.

[Parth007]

Try code..

Please Login or Register  to view this content.

and see what u get for the file above 39MB

Just a Hit & Trial..

[krish2503]

Hi Parth
Doesn't do anything...doesn't give any error message but doesn't copy any data over either and the macro runs in a jiffy maybe as it is skipping the 'open file' command

[Parth007]

Ya true.. it do skip the error part..
still u are able to pull the data in files lower than 39 MB..
May be huge file is the cause.......

cant you do something to minimise the size.. i mean excluding extra formating, unwanted data, hyperliks.. refrences etc....

[krish2503]

yeah...will try to do that now, Parth. Thanks for your help. If you do come across anything along the above lines with a plausible solution, please do let me know.