Workbooks.Open inside Function call

**twd000** · 06-22-2010, 12:15 PM

OK, try to follow my code modules here. I have a top-level Function-

Please Login or Register  to view this content.

inside this Function is a Sub

Please Login or Register  to view this content.

inside that Sub is a command to open an Excel workbook which is closed:

Please Login or Register  to view this content.

The problem is that the Workbooks.Open method does not work when I am using fit_surface_node as a Function. When I say I am using it as a Function, I mean that I have set the Boolean output_to_sheet as False, which skips any line of code which modifies any cell besides the one in which fit_surface_node resides.

I know that a Function cannot modify other cells, but is it also prohibited from opening a workbook?

**romperstomper** · 06-22-2010, 12:44 PM

Yes (thankfully)

**twd000** · 06-22-2010, 12:46 PM

so if I cannot open a workbook, can I copy data from a closed workbook to import into my VBA workspace?

**romperstomper** · 06-22-2010, 12:52 PM

You can't copy as such but you can use ADO to extract tabular data from a closed workbook. You could also do this with native Excel functionality using the Get External Data functions.