I am using a PDF converter to get some data out of the pdf into an excel
spreadsheet. The converter opens a new workbook (normally Book1.xls). I
also have a workbook that contains my code to take the data out of the newly
opened workbook into my current workbook. when i run the code i get a
run-time error 9 when trying to activate the newly open workbook. This does
not happen if i save the workbook and close it then reopen it.

can anyone help.