I have written a sub in VBA that opens a workbook and returns a certain value from there then closes the workbook. I have tested the Sub and it works perfectly well. The code used in the Sub is not working in a UDF, the problem relies in the Workbook.Open function, for some reason, the UDF is not opening that workbook. I am getting the following msg: "VBAProject..(function name)-> 91: Object variable or with block variable not set"
I would like to obtain some help whether Workbook.Open function is not supported inside a Function. I would write the Sub code if necessary.
I would be grateful for any help.
I would like to obtain some help whether Workbook.Open function is not supported inside a Function. I would write the Sub code if necessary.
I would be grateful for any help.