How to update reference value

M

MarkP

I have created a couple of export of excel macros based on the excellent work
of Rod Gill and Jack Dahlgren.

My problem is that although I am guaranteed an Excell 11 install by all my
users, the Reference setting within MS Project 2007 VBE is not checked.

What I would like to be able to do is run a macro that does this:
Dim PrjMe As Project
Set PrjMe = ActiveProject
PrjMe.VBProject.References("Microsft Excel 11.0 Object
Library").VBE.SelectedVBComponent = True

This syntax does not work..

Is it possible to directly set the checkbox to True ?

thanks,Mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to set Reference using VBA 4
How to Set VBA References 4
Exporting Timephased data to Excel 11
Selection of Tasks using VBA 12
How to add cell's reference to cell's content 5
CommandBar and Button Actions 7
Addin to MS Project 3
how to get subprojects' file propertites. 1

Top