comp.soft-sys.matlab - The MathWorks calculation and visualization package.
Hello! I am generating a Excel Macro (VBA script file) from MATLAB How can I directly add this Macro to specific workbook using MATLAB? with regards, YP -------
Dear Sir Shall i ask how to close excel file using matlab. i used (winopen) to open the excel file (i must open and close it using MATLB relating to my application) . Thanks in advance
I seem to have an opposite problem than many others here. I have a workbook open, and I want to close EXCEL '07 totally. When I click the "x" in the right hand corner for EXCEL, it just closes the workbook I had open, and then I have to click the "X" again for close Excel. Any hints ? Thank you. GJB
This is in Excel 2003. From one workbook I want to open another workbook, copy some data out and then close the other workbook. The code is like this - set wkb = workbooks("C:\BlahBlah\AnotherWorkbook,xls").open <do some things that all work fine> wkb.close <go off and do something different> When run in the VBA code window this works wonderfully well. Exactly as one would expect. When this sub is assigned to a ctrl key and run from the worksheet pane all works as expected with the exception that the external workbook is left open. I'm obviously missing something but I haven't a clue what. Can anyone oblige? Cheers, Dave