add XLSM to supported file types for XLSheetToArray

Ideas for new features & functions

Moderators: Dorian (MJT support), JRL

Post Reply
User avatar
Grovkillen
Automation Wizard
Posts: 1023
Joined: Fri Aug 10, 2012 2:38 pm
Location: Bräcke, Sweden
Contact:

add XLSM to supported file types for XLSheetToArray

Post by Grovkillen » Tue Oct 15, 2013 11:34 am

Hello,

I use Excel sometimes to gather information using built in VBA possibilities. It saves me a ton of code if I make the VBA macro run at execution of the file. The problem is that I want to read this macro enabled file which is a ".xlsm" to add the results to an array. But MS tells me that the file is not an Excel file.

So, my suggestion is to add ".xlsm" to the supported Excel file types. As far as I can tell there's not a big difference between the ".xls" and ".xlsm" but I'm no expert. I hope it's an "easy" feature to add.... I need it! :)

EDIT: I have looked around and it seems that macro enabled xls (xlsm) is not the same as xls, so the request I have might not be possible.
Let>ME=%Script%

Running: 15.0.24
version history

User avatar
Meryl
Staff
Posts: 124
Joined: Wed Sep 19, 2012 1:53 pm
Location: Texas
Contact:

Post by Meryl » Mon Oct 21, 2013 2:29 pm

Hi Grovkillen,

Thanks for your suggestion. We'll forward it to the team for consideration.

Best,
Meryl

bestfriend
Newbie
Posts: 1
Joined: Mon Nov 18, 2013 9:21 am

Post by bestfriend » Mon Nov 18, 2013 9:38 am

My latest SolidWorks API application uses the command line to talk to SolidWorks and it would be nice if I could use colors to display the state of the app.

User avatar
Meryl
Staff
Posts: 124
Joined: Wed Sep 19, 2012 1:53 pm
Location: Texas
Contact:

Re: add XLSM to supported file types for XLSheetToArray

Post by Meryl » Mon Feb 16, 2015 3:35 pm

Thanks for the suggestion. Will let the team know.

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