Help! I have a macro where I am opening an excel workbook from a network drive and coping the contents of a sheet to a sheet in my active workbook. Today I discovered that the folder name where that workbook will be located has the possibility of changing from time to time. This is because the folder name contains the revision level of the file (third line in example below).
Can I use a wildcard in my call out?
Currently my code is this:
Code
Dim wbkFrom, wbkTo As Workbook
Set wbkTo = ActiveWorkbook
Set wbkFrom = Workbooks.Open("R:\Masters\777\Software\7770239 Rev A")
wbkFrom.Sheets("Jigs").Range("A1:H500").Copy
wbkTo.Sheets("Jigs").Range("A1").PasteSpecial (xlPasteValues)
Display More
Thanks.