Solved

Visual Studio 2005 Tools for office Range Object

Posted on 2007-11-14
1
161 Views
Last Modified: 2013-11-26
Hi

Can you declare a range object globally in Visual Studio tools for odffice to be used anywhere in the project. How do you do this.
If the Variable is R do you say R("A2") or R.Range("A2")
0
Comment
Question by:murbro
1 Comment
 
LVL 47

Accepted Solution

by:
Wayne Taylor (webtubbs) earned 500 total points
ID: 20278387
Hi murbro,

You can declare the range object as you did in VBA....

    Public R As Excel.Range

....then you need to set it to a range somewhere (posibbly in the startup)....

    R = WB.Worksheets("Sheet1").Range("A2")

....where WB is a workbook object.

Regards,

Wayne
0

Featured Post

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article describes relatively difficult and non-obvious issues that are likely to arise when creating COM class in Visual Studio and deploying it by professional MSI-authoring tools. It is assumed that the reader is already familiar with the cla…
In my previous two articles we discussed Binary Serialization (http://www.experts-exchange.com/A_4362.html) and XML Serialization (http://www.experts-exchange.com/A_4425.html). In this article we will try to know more about SOAP (Simple Object Acces…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question