Search Results - VBForums

Search:

Type: Posts; User: MartinLiss

Page 1 of 13 1 2 3 4

Search: Search took 0.56 seconds.

  1. Replies
    1
    Views
    142

    This is a "must see"

    https://www.youtube.com/watch?v=RC_0NzJ2mWA&feature=youtu.be
  2. Re: [RESOLVED] Where are Excel VBE icons stored

    I'me aware of the icon gallery and have it installed but no matter what size or form in which I specify I want the image, when I try to add the image to a VB6 ImageControl it tells me it's an...
  3. Re: [RESOLVED] Where are Excel VBE icons stored

    Interestingly when you make these two changes


    Set insertPopup = menuBar.Controls.Item(3)
    Set procedureButton = insertPopup.Controls(15)

    which should be (and the code names it as such) the...
  4. Re: [RESOLVED] Where are Excel VBE icons stored

    Thanks.
  5. Re: Where are Excel VBE icons stored

    Thanks for that and I'll definitely store it away in my library, but the resulting images have a bright pink background. It's been a long time since I've done anything but basic stuff in Photoshop...
  6. Re: Where are Excel VBE icons stored

    Never did find the proper source file (if one exists), but I worked around the problem by using Photoshop Elements to cut out the "icon" portions of the image I posted in my original post and saved...
  7. Replies
    21
    Views
    592

    Re: Overlap between to add-ins

    Thanks. I resolved the problem. It turns out that regardless of the name of the dll, only one registry entry is created and that entry is created from the project name. In my case while I had two...
  8. Replies
    21
    Views
    592

    Re: Overlap between to add-ins

    Thanks for trying but no, 'Application' is derived from the designer and has no properties or methods. As proof I have another pair of VB6/VBA add-ins that work just fine with just "Application".
  9. Replies
    21
    Views
    592

    Re: Overlap between to add-ins

    In both versions 'Version Compatibility' is set to 'No Compatibility'.
  10. Replies
    21
    Views
    592

    Re: Overlap between to add-ins

    The add-in fails on the first line of code.

    When a designer is used to create the add-in you are shown the form on the left. The picture on the right shows the available choices for the...
  11. Replies
    21
    Views
    592

    Re: Overlap between to add-ins

    Same problem:(
  12. Replies
    21
    Views
    592

    Re: Overlap between to add-ins

    No. When you go to the Add-in Manager in VB6 the only add-in (of mine) that's available is ai-VB6 and in Excel the only one that's available is ai-VBA. However if, say, I've compiled or registered...
  13. Replies
    21
    Views
    592

    Re: Overlap between to add-ins

    In my original post I said

    and that's not correct. It turns out that what's in use doesn't matter. What happens is that the last dll that's compiled or the last dll that's registered is the one...
  14. Replies
    21
    Views
    592

    Re: Overlap between to add-ins

    Sorry about the problems you had registering the dlls. I use Windows XP and I just go to Start|Run. You?

    In any case do you have any experience writing COM dll's? If so I'll post the source for...
  15. Replies
    21
    Views
    592

    Re: Overlap between to add-ins

    If you mean connect.dsr, then yes.

    I've attached the dll's renamed as txt files. I'd be interested in knowing if the same thing happens to you when you try them. To do so
    - Store them anywhere...
  16. Replies
    21
    Views
    592

    Re: Overlap between to add-ins

    Yes there is similar code in both add-ins but the problem occurs before the code is involved, and for some reason VB always thinks that I'm trying to connect to the last-compiled add-in. I have...
  17. Replies
    21
    Views
    592

    Re: Overlap between to add-ins

    Another fact. Even though the dll's have different names it's the one that's compiled last that is always connected to from either Excel or VB6.
  18. Replies
    21
    Views
    592

    [RESOLVED] Overlap between to add-ins

    Iíve written two COM add-ins using VB6. One of them which Iíll call ai-VB6 was written first and is intended for use in VB6 projects. The other one which Iíll call ai-VBA was created by modifying...
  19. Re: Where are Excel VBE icons stored

    Westconn1 thanks, but the icons I'm looking for aren't there. I'll look around in that path and see what I can find.
  20. Re: Where are Excel VBE icons stored

    I don't actually know how icon extractors work but when I run mine against Excel it does come up with a bunch of icons, just not the ones I want. And since it's getting them from the exe that says to...
  21. Re: Where are Excel VBE icons stored

    Thanks but I already have an icon extractor and the problem is that I don't know the file to extract from.
  22. [RESOLVED] Where are Excel VBE icons stored

    I know that there are icons in the C:\Program Files\Microsoft Office\Office14\FORMS\1033 folder but does anyone know where I might find these that you see when you click the 'Insert' button when you...
  23. Replies
    2
    Views
    176

    Re: [RESOLVED] IDE Row and Column Position

    Thanks. I had the Standard toolbar showing but I had to Reset it.
  24. Replies
    2
    Views
    176

    [RESOLVED] IDE Row and Column Position

    There used to be a little display someplace at the top of my VB6 IDE that showed my current caret position by row and column. How do I get it back?
  25. Replies
    2
    Views
    265

    Re: Windows Theme not Remembered

    I saw that same article but it talks about doing some things that make me nervous,
  26. Replies
    2
    Views
    265

    Windows Theme not Remembered

    I use Windows XP (yes I'm an old dog) and recently when I've had to reboot, my windows theme is not implemented correctly. What I mean by that is that it looks like this with an ugly black title bar...
  27. Replies
    3
    Views
    254

    Re: [RESOLVED] Add-In OnConnection Problem

    I resolved the problem. I had an incorrect Reference.
  28. Replies
    3
    Views
    254

    Re: Add-In OnConnection Problem

    Sorry about that. Here's the missing module that contains the definition. Just add it to the project. In order to reproduce the error you'll need to compile to produce the dll, register the dll and...
  29. Replies
    3
    Views
    254

    [RESOLVED] Add-In OnConnection Problem

    Some time back I developed an addin called Annotate which helped in the annotation of changes to VB6 code. Everything worked well until I made some changes and now I get a "Type mismatch" error in...
  30. Replies
    25
    Views
    23,087

    Re: [VB6] Picture/Video Viewer

    It's been 3 or 4 years since I last did anything with this and so I'm not sure, but I don't think so. Besides there are probably better utilities out there for doing that.
  31. Re: I need some help with a formula please

    Thanks.
  32. Re: I need some help with a formula please

    You are correct, the test value should be 21 and I while I know that COUNTA is what I want to use, I'm not good with complex formulas and don't know how to add COUNTA to the existing formula.
  33. [RESOLVED] I need some help with a formula please

    The current formula is

    =IF(Topics!$T$2<Topics!$T$3-1,"▼","")

    I need to have an AND test added to the value_if_true portion so that even if T2 < T3 -1 it's only true if the count of non-blank...
  34. Re: Hide or disable a forms scrollbar on a sheet

    Never mind, I had the sheet name wrong :(
  35. [RESOLVED] Hide or disable a forms scrollbar on a sheet

    Is it possible to hide or disable a forms (not ActiveX) scrollbar on an Excel sheet?

    I've tried both of these to no avail.

    Sheets("Blah").ScrollBars("MyScrollbar").Visible = False
    ...
  36. Replies
    21
    Views
    2,152

    MsOf10 Re: [RESOLVED] Display the File|Print Window

    No, I wasn't saying that. It just takes me to the screen he showed in post #6, which, for lack of anything better, is OK.
  37. Replies
    21
    Views
    2,152

    MsOf10 Re: [RESOLVED] Display the File|Print Window

    Thanks. TnTinMN's approach works for 2007.
  38. Replies
    21
    Views
    2,152

    MsOf10 Re: Display the File|Print Window

    Rob, while it works for Excel 2010, neither sendkeys nor your approach works in Excel 2007. Do you know a way to show the printpreview window in that version?
  39. Replies
    21
    Views
    2,152

    MsOf10 Re: Display the File|Print Window

    Thanks Rob, that works!
  40. Thread: MartinLiss

    by MartinLiss
    Replies
    60
    Views
    5,865

    Re: MartinLiss

    I've always been a man of few words.

    Dropping out of thread.
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.