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?