Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-07-2017, 11:44 PM
nouking nouking is offline VBA to deal with Open/Replace/Save as Text file .txt Windows 10 VBA to deal with Open/Replace/Save as Text file .txt Office 2010 32bit
Novice
VBA to deal with Open/Replace/Save as Text file .txt
 
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 VBA to deal with Open/Replace/Save as Text file .txt Windows 7 64bit VBA to deal with Open/Replace/Save as Text file .txt Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,771
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi and welcome
please post your sheet and the code you are using
Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply



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
VBA to deal with Open/Replace/Save as Text file .txt Impossible to open or save attached file Lafayette Outlook 2 04-29-2011 04:41 PM
VBA to deal with Open/Replace/Save as Text file .txt 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 02:35 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft