Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
In VBA: how to open a workbook with a specific version of excel?
Hi,
I have Office 2003 and 2007 on my computer. I've written code in VBA (Excel 2003)for opening a workbook if the file exists. If not, a new workbook must be created. The new workbook is created and opens, but the old workbook opens a second time in Excel 2007. How can I prevent this in VBA? Code: If fileExists("filename") then Set nWB = WB.Open("filename") Else Set oWB = active.workbook oWB.save oWB.saveCopyAs ("filename") Set nWB = wb.Open("filename") End if |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
force excel workbook to open to a specific worksheet | Excel Discussion (Misc queries) | |||
Open a specific workbook...find value from other open workbook and then insert cells values in cell next to it. | Excel Programming | |||
Macro - Save an Open Excel Version 4 as current version of Excel | Excel Programming | |||
Open specific version of Excel | Excel Programming | |||
How do I open each workbook in it's own version of Excel? | Excel Discussion (Misc queries) |