Excel 2007 application

  • Thread starter Thread starter Jorge Ribeiro
  • Start date Start date
J

Jorge Ribeiro

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
 
Dim myWB as workbook

Set myWB = ActiveWorkbook
'or
Set myWB = ThisWorkbook
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VSTO Excel 2003 to VB 6.0 Type Mismatch 1
C# Excel 2007 workbook application with VSTO Problem 1
32 bit DLL with 64 bit Excel 2010 13
Excel 2013 menubar incompatibility? 1
Determining whether a workbook is a 2003 or 2007 workbook 6
Move Worksheet from one Workbool to another - fails on Excel 2007 2
Referring to Excel objects in VSTO 2
Application Name differences between Excel 2003 and 2007 3

Back
Top