what's wrong with this code

[redshirtme]

when I use the following code, it seems like visual basic open a read only excel file named "book1.xls", how to avoid this? because I need to write some data into the book1.xls so I don't like it read only.

by the way, I manually created an excel file named "book1.xls" .Is that the reason cause it to be read only when opened by my vb code? Do I need to manually created this excel file first?

any suggestion is helpful!!!



code:--------------------------------------------------------------------------------

Set xl = CreateObject("Excel.Application")
Set xlBook = xl.Workbooks.Open(App.Path & "\book1.xls")
Set xlSheet = xlBook.Worksheets.Add

[carl_mathews200]

This needs to be in the 'Classic Visual Basic' forum but here goes anyway....

I tried the code that you have and it works fine. How about

Set xl = CreateObject("Excel.Application")
Set xlBook = xl.Workbooks.Open(App.Path & "\book1.xls", , False)
Set xlSheet = xlBook.Worksheets.Add