Macro To Save Worksheet into same directory as workbook

Hi

Could someone help me with this?

I am trying to write a macro that will save my active work sheet in to a folder called Saved Files in the same directory that my work book is. I can just use the C:/ but the file is on a server and every one that uses it may have a different path.

I have a code but I can’t seem to get it to work, I also have to add the active sheet name to this code, would it be possible to have a code that will save the active sheet using that sheet name into a folder called Saved Files in the same directory?

Please Login or Register  to view this content.

Hi

I have got this code working

Please Login or Register  to view this content.

What this code is doing is saving my worksheet called Order Form into the same directory i am working in. What i need is to change this code so it saves it into a folder called "Saved Files" in the same directory. Also if it can be done i would like a macro that would save the file as the worksheet name instead of me having to put that in as in Order Form.

Thanks