Thread: Runtime Error 9
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Noemi Noemi is offline
external usenet poster
 
Posts: 74
Default Runtime Error 9

Hi
I have a workbook that I have set workbook names but for some reason I keep
getting a runtime error 9.

I have attached the code which I have, could someone let me know what I have
done or missed out.

Dim wbkCurrent, wbkNew As Workbook

Set wbkCurrent = Workbooks("Stock Adjustment Workbook.xls")

The error keeps occuring at the set line.

Thanks
Noemi