Excel VBA, Get Current File Path and Name
In this article I will explain how you can get the current path and name of the file you are working with.
The file path can be obtained using the code below:
Get File Name:
The file name can be obtained using the code below:
- VBA Save File Dialog, FileDialog(msoFileDialogSaveAs)
- Excel VBA Save File Dialog, GetSaveAsFilename()
- Excel VBA Open File Dialog