ThisProject.path

[nick1000]

Hi,

I'm exporting data from Project into excel and set up macros to run through
the export process.

this works fine, if I specify the fill path as FileSaveas "C:........."

But I'm trying to save the file in the same path as the project is saved in
- so using FileSaveas ThisProject.Path & {"filename"}. The project file is
saved to my desktop, but the output file is being saved in the same location
as ....Windows/MS Project

Any ideas on where I'm going wrong??

Thanks
Nick

 

[Jan De Messemaeker]

Hi,

Activeproject.path will be bettre

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[nick1000]

Thats resolve my problem.

Many thanks Jan.

Hi,

Activeproject.path will be bettre

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf