LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default How Do I Use List Box for VBA Script that Converts Excel Files to Any FIle Type?


Bob Phillips wrote:
"socrtwo" wrote in message
ups.com...
Thanks for staying with this. BTW, I'm using Excel 2003.



Shouldn't be material.

The form itself has a different name. It's named lbForm. Does that
matter? Should it appear on its own or do I have to make it appear
with a line of code?



Shouldn';t be material.

I have posted an example at http://cjoint.com/?kxoJLUfCWS


Nice form. Thanks for the help. I've got a new problem, so I'm starting
a new thread. It appears that if I choose any of the Excel formats and
not csv, the script simply produces multiple copies of the original
file instead of exporting each worksheet separately.

 
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
Pasting HTML script to Excel 2007 converts the cells format to 'General' DileepReddy Excel Discussion (Misc queries) 0 January 25th 12 06:54 AM
when i type in 0 in excel 2000 it converts into -1 Mona Excel Discussion (Misc queries) 5 May 10th 06 09:44 PM
when i type in 0 in excel 2000 it converts into -1 Mona Excel Discussion (Misc queries) 0 May 10th 06 08:32 PM
Why if I type in 51570.6213 Excel converts it to 51570.5213999999 chd Excel Discussion (Misc queries) 5 April 9th 06 02:51 AM
How do I change file/open/"files of type" to default to "all file. How do I changefiles of type default Excel Discussion (Misc queries) 1 April 19th 05 10:45 PM


All times are GMT +1. The time now is 07:04 AM.

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"