Upload Source File from User desktop to Server

[JenSGT]

How do I build a form which only requires User to enter the source file pathname (by browsing windows folders & files to get the pathname), display the source file pathname in a textbox. Then when User enter the upload button, it will automatically upload the file from source location to destination location (server) and rename the source file to the naming convention i require (ie. z:\archive\Letter1.doc)

What is the complete code, require to do this task?

TIA....

Select Source File Pathname​

Upload​

Browse……

 

[Banana]

Look into FileDialog object and VBA's Copy method.

 

[JenSGT]

Hi Banana,

Appreciate if you could pass me the full code.

I have no clue on how to go about it...


Tks

 

[Banana]

The information is available and can be searched by googling.

Here's one article on FileDialog Object

Google on Copying a file in VBA

Also, for more reference, look in the help files by using VBA Editor's help search (in the upper right corner); the help files are more extensive in VBA Editor compared to Access's help files, and you should be able to find several examples.

Good luck.

 

[JenSGT]

Thanks,

I found the code to execute this function.