PDA

View Full Version : Exporting specific data to seperate files



Mr_Mod
06-19-2013, 06:54 PM
I have a work book that contains numerous sheets where all sheets are in the same format.
What i would like to do is have a drop down selection which contains each sheets name. This will create a folder in "my Documents" where 2 other files will be created. These files will be aas follows;
File 1
The text that is in column "E" rows 6 through to row 133 as a file called "preset.txt"

File 2
The text that is in column "G" rows 6 through to row 133 as a file called "data.hex"

Now some of these rows are blank in column "E" so i would want to skip that and move to next row, however column "G" may have data in that row which i would want to skip as well.

Is this doable in VBA, i know how to create a form with drop downs but have no idea how to be able to populate the drop down list from the sheet tab name or go about exporting data.

Any suggestions would be appreciated

stanleydgrom
06-20-2013, 04:24 AM
Mr_Mod,

See if something below will assist you:
Jerry Beaucaire's - Excel Assistant (https://sites.google.com/a/madrocketscientist.com/jerrybeaucaires-excelassistant/)

Parse Functions
https://sites.google.com/a/madrocketscientist.com/jerrybeaucaires-excelassistant/parse-functions

Mr_Mod
06-20-2013, 06:23 AM
Thanks for the link, taking a look it does not appear to be what im looking to do.
I can manage to create the folder, but cannot figure out how to create the file and skip any missing rows. Spent ages searching here to see