Referencing closed workbook for cell value problem

Hello all,

I'm working with the code below which works for the most part. I'm trying to reference a closed Excel file with a different extension of .gcode. I have validated that it works by creating test.gcode with a sheetname of test. I'm able to return the correct value of any cell I query.

My problem is when I use a file name that is in our company naming format, I'm getting "Run-time error '13': Type Mismatch". By default the sheet name is the file name without the extension.

Any idea why?

Thanks!

HTML Code: 

Hi,

Assuming there isn't actually an error value in that cell in the workbook, are you certain that the sheet name is correct? If it isn't, that would cause the Type Mismatch error.

I tested your code using those exact file and sheet names and it worked properly, hence my earlier question.