.exe file can not open excel 2013 file

Technical support and scripting issues

Moderators: JRL, Dorian (MJT support)

Post Reply
noelhcar
Newbie
Posts: 4
Joined: Sat Jun 29, 2013 12:33 pm

.exe file can not open excel 2013 file

Post by noelhcar » Wed Jun 11, 2014 1:27 pm

Hi,

I have a file which I need open with a Macro. The macro normally runs in other computers of the company but the one in question was changed bringing about excel 2013 with it. Since then when I execute the macro (have extracted the bit which is not working):

xlopen>W:\Drytec CP\QC\Macros Drytec\Purchases Module.xls,1,pmodule

I get the message:

"Exception EvariantInvalidOperatorError in module Drytec Purchases Automation.exe at 00030DFC. Invalid Variant Operation"

The excel file is a simple spread sheet which can be open using a normal shortcut.

Can somebody help?

Thanks

Noel

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

Re: .exe file can not open excel 2013 file

Post by Marcus Tettmar » Thu Jun 12, 2014 7:44 pm

Not sure why this would be. Am using Excel 2013 here with no issues with XLOpen. Is it possible you can send your xlsx file to support so that we can try here with the same file?
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