Save File for Each Row

[rjj920]

Hello, I'm hoping you guys can help me out with a macro that will save each row in Excel as a separate file. The filename will be the CellValue of Column 1 and the contents of the file will be the CellValue of Column2. The extension needs to be ".sps"

I am just learning VBA through a lot of trial and error with recording macros, but this one has me seriously stuck!

Example

a1 001 b1: dog
A2 022 b2: cat
A3 051 b3: donkey
A4 006 b4: moose

file1 = "001.sps" and inside the document it would say "dog"

Thanks!

Ron

[mgs73]

Try this:

Please Login or Register  to view this content.

[mehmetcik]

As far as I can see, Excel cannot save as an sps file.

However SPSS can open an xls file.

BRB

[mehmetcik]

As far as I can see, Excel cannot save as an sps file.

However SPSS can open an xls file.

BRB

Please Login or Register  to view this content.

[rjj920]

This was perfect. Thanks, MGS! You are a genius!!!