Better Error Message for Excel Function

Ideas for new features & functions

Moderators: Dorian (MJT support), JRL

Post Reply
User avatar
Phil Pendlebury
Automation Wizard
Posts: 538
Joined: Tue Jan 16, 2007 9:00 am
Contact:

Better Error Message for Excel Function

Post by Phil Pendlebury » Tue Apr 14, 2015 11:22 am

Example:

Use the default: XLOpen>%USERDOCUMENTS_DIR%\mybook.xls,1,xlBook
XLGetSheetDims>xlBook,Customers,rows,cols

But name the Sheet (within the workbook) "Customer" instead of "Customers"

Here I get access violation and / or an error saying INVALID INDEX. Would it be possible to be more informative:

"No Sheet - Customer- can be found within workbook mybook.xls"
Phil Pendlebury - Linktree

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

Re: Better Error Message for Excel Function

Post by Marcus Tettmar » Wed Apr 15, 2015 12:25 pm

Yes, definitely. Tx.
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
cron
Sign up to our newsletter for free automation tips, tricks & discounts