Good Afternoon All!
I'm using the GetSaveAsFilename Method to grab a workbook path...when the file directory pops up for the user to navigate to the needed file, the directory defaults to show my documents...can I change that? I would like it to default to show the files in the folder that contains the workbook from which this code is running...
Can I do that? Does that make sense?
Thanks,
Jason
I'm using the GetSaveAsFilename Method to grab a workbook path...when the file directory pops up for the user to navigate to the needed file, the directory defaults to show my documents...can I change that? I would like it to default to show the files in the folder that contains the workbook from which this code is running...
Can I do that? Does that make sense?
Thanks,
Jason