09-14-2011, 11:49 PM
Is there a way to get a handle to an open Excel document so I can use the standard ExcelSheet functions?
For example, a macro may open an excel spreadsheet with a button. I then need a handle so I can define ExcelSheet es1=???
I've tried to use ExcelSheet.Init with no luck. The only way I can get this to work so far is to create commands to do a file..save, and then open the file with ExcelSheet.Init
Is there a way to do this without saving the already open Excel file?
Thank you!
For example, a macro may open an excel spreadsheet with a button. I then need a handle so I can define ExcelSheet es1=???
I've tried to use ExcelSheet.Init with no luck. The only way I can get this to work so far is to create commands to do a file..save, and then open the file with ExcelSheet.Init
Is there a way to do this without saving the already open Excel file?
Thank you!