SaveAs workbook with prompt and autofilled name

[dombish]

Hi,

I am currently working on a bit of code that prompts the user to a SaveAs form that has a prepopulated Filename coming from a cell in the workbook. The user should be able to choose the path to which the WB is saved. After that the wb should close and the display should switch to another workbook.

The problem is that the NewWB is not actually saved. Can anyone help, please?

Here my code:

Please Login or Register  to view this content.

[6StringJazzer]

There is no code there that saves the workbook. This additional line will save the active workbook--is that the one you want to save?

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

[dombish]

Hi Jeff,

Thank you for your quick response and for reminding me of rule #3 - I must have overseen that one in the heat of the moment.

The code works as in that I do not get any error msg. However, the file that is saved does not have the appropriate name: the file is saved as FALSE.xlsx instead of NewWB_ + value from J1. Do you have an idea how to fix this?

Many thanks,
Dominik

[Kevin#]

another way to achieve what you want

Please Login or Register  to view this content.

[6StringJazzer]

...the file is saved as FALSE.xlsx instead of NewWB_ + value from J1. Do you have an idea how to fix this?

This suggests that the user is hitting Cancel instead of selecting a folder. That's the only way I can think of that sFileSaveName can be FALSE.

Kevin# also has a good alternative.