VBA vs Visual Studio 2005 VB

Hi I am converting a VBA project to Visual studio 2005
What is the least I have to do to ensure that I have access to the primary
interop assembles, especially the Range object
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
Wayne Taylor (webtubbs)Connect With a Mentor Commented:
Hi murbro,

If you have added a COM reference to the Excel object, you import the Excel object like this....

    Imports Excel = Microsoft.Office.Interop.Excel

...and declare your objects like this....

    Dim rng As Excel.Range

Regards,

Wayne
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.