Create text file named after a cell containing other cell data
- by user143041
I tried using the code below for the Excel program on my `Mac Mini using the OS X Version 10.7.2 and it keeps saying Error due to file name / path: (The Excel file I am creating is going to be a template with my formulas and macros installed which will be used over and over).
Sub CreateFile()
Do While Not IsEmpty(ActiveCell.Offset(0, 1))
…