Aspose.com » Public Forums for Customers an... » Aspose.Cells Product Family » Re: Macros

Macros

Last post 04-20-2011, 9:25 AM by mshakeel.faiz. 4 replies.
Sort Posts: Previous Next

  •  06-23-2010, 9:40 AM 245039

    Macros

    How do we add a button to excel spreadsheet and then assign a macro to the button using Aspose.Cells
     

  •  06-23-2010, 11:19 AM 245065 in reply to 245039

    Re: Macros

    Hi,

    Below is detailed description of what I am looking for.

    In C#.NET I am using Aspose.Cells

    Using Aspose.Cells I created a excel document. Then I added a button as below:

     

    Dim btn As Aspose.Cells.Button = worksheet.Shapes.AddButton(1, 1, 1, 1, 20, 30)

    btn.Text = "Button"

    I have a macro function called SortData() in the excel document created above.

    I wanted to call this macro function when the above button is clicked. Can anyone say how to write code for this in C#.NET

    Thanks in advance
     

  •  06-23-2010, 12:43 PM 245082 in reply to 245065

    Re: Macros

    Hi,

    I am afraid, your desired feature is not available at the moment. We have already added it into our issue tracking system with an id: CELLSNET-13561. Once we have any update about it, we will let you know.

    Sorry for any inconvenience caused!
    Amjad Sahi
    Support Developer,
    Aspose Sialkot Team
    Contact Us
     

  •  04-20-2011, 9:08 AM 298332 in reply to 245082

    Re: Macros .NET

    Howdy,

     

    Is this feature yet available?  Another way to achieve this should be to add an ActiveX control instead of a forms control, and name a VBA macro according to the event you want it to respond to.  However, it appears that Aspose.Cells does not yet support ActiveX controls.  Are either of these features available at this time: adding ActiveX controls, or adding macros to forms controls?

     

    Thanks.
    Filed under: .net aspose.cells;Aspose Cells;Excel 2010;excel2007 macro
     

  •  04-20-2011, 9:25 AM 298337 in reply to 298332

    Re: Macros

    Hi,

    I am afraid, this feature is not available and might take few more months. I have also added your request.
    Many Thanks and Kind Regards,

    Shakeel Faiz
    Support Developer
    Aspose Sialkot Team
    Contact Us
    Aspose - The .NET and Java Component Publisher

    Keep in touch! We're on Twitter and Facebook
     
View as RSS news feed in XML

© Aspose 2002-2012. All Rights Reserved.

Live Chat