Workbooks.Open Not Working...

[Rjc8513]

Using Workbooks.Open to open five external Excel files and import the data from the individual files. The code works just fine for data files A-D but crashes on file E and displays Run-time error 1004.

The only difference I can find is the size of File E. Files A-D are from 53KB to 291KB in size. File E is 2520KB in size.

Any ideas? Thanks.

 

[SkipVought]

Hi,

I'd be using MS Query. faq68-5829.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[xlbo]

you say "code" - assuming it is VBA ,post in the VBA forum: forum707 and post an example of your code

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question