Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

Reply
 
LinkBack Thread Tools Display Modes
  #1  
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
  #2  
Old 09-12-2017, 12:00 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 1,937
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice
Default

Hi and welcome
please post your sheet and the code you are using
Thx
Reply With Quote
Reply

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 10:47 PM.


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