Dear All,
I am importing ms excel files from different locations
I would like to import all sheets but the number of sheets differ from file to file
the VBA function I am currently using :
---------------------------------------------------
Public Function GetPF()
Dim ReportFile, strDate As...