Excel VBA Macro: Save As Dialog (Allow User to Select Saved File Location)

@greggowaffles fantastic video as usual - just a question though - I used your codes and everything seems working until i receive a prompt, immediately after i select a location and hit Save, saying " a file named 'FALSE.xlsx' already exists in this location. Do you want to replace it". My feeling it has something to do with the if-statement or i could be wrong. Any suggestion?

Greg, That was awesome, you went at a good pace and it was very clear. Can you do the same thing but create a folder rather than a workbook?

the file is not found after saving huhu

Excuse me sir..
i want to ask about the Formulas..

how to prevent formulas from being carried over to the workbook, or not link to master workbook..

thank you before ..

Good Video! Appreciated the slower pace by typing out the code and them demo the results; then making changes and demo the changes. This is what I was looking for allow the user to get a copy of the sheet, but he can select the filename and path.

Vba will have scope in future bcoz I want to switch my career towards vba