You current code would help.
But I would guess it has something to do using ActiveWorkbbok/Sheet.

NickHK

"Boldie" wrote in message
...
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.