Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File systems
Hi
I have code in order to look at all the files within a given path. I would like to know how to copy and paste files, i.e. make a copy of a file. From excel using VBA TIA Nathan. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
File systems
Check out the FileCopy statement in VBA help.
-- Jim Rech Excel MVP "nath" wrote in message ... | Hi | | I have code in order to look at all the files within a | given path. I would like to know how to copy and paste | files, i.e. make a copy of a file. From excel using VBA | | TIA | | | Nathan. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
File systems
Hi Nathan,
Trythis Dim FSO As Object Dim oFile As Object Set FSO = CreateObject("Scripting.FileSystemObject") Set oFile = FSO.GetFile("c:\myTest\volker1.xls") oFile.Copy ("c:\myTest\Copy of Volker1.xls") -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "nath" wrote in message ... Hi I have code in order to look at all the files within a given path. I would like to know how to copy and paste files, i.e. make a copy of a file. From excel using VBA TIA Nathan. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW TO GET TRACKING SYSTEMS | Excel Worksheet Functions | |||
How can I access a SAS systems file and save it in Excel | Excel Discussion (Misc queries) | |||
Any Systems Analysts here? | Excel Programming | |||
Distributing a VBA app across different systems, help please | Excel Programming | |||
Getting the systems username | Excel Programming |