+ Reply to Thread
Results 1 to 4 of 4

VBA- Comparsion Chart in on sheet/in a Window/Dialog Box??

  1. #1
    Forum Contributor
    Join Date
    01-14-2010
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    125

    VBA- Comparsion Chart in on sheet/in a Window/Dialog Box??

    Not sure where to begin with my limited VBA skills on this... just need some beginning ideas...

    Background:
    I have an online program I use and quarterly I log-in and view a list they post of "text changes to the content"

    I then have a SharePoint file that I open and compare the contents of a portion of that SharePoint file to the online "changes" page and see if any text content overlaps .. if content is found that overlaps it gets sent downstream for evaulation of changes.

    Currently this "change review" is manual...

    Is it possible to go about opening excel or word.. and having a icon on the ribbon that would be pushed and it would run VBA code to do this change review. The code would end up spitting an end result out that looks like the results of the "Control F" usage. It would have some sort of 2 column list .. on one side would state "matched change content" and the other would state "impacted document" .. it would need to allow for partial matches as there are possible differences in entry and several items have 2-3 words with-in each entry and the other document may not have captured every word ...

    Basically:
    is it possible/how do you run VBA code from icon on ribbon? How would the code "always" be in excel/word so everytime I open the application itself the icon is there.. ??

    is it possible to create code telling the word file to open internet explorer and to go to a specific web addy? ... and then entering the needed password?

    Is it possible to have a dialog box pop up at the end with the results ... or would it be much easier from a usage/code writing aspect to just have the results populate on a new workbook sheet?

    Thanks as always!

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: VBA- Comparsion Chart in on sheet/in a Window/Dialog Box??

    Hi LiLI1.

    You can create a macro and put an Icon on the Quick Access Toolbar to run this macro. See http://chandoo.org/wp/2010/06/08/add...xcel-toolbars/

    Does this help part of the question?
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Contributor
    Join Date
    01-14-2010
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    125

    Re: VBA- Comparsion Chart in on sheet/in a Window/Dialog Box??

    Great step in right direction ...thanks!... I get to step 4 of the provided link ... but my macro/add-in does not show up in the list... all that I see in the list is the word "<Separator>" once I choose "Macros" in the "Choose commands from:" pull down menu ??

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: VBA- Comparsion Chart in on sheet/in a Window/Dialog Box??

    Did you pick
    "Choose commands from" (dropdown combobox) and pick ....

    Ok - I see "<Separator>" which means you don't have any Macros in this workbook. ?

+ 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