Limit to Excel Workbook size?

[SandyDoss]

Hello, and Happy Holidays!

I'm having an issue opening an Excel Workbook that is sized approx 1.6 meg. Using the XLOpen command, I always get 'ERR' back in the handle variable. The workbook is comprised of 9 different tabs. I can trim the workbook down to a smaller size, and open it just fine.

Secondarily, is there a way to get an error returned other than 'ERR' if it can't be open? Some set of codes or something to tell me why it can't be opened?

Thanks so much!
Sandy

[SandyDoss]

Addendum: 618k is good, 1.3mb fails.

[SandyDoss]

As a sidenote, when we attempted to execute excel.exe via the command line, we got a Windows message stating that another workbook couldn't be opened due to lack of memory or disk space

So, as a workaround, we used VB to open the file and we had no problem.

It would be beneficial, however, to know if there is a limitation in MS as to file size.

Thanks!

[Marcus Tettmar]

There is no limitation in Macro Scheduler regarding file size.