Excel 2007 application
 

Hello

I've a newbie question. I've an Excel 2007 application and want to send to
method
the current workbook as a parameter.
How can I accomplish this?!

I can't just do (Excel.Workbook)this in my workbook code because it generates
a compile error... Can you assist me here?!

Jorge

Excel 2007 application
 

Dim myWB as workbook

Set myWB = ActiveWorkbook
'or
Set myWB = ThisWorkbook

--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Jorge Ribeiro" wrote:

Hello

I've a newbie question. I've an Excel 2007 application and want to send to
method
the current workbook as a parameter.
How can I accomplish this?!

I can't just do (Excel.Workbook)this in my workbook code because it generates
a compile error... Can you assist me here?!

Jorge