ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Loosing VBA project when opening up Excel 2007 (https://www.excelbanter.com/excel-programming/431973-loosing-vba-project-when-opening-up-excel-2007-a.html)

Quietman

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

Barb Reinhardt

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


Quietman

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


Barb Reinhardt

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


Quietman

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


Bogi

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


Mike Middleton[_2_]

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



Bogi

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





All times are GMT +1. The time now is 05:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com