I want to save the file produced from a macro to a specific folder and allow the user to enter the file name.
I have this code already but it is not working correctly.
Dim wb As Boolean
ChDir "J:\Material Type\Report files"
wb = Application.Dialogs(xlDialogSaveAs).Show
It will open up directory J:\Material Type, but won't open up directory J:\Material Type\Report files
Am I missing something or should I be using different code.
Any guidance would be much appreciated.
Thanks
Coop123
I have this code already but it is not working correctly.
Dim wb As Boolean
ChDir "J:\Material Type\Report files"
wb = Application.Dialogs(xlDialogSaveAs).Show
It will open up directory J:\Material Type, but won't open up directory J:\Material Type\Report files
Am I missing something or should I be using different code.
Any guidance would be much appreciated.
Thanks
Coop123