sorry to confuse you, but in option #1,
you have to change the path names to the ones for YOUR location:
Is Excel in:
C:\Program Files\Microsoft Office\Office12\EXCEL.EXE ??
and, is your file called:
C:\foldername\test.xlsm
I REALLY doubt that you have a folder called 'foldername'!
Also, keep in mind that if your any of your folders or file names have a space,
you'll need to enclose the name in quotes:
"C:\Documents and Settings\MY Very Own Folder\test 1.xls"
try again....
personally, I think #1 is the best solution.
Although #2 SHOULD have worked too... unless you accidently
changed the association to the 2003 version!
(they're both called EXCEL.EXE !!!)
Paul
________________________________
From: TAlgo <trading.a...@gmail.com>
To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
Sent: Friday, July 31, 2009 1:05:26 PM
Subject: $$Excel-Macros$$ Re: Windows Task Manager Opening old version 2003
excel file
Paul,
When I click the test.xlsm file it always opens as 2007 version, no
prior version of any excel is open at that time.
now I tried your suggested approaches:
1. Used "C:\Program Files\Microsoft Office\Office12\EXCEL.EXE C:
\foldername\test.xlsm" BUT this doesnt trigger to initiate my
test.xlsm in any format. Is thata anything missing on this one?
2. Yesterday I changed the setting by going to Tools and Folder
Options and did exactly as what you suggested BUT with no luck.
3. As of now rest of the firm is still using 2003 so I need that
version for testing and reporting purpose.
Thanks
On Jul 31, 12:35 pm, Paul Schreiner <schreiner_p...@att.net> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
