1. New Excel files are created with English default sheet names (Sheet1, Sheet2 and Sheet3) and not the local language (Swedish: Blad1, Blad2 and Blad3).
2. When I use the Swedish default names when exporting to a new Excel file the data wind up in Sheet1 for the range of sheets Blad1 to Blad8:
Code: Select all
pagesave(t=excelxml) "k:\stab\test.xlsx" range="Blad1!A1"
pagesave(t=excelxml) "k:\stab\test.xlsx" range="Blad2!A1" 'In Sheet1
pagesave(t=excelxml) "k:\stab\test.xlsx" range="Blad3!A1" 'In Sheet1
...
pagesave(t=excelxml) "k:\stab\test.xlsx" range="Blad8!A1" 'In Sheet1
pagesave(t=excelxml) "k:\stab\test.xlsx" range="Blad9!A1" 'In Blad9