Limit to Excel Workbook size?

General Macro Scheduler discussion

Moderators: Dorian (MJT support), JRL

Post Reply
SandyDoss
Junior Coder
Posts: 40
Joined: Wed Sep 07, 2016 12:47 am

Limit to Excel Workbook size?

Post by SandyDoss » Thu Dec 20, 2018 10:42 pm

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
Junior Coder
Posts: 40
Joined: Wed Sep 07, 2016 12:47 am

Re: Limit to Excel Workbook size?

Post by SandyDoss » Thu Dec 20, 2018 11:11 pm

Addendum: 618k is good, 1.3mb fails.

SandyDoss
Junior Coder
Posts: 40
Joined: Wed Sep 07, 2016 12:47 am

Re: Limit to Excel Workbook size?

Post by SandyDoss » Fri Dec 21, 2018 6:26 pm

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 :shock:

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!

User avatar
Marcus Tettmar
Site Admin
Posts: 7378
Joined: Thu Sep 19, 2002 3:00 pm
Location: Dorset, UK
Contact:

Re: Limit to Excel Workbook size?

Post by Marcus Tettmar » Fri Dec 28, 2018 5:58 pm

There is no limitation in Macro Scheduler regarding file size.
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar

Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts