Recent content by Tio_Chiel

Dear All, In my Database [Access 2010] I import a txt file run some processes than export per country to different excel sheets [Excel 2010]. Sofar so good. Then I created an excelsheet with a macro to change layout, add some sums etc. (let call this excelsheet (Layout.xlsm) I would like to...

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...