VBA to deal with Open/Replace/Save as Text file .txt

		Microsoft Office Forums > Microsoft Excel > Excel Programming
VBA to deal with Open/Replace/Save as Text file .txt

FAQ

Thread Tools

Display Modes

09-07-2017, 11:44 PM

nouking

Windows 10 VBA to deal with Open/Replace/Save as Text file .txt

Office 2010 32bit

Novice

Join Date: Sep 2017

Posts: 1

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I changed OneDrive properties and now all Office apps crash on file open/save browsing	PMAAdmin	Office	4	04-23-2017 10:54 AM
Word for Mac 2011: Change default open/save file locations?	cglenn	Word	0	06-01-2015 10:34 AM
Unable to File>Save As.. or Open in Word 2010, please help	BrokenComputer	Word	0	03-07-2012 10:20 PM
Impossible to open or save attached file	Lafayette	Outlook	2	04-29-2011 04:41 PM
Word Macro: Save file as text with current file name	jabberwocky12	Word VBA	2	10-22-2010 12:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:56 PM.