How to save worksheet with userform control button

Hi All

I've searched for hours, and sorry that I could not find anything that suits, or works in my case.

I am trying to save a worksheet ("Blinds Quote") with the filename as the value in "C2", in a folder ("Customers") on the desktop, via a command button on a userform. If at all possible, I would also like the saveAsdialog box to appear with the filename and destination already populated, so that the user can check, or change these fields, if needs be. All he has to do then is press 'save'. A returning message saying that the save has been successful would be good.

I am using Win7 with excel 2007.

Thanks everyone for your time and efforts to keep us dummies happy.

Fremarco

Hi,

1 - Place an active commandbutton on your sheet.

2 - Insert this code into the sheet module (You open the sheet module by right clicking the sheet tab and press view code)

Please Login or Register  to view this content.

3 - Set the save as file name in same sheet in range "C2"

4 - press the button

Ok, then remove Ptrsafe, Ptrsafe is only for 64-bit version of excel

Still the same line?

Try uploading a sample workbook and ill give it a go.

Try this, just press the button.

Sorry, missing a bit

This works.

Please Login or Register  to view this content.

Try and debug, maby the folder path doesnt exist, this could be that your user folder is named fre.macro and getUserName returns fremacro,
Just a suggestion. Have you tried setting a debug point and controlling that the variable holds the expected value?

This you can do by editing this line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Glad i could help