Open excel file from program directory?

[-Juha-]

Hello,

I use this command to open excel file:

 Excel_Rpt_WorkbookOpen (appHandle, "C:\\Users\\SSUControl\\SSU.xls", &workbookHandle) ;

Problem is that when i copy program somewhere else, it doesn't find that file.. Is there any way to make that code so that it would always open that file from same directory than program?

[RobertoBozzolo]

Have you tried to pass to the function the filename only? It could open it assuming it is in the program directory.

Otherwise you can use GetProjectDir to obtain your executable pathname, then pass it to MakePathName together with your filename to build the pathname of your excel file.