Forum

VBA Code to open a ...
 
Notifications
Clear all

VBA Code to open a text file and save it to another folder as a text file replacing an existing file of the same

2 Posts
2 Users
0 Reactions
111 Views
(@rjplunkett)
Posts: 3
Active Member
Topic starter
 

I am writing VBA Code to open a text file and save it to another folder as a text file replacing an existing file of the same name.  What code do I need to have it "replace" the existing file?

 
Posted : 25/06/2024 10:49 am
(@keebellah)
Posts: 373
Reputable Member
 

The code wil have to check if the file is present in the target folder, if it is, the use the command kill fullfilename (this means path AND filemname) and the save the new file

 
Posted : 26/06/2024 3:39 am
Share: