Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Calling Easy-XL from VBA.

  1. #1
    New Member
    Join Date
    Sep 2010
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Calling Easy-XL from VBA.

    Easy-XL does a lot of cool data analysis tricks. I've been interested in seeing if you could leverage Easy-XL from VBA. Could I write some VBA code which would call Easy-XL and issue Easy-XL commands?

    John from the development team at Easy-XL has done something fairly amazing. He modified Easy-XL to (a) detect if the macro recorder is running and (b) generate VBA code so you can learn the syntax of how to call Easy-XL from VBA. Thus, you can record macros that will include Easy-XL commands.

    This is still very much in beta. If you would like to try it out, download from the secret beta location: http://www.easy-xl.com/ez/downloads/beta/easy-xl.msi. Since it is a beta, please don't use this in your production files yet. Make copies of your data and test there. Post any issues here.

    Bill

    .

  2. #2
    Board Regular Easy-XL Support's Avatar
    Join Date
    Nov 2009
    Location
    Ottawa, Canada
    Posts
    140
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Calling Easy-XL from VBA.

    In order for this to work, you need to make sure that "Trust access to Visual Basic Project" (Excel 2003) or "Trust access to the VBA project object model" (Excel 2007/2010) is checked in your Macro Security settings.

    Excel 2003 -> Tools -> Macros -> Security -> Trusted Sources

    Excel 2007/2010 -> Excel options -> Trust Center -> Macro Settings -> Developer Macro Settings

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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