LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Export TXT from wksht selected in ComboBox

I have 30+ worksheets that contain formula values for export (as space
delimited txt files). w/ a UserForm I want the user to choose 1 worksheet
from a ComboBox and press 1 of 2 cmd buttons

cmd button 1 - go to sheet
cmd button 2 - export txt file - to location of choice

--- tricky part
All worksheets have varying # of rows and I'd like to avoid exporting rows
like the 2nd row below:
---
M-SYMB-P100 92 CONTINUOUS 0.50
M- #N/A #N/A #N/A
---
Thanks for any help
--
JS
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to count the number of selected combobox within Excel? Eric Excel Discussion (Misc queries) 10 June 30th 09 09:20 AM
1st 2 rows of wksht show up @ top of each page of the wksht Remote Paralegal Excel Discussion (Misc queries) 2 October 6th 08 07:59 PM
Print only selected data from ComboBox? yangjay Excel Discussion (Misc queries) 1 July 14th 06 06:23 PM
get all sheet names in comboBox of activeworkbook and export when selected ilyaskazi[_26_] Excel Programming 5 June 14th 05 02:49 PM
Put a checkbox beside each chtobj's and then export selected to powerpoint Gunnar Johansson[_4_] Excel Programming 0 May 3rd 05 06:34 AM


All times are GMT +1. The time now is 01:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"