I have a VFP7 program that is generating Excel Spreadsheet and Set the
Default File Path to
a specific location based on some Region Setting.
For example for Central Region, program has:
oExcel.DefaultFilePath="\\lrd1fil1\gei\central\"
for north West ,
oExcel.DefaultFilePath="\\lrd1fil1\gei\nwest\"
and so on.. where \\lrd1fil1 is a Server under Citrix
It seems to work ok when tested locally, but When the program work under
Client Citrix,
First time the Save As seems to remember the last Default location of the
Prior Excel
Spreadsheet that was generated. But when you recreate the Same Spreadsheet
the 2nd time,
it sets it correctly
Note: when looking at the Default file location from Options under
general Tab of the Spreadsheet, the setting
is always correct.
It is Just when using File/Save As, it remembers the last file
location from prior Spreadsheet
Anyone has any Ideas?
Thanks,
jhhaidar@sbcglobal.net
jjhaidar@arkbluecross.com