I need some VBA help. I am trying to use the getfile method and am looking under the help file. It tells me I need to write a pathspec for the current file I am using, and it says I can make an absolute or relative reference to the file.
I want to make the pathspec for getfilename refer to this file no matter where it is saved on the hardrive so that the code always works despite location of file saved.
Writing this pathspec is what I am unsure of. How do I write an absolute or relative reference for the file I am using?
I want to make the pathspec for getfilename refer to this file no matter where it is saved on the hardrive so that the code always works despite location of file saved.
Writing this pathspec is what I am unsure of. How do I write an absolute or relative reference for the file I am using?