Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

LinkBack Thread Tools Display Modes
Old 09-07-2017, 11:44 PM
nouking nouking is offline Windows 10 Office 2010 32bit
Join Date: Sep 2017
Posts: 1
nouking is on a distinguished road
Question VBA to deal with Open/Replace/Save as Text file .txt


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?
Reply With Quote
Old 09-12-2017, 12:00 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,146
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice

Hi and welcome
please post your sheet and the code you are using
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Reply With Quote

Thread Tools
Display Modes

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

All times are GMT -7. The time now is 12:41 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft