Change my vba code to save excel file directly to any users desktop not via c drive

Hi Guys,

I am a newbie here. I make macros via the record macros tool.

I made this macro, which will save 7 individual files from 1 excel sheet's data, but i need it to be saved at a folder i specified on a desktop. But the record macros will only take my desktop's path. I read alot over codes for how to fix this, but i am unable to find a way to use their codes without getting bunch of errors. Could someone take my code, and make the few changes that reflect that?

For some of you, its a matter of 2-3 mins, but i have been struggling at this trying to use the special folder path for hours.

Please help me out guys, this is kinda urgent for my college.

Please Login or Register  to view this content.

Originally Posted by AlphaFrog

Try this (not tested).

Please Login or Register  to view this content.

Hey Alpha, i am getting a "subscript out of range" error. What i did was replace my whole code with yours.

Any ideas? Will it help if i upload my file here?