Object variable or With block variable not set error for multiple report based on a template

[karimsrouji]

Hello,

I am trying to generate Report using a predefined template. I select the reports i want from a listbox then run the macro. The first report generates successfully; however the second report will cause an error: "Object variable or With block variable not set " when calling a table from the bookmark. The bookmark is selected successfully but can't select the table.

wdDoc.Bookmarks("BusinessScenarioAct").Select
Set tbl = Selection.Tables(1) (Error is Here)
wdDoc.Bookmarks("BusinessScenarioRisk").Select
Set tbl1 = Selection.Tables(1) (Error is Here)
wdDoc.Bookmarks("BusinessScenarioScreen").Select
Set tbl2 = Selection.Tables(1) (Error is Here)

Thanks

 

[general_payne]

Hmmm, assuming that the bookmarks you included all contain tables, I can't see anything wrong with the code. Just double check that:

1. You've named your bookmarks correctly in the code; and
2. You've correctly declared your variables.

That's all I can say - perhaps if you could post your entire code, we could give more advice.

Thanks

 

[Andrew Poulsom]

Welcome to MrExcel.

Assuming you are automating Word from Excel, instead of:

wdDoc.Bookmarks("BusinessScenarioAct").Select
Set tbl = Selection.Tables(1)

try:

Set tbl = wdDoc.Bookmarks("BusinessScenarioAct").Tables(1)

If you must use Selection you need to qualify it with the Word Application, but you haven't said what that is. Maybe:

Set tbl = wdApp.Selection.Tables(1)

 

[karimsrouji]

It worked!
Thanks a lot!

Welcome to MrExcel.

Assuming you are automating Word from Excel, instead of:

wdDoc.Bookmarks("BusinessScenarioAct").Select
Set tbl = Selection.Tables(1)

try:

Set tbl = wdDoc.Bookmarks("BusinessScenarioAct").Tables(1)

If you must use Selection you need to qualify it with the Word Application, but you haven't said what that is. Maybe:

Set tbl = wdApp.Selection.Tables(1)