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 to open the "country excelsheets" one by one which should open the macro from Layout.xlsm to change the layout in the sheet then save and quit. So at the end all the country sheets have the same layout.
If this is possible already per sheet in MSAccess 2010 though coding during the export command that is naturally also fine.
I hope someone has a solution that will save me some time
Thank in advance,
Tio_Chiel
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 to open the "country excelsheets" one by one which should open the macro from Layout.xlsm to change the layout in the sheet then save and quit. So at the end all the country sheets have the same layout.
If this is possible already per sheet in MSAccess 2010 though coding during the export command that is naturally also fine.
I hope someone has a solution that will save me some time
Thank in advance,
Tio_Chiel
