Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Copy File from local PC to web folder

Status
Not open for further replies.

RBCDS

Technical User
Apr 6, 2001
24
CA
I have a file on our network that needs to be posted to the web weekly. Does any know how I can do this through VBA code. Below is what I tried with no avail.


Dim myFile As FileSystemObject
Set myFile = CreateObject("Scripting.FileSystemObject")
myFile.CopyFile "\\root\folder\file.txt", "

Thanks

Dan
 
What is the semicolon following the command for? Couldn't be something that simple right?
-------------------------------------
scking@arinc.com
Try to resolve problems independently
Then seek help among peers or experts
But TEST recommended solutions
-------------------------------------
 
I don't have a semi-colon in my code I guess I typed that in the response from Java habits. I've gotten the code to work on my local machine but not to a web folder.

Dan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top