Thread: VBA to deal with Open/Replace/Save as Text file .txt
View Single Post
 
Old 09-07-2017, 11:44 PM
nouking nouking is offline Windows 10 Office 2010 32bit
Novice
  
Join Date: Sep 2017
Posts: 1
nouking is on a distinguished road
Question VBA to deal with Open/Replace/Save as Text file .txt
Hi,
I'm new at forum and I got this problem.
I am trying to run a macro from Task1.xlsx that will open text file from /template/aaa.txt,
then replace 'xxx' in aaa.txt with text in cell A1 in Sheet2 on Task1.xlsx.
Then save as bbb.txt file in /result/bbb.txt with bbb is text in cell A2 in Sheet2 on Task1.xlsx

Has anyone run into the same problem?
Thanks.
Reply With Quote