So I'm sure this is an easy one but I'm not sure how to really go about it as I'm fairly new to VBA. I have a line of code in the beginning that references a file name. I would like to be able to set a name or value for this file so that when I ever run this Macro I would only have to change the target or reference to that file rather than have to change it everywhere it appears in my code. This is my failed attempt at this:
Set wb = Workbook("F:\Accts\Invoice\2011\92999_3-1-2011.xls(1).xls")
Workbooks.Open "wb"
I'm not sure if it's my naming or referencing that's keeping this file from opening or the way I'm trying to open it.
Bookmarks