I need to create multiple text files from a spreadsheet. I'll explain.....
I have a row in a spreadsheet that looks like this
Server IP Address Subnet Mask Default Gateway
ABC 1.x.x.x X.X.X.X 1.X.X.X
CDF 2.x.x.x X.X.X.X 2.X.X.X
EFG 3.x.x.x X.X.X.X 3.X.X.X
HIJ 4.x.x.x 4.X.X.X 4.X.X.X
............. and so on
I need to create a text file that reads (the file needs to be named server.txt)
it needs to contain the text below: ( file 1 ---> ABC.txt)
Server Name : ABC
Server IP : 1.X.X.X
Subnet Mask : X.X.X.X
Default Gateway : 1.X.X.X
2nd File contain the text below: ( file 2 ---> DEF.txt)
Server Name : DEF
Server IP : 2.X.X.X
Subnet Mask : X.X.X.X
Default Gateway : 2.X.X.X
like this I need to create 250 test files.
Thanks in advance
Bookmarks