ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel object model (https://www.excelbanter.com/excel-programming/310275-excel-object-model.html)

Alan Hutchins

Excel object model
 
I have a report that uses VBA to obtain data from a
database (which works no problem), and then copies the
sheets to a new workbook, and saves the new workbook with
a pre-defined name, and then closes the new workbook and
original workbook.

This works fine in any part of our organisation that uses
UK or US English, but when it gets to France (where they
use the French version of Excel), it seems to encounter a
problem during the New workbook creation process.

I have added some code to my report that should help the
user in France to identify precisely where the problem is
occurring.

My question is :

Is the French version of the Object model exactly the
same as the UK/US English version in terms of naming
convention ?

The reason why I ask, is that it might be the case that
the code used may not always use the Excel Object model
terminology (e.g Sheets(1) instead of Sheets("start")
etc).


All times are GMT +1. The time now is 10:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com