Hi again,

with regards to:


Code:
--------------------
Dim rngNetwork As Range
Dim strNetwork1 As String
Dim strNetwork2 As String
Dim strNetwork3 As String
Dim wrkbkUrl As Workbook
Dim wrkbkname As String
Dim sPath As String
Dim savewrkbkname As Variant

Set rngNetwork = Range("F11")
strNetwork1 = Range("I11").Text
strNetwork2 = Range("I12").Text
strNetwork3 = Range("I13").Text
wrkbkname = Range("I15").Text
--------------------


do I have to convert

strNetwork3 = Range("I13").Text

into strNetwork3 = thisworkbook.("sheet1").Range("I13").Text?

Once I've created the add-in it's not seeing the information on the
worksheet. Instead it reads whatever worksheet is open at the time.

cheers.


--
Daminc
------------------------------------------------------------------------
Daminc's Profile: http://www.excelforum.com/member.php...o&userid=27074
View this thread: http://www.excelforum.com/showthread...hreadid=507586