Importing Excel via FTP

[VergeResources]

I have an Excel worksheet that imports data from another Excel worksheet. The imported worksheet is accessed via ftp. Works great the first time.

However, when I ask it to refresh data at a later date (or another user tries to refresh), it seems to modify my query.

The data source that was originally:
Data Source=ftp:\\mysite.state.oh.us\ardexport\iarpebbp.xls

is changed to:
Data Source=C:\DOCUME~1\MuskopfS\LOCALS~1\Temp\msoDF106.xls

It doesn't give an error message, it just doesn't populate the worksheet with the latest info. Anyone have ideas on how to keep it referencing the ftp site?

 

[SkipVought]

Hi,

Macro record EDITING the import.

Instead of doing a Refresh, run the recorded procedure.

Skip,
[sub]
[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine![/sub]

 

[SkipVought]

...I should have added...

check to make sure that the connect string has your FTP:\\...

Skip,
[sub]
[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine![/sub]