How to get full folder path in variable? and To run the excel macro, macro needs full path of file, how we can provide full path of specific file?

Hi Team,

As I’m working with excel macro, In that excel macro code I want to provide a specific full file path and specific full folder path in different variables, so how can I provide it? also, I don’t want to a hardcore path to any variable and pass it to the macro, can anyone suggest how can I achieve this?