Export to Excel 2003 and 2007

[Mask]

Hello,


I develop a macro at MS Project 2003 to export my data to Excel. All
work fine when I export my data to Excel 2003 but when I open my
Project in MS Project 2007 my button to export to MS Excel 2007,
appears but don't do nothing. I think I'm dealing with a compatibility
problem since all works fine when using MS Project 2003/2007 to export
to Excel 2003. Problem occurs when MS Excel 2007 is instaled instead
of 2003. I apreciate some help.

Best regards,

Mask

 

[Stephen Sanderlin]

This sounds like a reference issue... If you open the macro on a system
where 2007 is installed and change the reference to the Microsoft Excel
12.0 Object Library, does the macro work again?

--
Stephen Sanderlin
Principal Consultant
MSProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read my blog at: http://www.projectserverhelp.com
Join the community at: http://forums.epmfaq.com

 

[Mask]

Stephen Sanderlin,

http://groups.google.pt/group/micro...8a/3cdac12ad39f57ba?hl=pt-PT#3cdac12ad39f57ba

Best Regards,

Mask

 

[Stephen Sanderlin]

Mask,

Glad you got it resolved!

Steve

--
Stephen Sanderlin
Principal Consultant
MSProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read my blog at: http://www.projectserverhelp.com
Join the community at: http://forums.epmfaq.com