Exporting Project data to an Excel spreadsheet.

[JimS]

I have a Project macro that actives the Excel application, exports data to a
spreadsheet and then performs modifications on the Excel spreadsheet. One
modification I want to make is to freeze the headings. However, when I
execute the following commands,

Workbooks(WWWorkbookName).Worksheets(WorkWeek).Activate
ActiveWindow.FreezePanes = True

Project flags an error "Object doesn't support this property or method". I
thought that the .Activate would make the window with the spreadsheet the
active window. Is there a correct way to make the spreadsheet window the
active window so I can freeze the header or is there a different way to do
this.

Thanks,
--Jim

 

[Jan De Messemaeker]

Hi,

Since activewindow is also a Project object, you will have to add the
reference to the application
Suppose your excel application object is called xlapp then
xlapp.activewindow
gives you excel's active window
HTH