ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Copy File from activecell (https://www.excelbanter.com/excel-discussion-misc-queries/122556-copy-file-activecell.html)

FIRSTROUNDKO via OfficeKB.com

Copy File from activecell
 
Hi

If have the complete filepath in range("A1")

i,e

C:\copyme\copyme.xls

How do I copy the file to

C:\test

Thanks In Advance

Darren

--
Message posted via http://www.officekb.com


Jim Rech

Copy File from activecell
 
Check out the FileCopy function in VB help.

--
Jim
"FIRSTROUNDKO via OfficeKB.com" <u15639@uwe wrote in message
news:6ab66bdf28c2c@uwe...
| Hi
|
| If have the complete filepath in range("A1")
|
| i,e
|
| C:\copyme\copyme.xls
|
| How do I copy the file to
|
| C:\test
|
| Thanks In Advance
|
| Darren
|
| --
| Message posted via http://www.officekb.com
|




All times are GMT +1. The time now is 10:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com