setting a variable

[Gregfox]

Hi I have the following:

Dim mySUN As Workbook
Set mySUN = Workbooks("c:\SUN\Get_Sun - 2018.xlsm")

I receive an error -->subscription out of range
I would like to correct this.
Thanks!

 

[Fluff]

If the workbook is open try

Set mySUN = Workbooks("Get_Sun - 2018.xlsm")

If its closed try

Set mySUN = Workbooks.open("c:\SUN\Get_Sun - 2018.xlsm")

 

[Gregfox]

Thank you that does work (excel 2007 / PC) the workbook is closed but I just wanted to declair it and use it later on in the program. Is there a way?

 

[Fluff]

Not if you want to declare it as a workbook object.

 

[Gregfox]

Thank you

 

[Fluff]

You're welcome

 

[Fluff]

If you're happy declaring your variables as string you could use something like

Dim Pth As String
Dim mySUN As String
Pth = "C:\SUN\"
mySUN = "Get_Sun - 2018.xlsm"

Workbooks.Open (Pth & Fname)
Workbooks(Fname).Sheets (1)

 

[Fluff]

Cross posted https://www.excelforum.com/excel-programming-vba-macros/1240456-setting-a-variable.html#post4948802

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.