Upload/SaveAs/FileCopy to HTTPS

  • Thread starter Thread starter Stephen sjw_ost
  • Start date Start date
S

Stephen sjw_ost

In Excel, I can use;

ActiveWorkbook.SaveAs
"https://cards.collaborationtools.consumer.citigroup.net/sites/Jax-OST/PassCounts/JAX Pass Counts.xls"

to save an Excel file to an HTTPS location.

How can I do the same thing with Access?
There is no FTP involved to my knowledge.
I want to be able to save a file of my choosing to an HTTPS location using
Access. I have code to identify a file and put the full path&file name into
a textbox.
All I need to figure out now is how to save the identified file to the
static HTTPS location.
Please help.
Thank you in advance for any assistance.
Stephen.
 
I think that won't work, because typically you can't copy files over
the HTTP (or HTTPS) protocol.
The OP can use FTP protocol to copy the file, or XMLHTTP to post the
contents of the file to an appropriately programmed page that can
receive those bytes and write them out as a file.

-Tom.
Microsoft Access MVP
 
Yeah, I tried FileCopy to the HTTPS location and got;
Run-time error '75':
Path/File access error
I would be interested in atempting to FTP. Could I ask to be directed to
some sample code on how to FTP? I can at least try it to see if I can get the
desired result.

Thank you for your response.
Stephen
 
On Mon, 5 Jan 2009 13:13:03 -0800, Stephen sjw_ost

Type "FTP VBA" in a search engine and you should have no trouble
locating some code samples.

-Tom.
Microsoft Access MVP
 
Well, I looked up everything I could on FTP and have found that FTP will not
do what I am wanting/needing with the system my company is using.
I will have to find another route.

Thank you for your replies and assistance.
Stephen
 
I mapped the back end of the HTTPS to a drive letter and was able to use
FileCopy with no problems.

Thanks for all of your help
Stephen
 
Back
Top