<HR style="BACKGROUND-COLOR: #ffffff; COLOR: #ffffff" SIZE=1><!-- / icon and title --><!-- message -->
I have a spreadsheet with 10 worksheets in it. There are 4 worksheets named Sheet1 - Sheet4 which have 2 columns.
Resolution Eventid
a abc
b def
c efg
d hij
How would i create a VBA script to extract the content of each individual cell under Resolution add it to a text file and save the text file as the eventid cell content.
So for example the first text file to be created would contain text:
Resolution Description:
a
And the filename of the txt file shoud be abc.txt. I would like the script to go through each row and save the file in C:\temp
Any help would be much appreciated.
I have a spreadsheet with 10 worksheets in it. There are 4 worksheets named Sheet1 - Sheet4 which have 2 columns.
Resolution Eventid
a abc
b def
c efg
d hij
How would i create a VBA script to extract the content of each individual cell under Resolution add it to a text file and save the text file as the eventid cell content.
So for example the first text file to be created would contain text:
Resolution Description:
a
And the filename of the txt file shoud be abc.txt. I would like the script to go through each row and save the file in C:\temp
Any help would be much appreciated.
