Hi Shasur,

the line Set oWB = oXlapp.Workbooks.add
gives the error "Runtime Error 424 " object required

any reference needed?

Hi

oXlapp is the object for Excel Application. Check if you have used oXlapp or xlApp. If this is xlApp please use

Set oWB = xlApp.Workbooks.add

instead of

Set oWB = oXlapp.Workbooks.add

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

hi shasur,

it works.
can i ask how come after the new excel workbook is created i cannot open immediately on the spot?

i can only open it after i close and exit the entire vb application. in the vb i had closed and set all teh objects used to nothing after the workbook is created but my excel workbook can only be opened after the vb applicationo is totally closed

wad might cause this issue?

thanks

Hi

Immediately after ths code

Set xlApp = New Excel.Application

insert the following:

xlApp.Visible = True

This will make the Application visible and you can check the changes

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Hi Shasur,

after inserting xlApp.Visible = True
still cannot open the file while the application is active

meaning that after i split the new workbook without closing my vb application i could open the workbook but is do not show the content of the excel workbook.

only after i close and exit my vb application and i reopen the new workbook then i can view the content in it.


wad is the setting missing here?

Thanks