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
.exe file can not open excel 2013 file
Moderators: JRL, Dorian (MJT support)
- 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
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?
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?