A couple of things.
I assume that you have both versions of Excel loaded and don't wish to
uninstall the older version...
When you say that when you "open test.xlsm directly it opens as a regular 2007
excel"
When you do this, is Excel already open and then you double-click the file from
an explorer window
(or use the Open-> menu )?
What I suspect is that your Windows installation has "Associated" the Excel2003
to the .xlsm file extension.
Depending on how you want your system to operate, there are several solutions.
1) in your Scheduled Task, in the 'run' box, you have the file name:
"c:\foldername\test.xlsm"
instead, tell it which program you want to use to open the file:
"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE C:\foldername\test.xlsm"
2) Change your file association. Open an Explorer window ("My Computer").
Select Tools -> Folder Options, then select the File Types tab.
Scroll down to the .XLSM file type, and hit the "Change" button.
Now BROWSE to the C:\Program Files\Microsoft Office\Office12\EXCEL.EXE file
3) Uninstall Excel 2003 (I know, it may not be possible due to the need for
testing,etc)
hope this helps.
Paul
________________________________
From: TAlgo <trading.a...@gmail.com>
To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
Sent: Friday, July 31, 2009 11:28:10 AM
Subject: $$Excel-Macros$$ Windows Task Manager Opening old version 2003 excel
file
All,
I've scheduled a task to open my test.xlsm ( excel 2007 macro
enabled ) file everyday but when it opens automatically, it opens as a
2003 excel file and messes up few formulaes and charts which I have
created in 2007.
When I open test.xlsm directly it opens as a regular 2007 excel.
Any idea if this is related to some type of default or anything
related to settings.
I want to windows task manager to open test.xlsm as regular 2007 file
instead of 2003.
Thx in advance.
--~--~---------~--~----~------------~-------~--~----~
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 5,200 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~----------~----~----~----~------~----~------~--~---
