Discussion Locked

Running Excel Macro from MS-Project

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a need to run a macro from MS=Project. I have a macro that exports datga to excel, then I need to run a macro to format the data in excel

Any ideas

1 reply

by rob.mcewan

from within your Project Macro, creat an object that references the XL file you want to work on. You start Microsoft Excel and create a new Worksheet object.
Set ExcelWorksheet = CreateObject("Excel.Sheet")
or open an existing sheet
Set ExcelWorksheet = GetObject("SHEET1.XLS").

Then use the ExcelWorksheet Object as you would in an XL macro to format up the output.

This discussion is closed to new replies.