Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Windows7, VFP9 and Excel
Message
From
26/07/2011 11:59:33
 
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:
01519212
Views:
56
Ah ha! I think you have the solution. Use the fully qualified path, from the point of view of whatever machine is running the VFP app.


>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....
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform