| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy file from Excel
Hi! Is there a funcion in VBA that allows me to copy a file from on location to another ?? Like: copy C:\file D:\Temp\file Thanks in advance, Chri -- loopo ----------------------------------------------------------------------- loopoo's Profile: http://www.excelforum.com/member.php...fo&userid=2879 View this thread: http://www.excelforum.com/showthread.php?threadid=49222 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy file from Excel
FileCopy "Source", "Destination"
-- HTH... Jim Thomlinson "loopoo" wrote: Hi! Is there a funcion in VBA that allows me to copy a file from one location to another ?? Like: copy C:\file D:\Temp\file Thanks in advance, Chris -- loopoo ------------------------------------------------------------------------ loopoo's Profile: http://www.excelforum.com/member.php...o&userid=28792 View this thread: http://www.excelforum.com/showthread...hreadid=492221 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy file from Excel
Hi,
Yes, you can use the native VBA function "FileCopy" like this vba.FileCopy "C:\file", "D:\Temp\file" (or you can use the FileSystemObject) HTH Philip "loopoo" wrote: Hi! Is there a funcion in VBA that allows me to copy a file from one location to another ?? Like: copy C:\file D:\Temp\file Thanks in advance, Chris -- loopoo ------------------------------------------------------------------------ loopoo's Profile: http://www.excelforum.com/member.php...o&userid=28792 View this thread: http://www.excelforum.com/showthread...hreadid=492221 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy file from Excel
Thank you for your help, Chris -- loopoo ------------------------------------------------------------------------ loopoo's Profile: http://www.excelforum.com/member.php...o&userid=28792 View this thread: http://www.excelforum.com/showthread...hreadid=492221 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy 2007 excel file formula results into a 2003 Excel file | Excel Discussion (Misc queries) | |||
| How do I copy a excel file into a InDesign file correctly? | Excel Discussion (Misc queries) | |||
| copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro | Excel Programming | |||
| EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel | |||
| VBA Macro to copy an column from one Excel file into another file | Excel Programming | |||
![loopoo[_21_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
