copy a file to a web site

[focus10]

how can i copy a file (by vba) to a folder placed in a web site, using username and password

thanks

 

[harmankardon]

What protocol are you using, FTP, HTTP ?

 

[focus10]

web site protocol is https

 

[DJkarl]

I would take a look at this.
http://www.chilkatsoft.com/upload-activex.asp

 

[harmankardon]

I think WinHTTP might be of help to you but unfortunately I can't offer any help on how to use it. Maybe someone else can elaborate?

 

[Simon_MT]

Personally, I would do this manually.

The database could get corrupted of the transfer be incomplete and the web database would be compromised.

I usually, rename the transfer the new database to something with new in the name. Renane the existing database as sonething with old in the name and then rename the new database to the web version.

The larger the database, the less time for the database to be refreshed.

Simon