Via access module saving an open .csv

[DKS]

Hi

I have opened a .csv file via Access module using the
"application.followhyperlink address" syntax.

i would like to save and close the opened .csv file (ideally by providing my
own folder name and title for the save).

how could I accomplish that?

Many thanks in anticipation.

 

[John Spencer]

Are you changing the file in any way after you open it? Why are you
opening the file with followHyperLink?

If you just want to move the file and rename it then why open it at all.
Just use the VBA FileCopy procedure.


--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[DKS]

Hi John

I am not changing the file. In fact the file is available for download via
website. Thus I create the necessary url address where the file is found.
And I invoke the address which opens the file in .csv format. However, my
objective is to download the file and not to open it. No problem if it is
opened but then I need to close it with save. Thus the reason for save.

Hope it helps?