In the following procedure, how would I specify opening a workbook in the location "My documents" or "Desktop"
How about specifying a location in a server where:
the full name is: "x:\users\acctg\Payable\data\summary.xlsx"
but the name as seen in "My computer" is merely x:\
Do I need to type out the full path?
There must be a efficient way to refer to drive locations. No? Or am I wrong?
Dim target As String
Dim wb As Workbook
target = "d:\summary.xlsx"
Set wb = Workbooks.Open(target)