| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SheetsInNewWorkbook
Hi Rob,
The error message translated from dutch error msg: Error 1004 Method 'Sheetsinnewworkbook' from object '_Application' failed Your option Set wbTarget = Workbooks.Add(xlWorksheet) works. Tnx! Gr. ROn... BTW: How can i create a workbook with 2 sheets? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SheetsInNewWorkbook
Hi/Hoi Ron
BTW: How can i create a workbook with 2 sheets? You must use SheetsInNewWorkbook I go install a Dutch 97 version now to test it for you I be back -- Regards Ron de Bruin http://www.rondebruin.nl "ROn..." wrote in message ups.com... Hi Rob, The error message translated from dutch error msg: Error 1004 Method 'Sheetsinnewworkbook' from object '_Application' failed Your option Set wbTarget = Workbooks.Add(xlWorksheet) works. Tnx! Gr. ROn... BTW: How can i create a workbook with 2 sheets? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SheetsInNewWorkbook
Hi
I try it on a Virtual PC with The Dutch version of Excel 97 and it is working correct there. Is there other code in the sub ? -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Hi/Hoi Ron BTW: How can i create a workbook with 2 sheets? You must use SheetsInNewWorkbook I go install a Dutch 97 version now to test it for you I be back -- Regards Ron de Bruin http://www.rondebruin.nl "ROn..." wrote in message ups.com... Hi Rob, The error message translated from dutch error msg: Error 1004 Method 'Sheetsinnewworkbook' from object '_Application' failed Your option Set wbTarget = Workbooks.Add(xlWorksheet) works. Tnx! Gr. ROn... BTW: How can i create a workbook with 2 sheets? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
