Excel - Variables

[alrodopial]

Hi,
I download and store the source of a page in a variable lets say called "mydata".
How do i have to declare this variable so that it will be "valid,available" till the close of the workbook? I want to use it again and lets say make a search inside it few seconds later, using a new macro. I dont want to download the page again and create the "mydata" again.
Thanks

[GaryRussell]

Create a new module if your workbook does not already contain one and insert something like the following at the top of the module. It can then be referred to by any macro in your workbook.

Code: Select all

public mydata as string

[alrodopial]

Perfect.
Thanks