Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel.SaveAs() problem any ideas?
Message
From
15/01/2003 18:43:35
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
09/01/2003 15:58:46
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00740015
Message ID:
00742174
Views:
12
>I have an application that uses an excel template file. This is on our server that is LAN/WAN connected to the end-users. A VFP form, textbox is used to allow the user to change the directory. All had been working well, but now there is some odd behavior.
>Entering C:\ABC.XLS works fine on both the LAN and WAN connections.
> D:\ABC.XLS works fine on both the LAN and WAN connections.
> A:\Directory\ABC.XLS works fine on the LAN (Not tested on WAN)
> A:\ABC.XLS OLE Errors on both LAN and WAN
> A:ABC.XLS works on LAN but errors on WAN
>
>The template file was recently updated and is full of macros. Could the macros becausing this strange behavior?
>We are going to test this theory as soon as we can by replacing the template XLS with the old one.
>
>TIA
>
>Harold

You don't happen to have spaces in folder and/or filenames, perchance?

It also occurs to me that diskettes are often unreliable. Perhaps your diskette just happened to have a defect in one particular place...

Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform