views:

23

answers:

0

I'm working on a VB macro which generates an Excel report out of a Microsoft Project planning. In order to save the report, I have to open a Save File Dialog by calling GetSaveAsFilename("name", , , "Title") but I don't want to use the Excel.Application for this because I'm supposed to activate it first which doesn't make sense.

How should I call GetSaveAsFilename through the Microsoft Project application?