Following your idea, this code works well but it's crappy !
Just an average grade, maybe 12/20 … Why ?
'Cause first, Copy / Paste is not coding !
And read inner VBA help is not a waste of time !
If you had read for example Print # help, you'd see another statement
that do not need any conversion for double quotes neither comma insertion ‼
All is written black on white in the book (inner VBA help) !
Respecting TBTO rule, code needs only 3 variables :
one for the output file number, one for the rows loop,
one for the columns loop and that's all folk !
Don't forget With statement !
By following GetSaveAsFilename help - very beginner level - one more variable for the file
and thus reaching a 20/20 grade …
Bookmarks