How to run an excel marco from progress

[chefsride]

I have created a program that is sending data out to excel. I want to format the sheet so that when the users looks at the excel spreadsheet they can see all the fields and data neatly. Is there a way in progress to run a marco created in excel on this spreadsheet before the user sees it.

 

[jongpau]

Try something like:
chExcelApp:Run("MacroName":U).
chExelApp:Visible = TRUE.

 

[chefsride]

This is not working whenever I create a macro then save it. When I try and run my progress program it tells me it can not find the macro.

 

[jongpau]

Have you tried that with the full path to where the Macro is saved?

 

[chefsride]

I figured it out. I was having problems with my personal macro workbook. It was not opening the workbook everytime excel opened so I have to force it to open it.