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
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