Post data to closed workbook sheet?

[hsviljoen]

I need to post data from one workbook into a sheet in a other workbook. I'm having problems to run any code after the line of code that opens the other workbook.

Does anyone have a idea?

thank you in advance.

 

[SkipVought]

hsviljoen,

Please post the code that is not working.

Skip,

_{[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive!}

 

[hsviljoen]

Excel.Workbooks.Open (Filename)
----- Any code below the code above does not run ------
Range("A1").Insert

It opens the workbook and then it stops there

 

[Molby]

You need to activate the workbook you have just opened.

books(Filename).activate

 

[SkipVought]

You do NOT necessarily need to ACTIVATE anything.

Set wbk = Excel.Workbooks.Open(filename)

wbk.Worksheets(1).Range("A1").Insert

Skip,

_{[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive!}

 

[Molby]

My Apologies Skip, badly worded on my behalf. You're quite right, no need to actually activate, but there is a need to reference the newly opened book.