Running Excel Macro from MS-Project
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
IT Employment
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
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.
Sort by Trending