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:
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)