S
sinnetBS
Greetings,
First of all, my apologies - I know similar questions have been posted
but I'm new to complex Macros (have read some of the beginner's site
recommended here, will continue to do so) and am not yet able to figur
out how to do what I need based on other posts.
I have a bunc of delimited text files that were created from Wor
survey forms (I had word "save data only for forms").
I know I can pull each one of these files individually into excel usin
the import command. Is there a way to automate this so i don't g
through the same process each time? In other words, can i just do On
import command instead of importing each file individually? Or I gues
a different way would be, can i pre-combine each text file in such
way that when that one combined file would be imported, excel woul
know to start a new row at x point, etc? I think the first option woul
be better, but if it's not possible, ideas on the second are welcome.
Thanks so much
First of all, my apologies - I know similar questions have been posted
but I'm new to complex Macros (have read some of the beginner's site
recommended here, will continue to do so) and am not yet able to figur
out how to do what I need based on other posts.
I have a bunc of delimited text files that were created from Wor
survey forms (I had word "save data only for forms").
I know I can pull each one of these files individually into excel usin
the import command. Is there a way to automate this so i don't g
through the same process each time? In other words, can i just do On
import command instead of importing each file individually? Or I gues
a different way would be, can i pre-combine each text file in such
way that when that one combined file would be imported, excel woul
know to start a new row at x point, etc? I think the first option woul
be better, but if it's not possible, ideas on the second are welcome.
Thanks so much