Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Copying a file using VBA and Renaming it.

Status
Not open for further replies.
MikeUK

MikeUK

Programmer
Sep 7, 2001
5
GB
I need to find a piece of VBA code that copies a file and then can rename the copied file. Has anyone got any ideas?

thanxs.
 
Sort by date Sort by votes
Use the FileCopy method:
Code: 
FileCopy "C:\temp\old.txt", "C:\temp\new.txt"
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Outlook VBA - Trust access
Replies
3
Views
460
hermanlaksko
hermanlaksko
thanhthanh12
  • Locked
  • Question
Help vba
Replies
3
Views
331
combo
combo
SLW89
  • Locked
  • Question
VBA newbie needs help
Replies
4
Views
287
Andrzejek
Andrzejek
aldi07
  • Locked
  • Question
update a front-end databases with a new release using vba
Replies
2
Views
140
aldi07
aldi07
remeng
  • Locked
  • Question
Excel VBA to Pass Var between file macros after var changes
Replies
13
Views
301
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top