View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
greg greg is offline
external usenet poster
 
Posts: 108
Default Open workbook and pass info

Hello,
I an opening a file. and wondering if I can pass info to the workbook open?
so given this example:

My code:
Set objWB = Workbooks.Open("C:\foo\foo2\bla.xlt")

bla.xlt
Private Sub Workbook_Open()
End Sub

I would like to have some information right away in the workbook open.
is there a way to pass it in right away?
thanks