Save as thisworkbook vba

[Undo]

Hello

I have userform, user will write text in textbox1, then he will click button1

i want code for button1

that code for SAVE AS thisworkbook in user desktop, excel file name will be textbox1 value

note : save as, not normal save

thats all

thanks

[JLGWhiz]

This goes into the UserForm code module.

Please Login or Register  to view this content.

[Undo]

thanks.. i will change xlsx to macro file.. will i need to change file formate number?

also i think the desktop deriction not coorect
. after C we have users folder.. then current user folder..then desktop

thx

[JLGWhiz]

thanks.. i will change xlsx to macro file.. will i need to change file formate number?

also i think the desktop deriction not coorect
. after C we have users folder.. then current user folder..then desktop

thx

You need to include these bits of information in your original post so they can be included when the code is developed and save time for all of us. You can if the file is .xlsm currently then just delete the 'FileFormat' part of the statement and make the change to the .xlsx. The FileFormat is not needed if you are saving as the same file format as the original. It is needed if you change the file format. I have no idea how your Desktop is loaded into the directory structure, you can check that out and make that change. Outside of those issues, it should work OK.