Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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). |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA: Where to find Excel Object model? | Excel Discussion (Misc queries) | |||
"Excel.Application" Object Model | Charts and Charting in Excel | |||
Docs for Excel object model with p/e/m | Excel Programming | |||
Subtotals in Excel object model | Excel Programming | |||
Diplaying Excel Application through Object Model | Excel Programming |