Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #9  
Old 10-17-2013, 06:18 AM
daymaker daymaker is offline Merging excel values to text file Windows XP Merging excel values to text file Office 2000
Novice
Merging excel values to text file
 
Join Date: Feb 2012
Posts: 22
daymaker is on a distinguished road
Default

Homework assignment done, I think: I just opened up a blank new spreadsheet, went into VBA, clicked on 'view code' icon in the Project - VBAProject window and pasted your code. I tried to run the macro but it didn't appear in the list until I took out the '0' between parentheses. Once it was removed, I was able to run the macro and have the message box appear.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Loss of formulae values when mail merging excel to word MellowMel Mail Merge 6 05-09-2014 09:08 AM
Merging excel values to text file How to convert a text file to an Excel file with the data format automatically? mradmin Excel 6 10-16-2013 10:34 AM
Merging excel values to text file Handle Text / Numeric values in SSRS while Export To Excel achuki Excel 5 02-07-2012 02:14 PM
How Do I Put Text Values Into A CSV That Excel Will Leave Along? eBob.com Excel 2 05-04-2011 07:01 AM
Merging excel values to text file Merging two Word files with one file having a text box Timothy2001 Word 3 01-23-2011 07:01 PM

Other Forums: Access Forums

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


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