Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 65
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,718
Default 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
|


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
On a DDE Linked worksheet : Copy and Paste Value to a to a file via a macro ? Martin Links and Linking in Excel 0 November 20th 06 11:19 AM
importing a particular excel worksheet into another excel file dinouk Excel Worksheet Functions 0 August 10th 06 02:03 PM
QUESTION: Copy pivottable from excel file to another. Simon Excel Discussion (Misc queries) 0 April 26th 06 10:48 AM
file will not open txskyhawk Excel Discussion (Misc queries) 4 April 19th 06 12:35 AM
Copy and paste special - values into new excel file [email protected] Excel Discussion (Misc queries) 1 October 12th 05 11:02 PM


All times are GMT +1. The time now is 08:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"