Update from Excel 97 to 2007

[Joakim Norrman]

I have recently upgraded to Excel 2007 from Excel 97 and following code is
not working in Excel 2007:

Sub Test()
'Get name of active VB project
MsgBox Application.VBE.ActiveVBProject.Name
End Sub

 

[Mike Fogleman]

Trade in your 2007 for 2003.

Mike F

 

[Andy Pope]

Hi,

That code works for me in 2007. I did have to allow access to VB
projects first in order to avoid the warning message.

Office button > Excel Options > Trust Center > Trust Center Settings >
Macro Settings > Developer Macro Settings > Trust access to the VBA
project object model.

If not this can you give details of the actual error or what does not work?

Cheers
Andy

 

[Jon Peltier]

This is a security thing, not an Excel 2007 thing.

It doesn't work in 2003 or 2002 unless you follow Andy's reply and allow VBA
access to VB Projects. In 2003: Tools menu > Macro > Security > Trusted
Publishers tab, check the checkbox.

- Jon

 

[Joakim Norrman]

Thanks Andy.
Works fine now.

Hi,

That code works for me in 2007. I did have to allow access to VB
projects first in order to avoid the warning message.

Office button > Excel Options > Trust Center > Trust Center Settings >
Macro Settings > Developer Macro Settings > Trust access to the VBA
project object model.

If not this can you give details of the actual error or what does not work?

Cheers
Andy