+ Reply to Thread
Results 1 to 2 of 2

Automate report using 3rd Party addin

  1. #1
    Forum Contributor
    Join Date
    09-09-2008
    Location
    Middlesbrough, England
    MS-Off Ver
    2007
    Posts
    174

    Automate report using 3rd Party addin

    Hello,

    I've half automated a report using VBA but the issue i have is the remaining part of the process using a 3rd party add-in which is locked down.

    Is there a way i can refer to this or use a tool which captures my key / mouse strokes to help fully automate the process?

    Cheers

    Chris

  2. #2
    Forum Expert
    Join Date
    03-13-2004
    Location
    Gothenburg/Stockholm, Sweden
    MS-Off Ver
    Excel 2003, Excel 2007 & reluctant Excel 2010 user
    Posts
    4,513

    Re: Automate report using 3rd Party addin

    Perhaps, in excel select the "Home" tab then press the Alt button. Will now get a number of letters F, H, N, P, M, A, R, W and L

    These are the tabs you can activate using the "SendKey" in a macro, but I'm sorry to say "SendKey" is not 100 % reliable.

    To get to the sub menu for formulas start by pressing Alt button, the letter for formulas is M so pressing the Alt button and then M will open the sub menu for formulas where you can work your way down by pressing Alt + the appropriate letter.

    So does your 3de party add-in have a specific letter assigned to it? If so you could try to activate it with "SendKey"

    A macro for activating the formula tab would look like this:

    Please Login or Register  to view this content.
    For lower level commands you need to add more "SendKeys" with appropriate letters.

    Alf
    Last edited by Alf; 09-09-2016 at 12:16 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2007, 3rd party addin highlighting cells problem
    By rodpestell in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-14-2016, 10:01 AM
  2. Excel COM addin: expose method to third party
    By neu_stone in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2015, 10:31 AM
  3. Automate Report
    By vradhak7 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-06-2014, 09:27 AM
  4. Automate Excel Report to Web
    By sudopudge in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2014, 08:29 PM
  5. Automate producing a chart using an addin
    By rbagwell in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-24-2010, 12:37 PM
  6. Automate report Generation
    By Epscan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-18-2009, 05:20 PM
  7. [SOLVED] Automate Excel report to place certain data into existing report?
    By Craig Harrison in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-25-2006, 09:00 AM

Tags for this Thread

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