vba excel type mismatch when returning full path workbook object

Viewed 34

Type mismatch: It will always return a type mismatch error.

dim FileName_A As Workbook    
dim v_value as string *or any other type, ie, variant, long, integer...*
    
Set FileName_A = Workbooks.Open(strFile) *any EXCEL file xls*
    
v_value = Workbooks(FileName_A).Sheets("ABC").Cells("E3").Value    

E3 value is 01.1234 but will always return a type mismatch

What am i missing here? txs for your support.

0 Answers
Related