Search:

Type: Posts; User: ChrisMorris

Search: Search took 0.03 seconds.

  1. Re: What code is this? I need to edit and compile .dll file for 64-bit compatibility

    Thanks 2kaud, unfortunately this is the company approved version, they are usually at least one version behind with software, but it's an improvement on VB6 it replaced :rolleyes:
  2. Re: What code is this? I need to edit and compile .dll file for 64-bit compatibility

    Many thanks jmcilhinney and dilettante for the helpful comments. I've just had a new company laptop and it's got MS Visual Studio 2017, but as I've only used VB6 I'm lost with it. I'll give it a go...
  3. What code is this? I need to edit and compile .dll file for 64-bit compatibility

    Hi everyone! This is my first post for a long time, I have only done a bit of VB6 programming and VBA in Excel in spreadsheets for my work as an engineer, so please excuse my inexperience!
    I had a...
  4. Re: Code to select Excel Add-ins tab in Excel 2007/2010

    Your Application.SendKeys is the one! It's Alt-X for the 'Add-Ins' tab, Alt-L is for the 'Developer' tab.

    Strange thing is even if I use the Alt-X, Alt-L, etc it changes tab but also displays...
  5. Re: Code to select Excel Add-ins tab in Excel 2007/2010

    Ah, to display the Add-In ribbon you need to select the round Office button in top left hand corner of Excel, then select the Excel Options button at the bottom and tick the option 'Show developer...
  6. Re: Code to select Excel Add-ins tab in Excel 2007/2010

    Thanks for the swift reply vbfbryce.

    I gave it a try and it kind of works, it was the Add-Ins ribbon (sorry, didn't realise it was called a ribbon) I was wanting to select, I tried replacing the...
  7. Code to select Excel Add-ins tab in Excel 2007/2010

    Hi,

    This is my first post so hope someone can help.

    I have an Excel spreadsheet which I have written several routines which are run from the Add-Ins tab in Excel 2007/2010. One of them is to...
Results 1 to 7 of 7



Click Here to Expand Forum to Full Width