Variable Macro
I am trying to create a macro with a file name variable. The code I have
written doesn't seem to work, any ideas!
Dim ImportDir As String
Dim ImportFile As String
ImportDir = Range("a17").Value
ImportFile = Range("b17").Value
Windows("ImportFile").Activate
Sheets("Top 10 month").Select
|