+ Reply to Thread
Results 1 to 3 of 3

Accessing Excel Macros from VB.Net

  1. #1
    Sameer
    Guest

    Accessing Excel Macros from VB.Net

    Hi, We are trying to automate an application that consumes excel sheets, gets
    fed into a couple of excel templates and generates new excel sheets based on
    the data and the macros on the templates.

    We are willing to use VSOT (Office Tools from Visual Studio), do you think
    this is a good idea? Can I access Excel Macros from VB.Net? Or is there a way
    I can automate this whole process?

  2. #2
    Sameer
    Guest

    RE: Accessing Excel Macros from VB.Net

    Any help here please? Would really appreciate it.

    "Sameer" wrote:

    > Hi, We are trying to automate an application that consumes excel sheets, gets
    > fed into a couple of excel templates and generates new excel sheets based on
    > the data and the macros on the templates.
    >
    > We are willing to use VSOT (Office Tools from Visual Studio), do you think
    > this is a good idea? Can I access Excel Macros from VB.Net? Or is there a way
    > I can automate this whole process?


  3. #3
    NickHK
    Guest

    Re: Accessing Excel Macros from VB.Net

    There are some posts here from people using various .Net products (seems
    mainly C#) to automate Excel. Whilst it does not appear as straight forward
    as say from VB5/6, others accomplish it.
    AFAIK, any user of such a app would require the compatible Framework,
    possible OWC and a few other system components to make it all work, so
    ensure you install all these with your app.

    Note: I don't use .Net, this is just what I've picked from seeing how much
    complex it is compared to automation from VB Classic.

    NickHK


    "Sameer" <Sameer@discussions.microsoft.com> wrote in message
    news:F46AD6DC-EC28-4C12-A46A-8E64DD3D2637@microsoft.com...
    > Any help here please? Would really appreciate it.
    >
    > "Sameer" wrote:
    >
    > > Hi, We are trying to automate an application that consumes excel sheets,

    gets
    > > fed into a couple of excel templates and generates new excel sheets

    based on
    > > the data and the macros on the templates.
    > >
    > > We are willing to use VSOT (Office Tools from Visual Studio), do you

    think
    > > this is a good idea? Can I access Excel Macros from VB.Net? Or is there

    a way
    > > I can automate this whole process?




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1