Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Windows7, VFP9 and Excel
Message
 
To
26/07/2011 11:27:37
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01518966
Message ID:
01519210
Views:
58
The exe and supporting files (data and xls) are all located on a file server on a Windows 2003r2 server.

The directory structure is simple - the exe in the main folder, with tables in the "data" subdirectory and spreadsheets in the "xls" subdirectory. In the xls subdirectory is a spreadsheet that is used as a template.

The program takes input from the user on a simple screen, crunches data, loads the template spreadsheet, updates the data in the spreadsheet then saves it as a new file in the same XLS directory.

I'm fairly certain the problem revolves around the spreadsheet. The program does use a fully qualified path when referencing the template spreadsheet and the output file name. At this writing the template spreadsheet does open but the problem appears to come up when it is time to save the updated file.

Hope this helps clarify....

>OK, let me clarify. Is it in Program Files or Windows?
>
>>The Excel template is in a subdirectory (under the exe). The template is in the same directory that the result file is saved in.
Margaret Duddy
mmd@outformations.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform