Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loosing VBA project when opening up Excel 2007
This workbook has lost its VBA project, ActiveX controls and any other
programmability-related features. I get this error whe I attempt to open up an excel 2003 file in excel 2007 does anyone know what could be causing this? -- Helping Is always a good thing |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loosing VBA project when opening up Excel 2007
Is it possible you've saved the file as an .xlsx?
"QuietMan" wrote: This workbook has lost its VBA project, ActiveX controls and any other programmability-related features. I get this error whe I attempt to open up an excel 2003 file in excel 2007 does anyone know what could be causing this? -- Helping Is always a good thing |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loosing VBA project when opening up Excel 2007
I open it up in 2007 and I get the error message...I can save as an xlsx file
but I still will not have access to the VBA project or any of the macros -- Helping Is always a good thing "Barb Reinhardt" wrote: Is it possible you've saved the file as an .xlsx? "QuietMan" wrote: This workbook has lost its VBA project, ActiveX controls and any other programmability-related features. I get this error whe I attempt to open up an excel 2003 file in excel 2007 does anyone know what could be causing this? -- Helping Is always a good thing |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loosing VBA project when opening up Excel 2007
Was the file saved in Excel 2003 or could it have been saved programmatically
in 2007 as a 2003 workbook? "QuietMan" wrote: This workbook has lost its VBA project, ActiveX controls and any other programmability-related features. I get this error whe I attempt to open up an excel 2003 file in excel 2007 does anyone know what could be causing this? -- Helping Is always a good thing |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loosing VBA project when opening up Excel 2007
Looks like the It guy who istalled excel 2007 disabled the VBA component
during instalation... Is there a way I can activcate it without re-installing? -- Helping Is always a good thing "Barb Reinhardt" wrote: Was the file saved in Excel 2003 or could it have been saved programmatically in 2007 as a 2003 workbook? "QuietMan" wrote: This workbook has lost its VBA project, ActiveX controls and any other programmability-related features. I get this error whe I attempt to open up an excel 2003 file in excel 2007 does anyone know what could be causing this? -- Helping Is always a good thing |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loosing VBA project when opening up Excel 2007
Hi
Did you got answer to your question? I have same problem! "QuietMan" wrote: Looks like the It guy who istalled excel 2007 disabled the VBA component during instalation... Is there a way I can activcate it without re-installing? -- Helping Is always a good thing "Barb Reinhardt" wrote: Was the file saved in Excel 2003 or could it have been saved programmatically in 2007 as a 2003 workbook? "QuietMan" wrote: This workbook has lost its VBA project, ActiveX controls and any other programmability-related features. I get this error whe I attempt to open up an excel 2003 file in excel 2007 does anyone know what could be causing this? -- Helping Is always a good thing |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loosing VBA project when opening up Excel 2007
Bogi -
If VBA was not originally installed, you do not have to reinstall. Instead, run the setup, and install (add) the VBA component. - Mike http://www.MikeMiddleton.com "Bogi" wrote in message ... Hi Did you got answer to your question? I have same problem! "QuietMan" wrote: Looks like the It guy who istalled excel 2007 disabled the VBA component during instalation... Is there a way I can activcate it without re-installing? -- Helping Is always a good thing "Barb Reinhardt" wrote: Was the file saved in Excel 2003 or could it have been saved programmatically in 2007 as a 2003 workbook? "QuietMan" wrote: This workbook has lost its VBA project, ActiveX controls and any other programmability-related features. I get this error whe I attempt to open up an excel 2003 file in excel 2007 does anyone know what could be causing this? -- Helping Is always a good thing |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loosing VBA project when opening up Excel 2007
Thanks
Everything works now perfectly "Mike Middleton" wrote: Bogi - If VBA was not originally installed, you do not have to reinstall. Instead, run the setup, and install (add) the VBA component. - Mike http://www.MikeMiddleton.com "Bogi" wrote in message ... Hi Did you got answer to your question? I have same problem! "QuietMan" wrote: Looks like the It guy who istalled excel 2007 disabled the VBA component during instalation... Is there a way I can activcate it without re-installing? -- Helping Is always a good thing "Barb Reinhardt" wrote: Was the file saved in Excel 2003 or could it have been saved programmatically in 2007 as a 2003 workbook? "QuietMan" wrote: This workbook has lost its VBA project, ActiveX controls and any other programmability-related features. I get this error whe I attempt to open up an excel 2003 file in excel 2007 does anyone know what could be causing this? -- Helping Is always a good thing |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loosing formatting in 2007 | Excel Discussion (Misc queries) | |||
Deploying Excel 2007 VBA Project in an Office 2007 Standard enviro | Excel Programming | |||
How do I convert an Excel 2003 VB Project to 2007? | Excel Programming | |||
Instead of opening Solver Excel starts up a sub from the VBA project | Excel Programming |