Vba to copy a file from a network path and place it to another network path location

**ROHAN999** · 09-11-2018, 11:31 AM

Can someboday provide me a code which ask to browse a file then paste that file to a given network location path

Plz assisst

**CK76** · 09-11-2018, 12:30 PM

Use FileCopy or Name.
Ex:

Please Login or Register  to view this content.

Combine it with FileDialog to allow browsing/selection.

Something like below for copy files.

Please Login or Register  to view this content.

If moving file(s) to another location... use Name instead of FileCopy

Please Login or Register  to view this content.

**ROHAN999** · 09-11-2018, 12:48 PM

mid code i am using but thats giving compilation error:

FileCopy .SelectedItems(i), dest & "\" & x

"constant expression required"

where to put fix destination path

**CK76** · 09-11-2018, 12:59 PM

Below line. Edit "C:\Test" to your actual destination.

Please Login or Register  to view this content.

It should be at beginning of the code.

**ROHAN999** · 09-11-2018, 01:20 PM

HTML Code:

using it like this but only sir but the same error

**CK76** · 09-11-2018, 01:35 PM

Hmm? Works fine on my end.

Try changing Const ... line to something like...

Please Login or Register  to view this content.

**ROHAN999** · 09-11-2018, 01:41 PM

yes sir now its working fine

can we add a msg box to display that pasting complete ...

**CK76** · 09-11-2018, 01:55 PM

Just put msgbox code after End With.

Something like...

Please Login or Register  to view this content.

**ROHAN999** · 09-11-2018, 02:02 PM

thanx alot sir

**ROHAN999** · 09-12-2018, 02:13 AM

FileCopy .SelectedItems(i), dest & "\" & x

Now its giving error here: compile error
Argument not optional

Kindly assist

**CK76** · 09-12-2018, 08:29 AM

I can't replicate your issue on my end.

Try constructing string prior to using it in the argument?

Ex:

Please Login or Register  to view this content.

**ROHAN999** · 09-12-2018, 01:09 PM

Ok sir thanx issue resolved

Vba to copy a file from a network path and place it to another network path location

LinkBack

Thread Tools

Rate This Thread

Display

Vba to copy a file from a network path and place it to another network path location

Re: Vba to copy a file from a network path and place it to another network path location

Re: Vba to copy a file from a network path and place it to another network path location

Re: Vba to copy a file from a network path and place it to another network path location

Re: Vba to copy a file from a network path and place it to another network path location

Re: Vba to copy a file from a network path and place it to another network path location

Re: Vba to copy a file from a network path and place it to another network path location

Re: Vba to copy a file from a network path and place it to another network path location

Re: Vba to copy a file from a network path and place it to another network path location

Re: Vba to copy a file from a network path and place it to another network path location

Re: Vba to copy a file from a network path and place it to another network path location

Re: Vba to copy a file from a network path and place it to another network path location

Thread Information

Users Browsing this Thread

Similar Threads

vba code to open xlsm file from Network Path

Excel VBA get Network path from local path

Copy files from VM Ware to the local or the network path usign Excel Macro

Changing path to a network location

Network Drive Path

[SOLVED] Path to a network drive

Help with path for shared folder on network

Bookmarks

Bookmarks

Posting Permissions