Define variable as range in a closed workbook

[puzzlelover22]

Hi All,

New to VBA and working on a few UDFs to speed up my day-to-day banality. I'm trying to reference a fixed range in an unopened workbook. Do I need to include the path to the file, and what would the syntax look like? Or can I get away with

rngReturn = Workbooks("Test.xlsx").Sheets("Sheet1").Range("$A$2:$A$10"), where rngReturn is a range


Thanks!

Alex

[shg]

You need to open the workbook for that syntax to work. Workbooks("...") refers to the collection of open workbooks.

[puzzlelover22]

Ahh okay. Is there any way to make it work with the workbook closed?

[shg]

See http://spreadsheetpage.com/index.php...a_closed_file/