- HOW TO RECOVER PREVIOUS VERSION OF EXCEL FILE 2013 HOW TO
- HOW TO RECOVER PREVIOUS VERSION OF EXCEL FILE 2013 UPDATE
- HOW TO RECOVER PREVIOUS VERSION OF EXCEL FILE 2013 CODE
I noticed in Explorer that *.xlsx files were set to be opened in Excel 2010 and *.xls files were set to be opened in Excel 2003.
HOW TO RECOVER PREVIOUS VERSION OF EXCEL FILE 2013 CODE
It didn't matter if I used Excel.Application.10 or Excel.Application.14 in my code to create the Excel object, it was always an Excel 2003 file dialog. Now Powerpoint was opening up an Excel 2003 file dialog, which would raise errors when trying to select a *.xlsx file. In my situation, I had a Powerpoint macro that was supposed to open a file dialog for the user to select some Excel files and then create tables from the data I had no problem with it until I recently installed Excel 2003. I had a similar issue, and thought I would detail my experience for those that stumble across this in the future.
HOW TO RECOVER PREVIOUS VERSION OF EXCEL FILE 2013 UPDATE
This might be a good item to bring to Microsoft's attention so see if we can get this item stabilized in subsequent update packages to allow consistent behavior in future releases. This appears strong evidence that a Microsoft update tweaked the settings that previously allowed the VB code to work as expected. Now, after the Word update (immediately after!), the same code now launches Word 2010 despite the fact that the command line invoking Word 2002 has not changed. The app ran fine and invoked Word 2002 as expected.īut then I got the banner page informing me of a Word 2010 update that was installing itself.Īfterwards, I ran the app that worked so well for me last week and once today. I did not know this until after I had made one run of my app from last week. This morning (9/30/13) I turned on a computer that had a Word update.
I control the updates via an app which gives me control over when updates occur such that I can observe changes to my configuration.
Over the weekened, I had an update to my computer. (Thank you Stack Overflow contributors!) I wanted to use Word XP, so I looked at my directories and observed that Word XP (aka Word 2002) is a member of Office 10, so I created the command 'Set wordApp2002 = CreateObject("Word.Application.10")'Īnd my program launched Word 2002 and the world was a happy place. The solution noted in this discussion chain provided the answer to my question.
HOW TO RECOVER PREVIOUS VERSION OF EXCEL FILE 2013 HOW TO
As a result, I searched on how to invoke a legacy version of Word as opposed to the default offering on my computer which is Word 2010. The best plan includes using a version of Word similar to the version the legacy apps were designed with/to. I have an application that converts a text file to a Word document for backwards compatibility with some legacy apps. Working or not on your computer is that it is a function of the latest update you get from Microsoft. My observation on the situation of the command 'Set wordAppxxxx = CreateObject("")' This may further explain why the code works some times and not others.
Then the version registered opens but then I can't open open the non-registered.Ĭan anyone help and show me how to open a specific version of Word within Excel using VBA? "C:\Program Files\Microsoft Office\Office14\WINWORD.EXE" /regserver "C:\Program Files\Microsoft Office\Office12\WINWORD.EXE" /regserver I've also tried early binding by using Dim wordApp As Word.ApplicationĪnd setting references to the Word 12.0 object model but this still opens Word 2010 Set wordApp2010 = CreateObject("Word.Application.14") Set wordApp2007 = CreateObject("Word.Application.12") I've tried late binding Dim wordApp2007 As Object I need to open Word from within Excel but I need to specify which version I need to open within VBA.
0 kommentar(er)
