Copy file using VBA

[ajocius1]

I have some reports delivered to network drive by accounting system. File location is different every time based on date, report number, etc. I managed to get the path of the file generated by excel macro. All I need now is to copy the file from path_A to path_B. Path_A is in Range("A1") and path_B is in Range ("A2"). I hope I can do this using VBA. By the way, path_A is on the network and path starts with \\server_name\Folder.... if that has any impact to macro script.

[ravishankar]

HI
Try

Please Login or Register  to view this content.

Ravi

[ajocius1]

it can't be that easy thanks a lot! I tried file copy and could not get any help on this. Didn't think of filecopy (without space )