Does anyone here know how to set the freezepanes property in OWC(Office Web Component) 9 in Matlab?The following code just did not work!handles.activex1.ActiveSheet.FreezePanes=1

Are there ways to record multiple cells (or range) at the same time?

<t>Hi, thereI am trying to copy a chart in Excel into a new workbooks. Basically, the original chart is a dynamic chart using defined range name. Is there a way to copy the chart into a new workbook and delink the data in the chart from the source file. I understand how to achieve this if the chart ...

Yes, but the problem of the delta is that it depends on other variables and keep changing as the underlying asset price changes. Is there a way to identify the overall correlation between the structured products and the underlying asset class?

Is there a way to calculate the correlation between options/structured products and the underlying asset?I am going to use the correlation in the multivariate monte carlo simuation.Any helps will be highly appreciated!Regards.

Are there any ways to incorporate the monte carlo simulation in a Bayesian framework? For example, how to generate the expected return and covariance matrix based upon Bayesian approach and then use them as the inputs for monte carlo simulation?

<r>Basicaly, I tried to open an excel spreadsheet by ways similar to the one shown in <URL url="http://www.mathworks.com/matlabcentral/fileexchange/loadFile.do?objectId=6889&objectType=FILEI"><LINK_TEXT text="http://www.mathworks.com/matlabcentral/ ... Type=FILEI">http://www.mathworks.com/matlab...

The problem with this example is that it is not designed by using the GUI environment and it does not open an exit excel spreadsheet.

Thanks a lot!

<t>I wonder whether any Genius here could help me on the following issue:Basically, I implement the Microsoft Office activex control in the Matlab GUI environment. But I have no idea how to achieve the following tasks: open an excel spreadsheet in the GUI activex control and display it as a usual ex...

<t>As I gave it more runs, I identify that it seems some parts of my worksheets have been corrupted. So if I replaced the old chart with the new one, then it solved the problem. But this is really annoying as the corruption tends to happen randomly to different parts of the workbooks(mainly chart ob...

Basically, my codes involve copy the chart object within the sheet, such as the following:Sub SaveLogoAsGif24()Dim CurrentChart As ChartSet CurrentChart = Sheet6.ChartObjects(2).ChartCurrentChart.CopyPicture Appearance:=xlScreenSet CurrentChart = NothingEnd SubAny ideas?

<t>Thanks.I have used the code cleaner but not much help either.Basically, copying the chart is one exportation function of the application. The user can copy the chart into their own powerpoint slides. The version of Excel I am using is Office 2000, which is the only available version in my company...

<t>I have just narrowed down the problem to the followings:I am copying sheets in a macro...Copy a chart, copy a range, and so on...Usually after several copies, I get the following errormessage:Run-time error '-2147417848 (80010108)':Automation errorThe object invoked has disconnected from its clie...

<t>Yes, I am using blpsubscribe function in the vba application. But the error message is generated after the application tried to copy a chart or copy a range.Also, the same codes were working exactly fine before and now as the spreadsheet goes larger (3 MB in size), this error happens and becomes ...