Search results

  1. T

    VBA change Layout for all excelsheet in a folder

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

    Sheet exists using Ms Access

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