Search Results - VBForums

Search:

Type: Posts; User: MartinLiss

Page 1 of 13 1 2 3 4

Search: Search took 0.44 seconds.

  1. Replies
    4
    Views
    273

    MsOf10 Re: Slow the user down?

    Thanks, the addition of the Cancel = True did it.
  2. Replies
    4
    Views
    273

    MsOf10 Re: Slow the user down?

    Thanks. I had tried that already but putting my code in the Worksheet_BeforeDoubleClick didn't fix the problem.
  3. Replies
    4
    Views
    273

    MsOf10 [RESOLVED] Slow the user down?

    I have a situation where I want to cycle through several values in a cell and my code is in the Worksheet_SelectionChange event. I want it to behave like a checkbox in that I can repeatedly change...
  4. MsOf10 Re: Open Password Protected Excel Workbook From Access

    It didn't change anything. Excel still prompts me for a password.
  5. MsOf10 Re: Open Password Protected Excel Workbook From Access

    It must be my workbook (that I can't post here) because when I tried your code it didn't work but when I created a new workbook both your code and mine worked.
  6. MsOf10 Open Password Protected Excel Workbook From Access

    I tried this and while the syntax of the Open statement seems to be correct and the password is "password", I always get the enter password dialog. If I enter "password" there it works but I don't...
  7. Replies
    3
    Views
    274

    MsOf10 Re: What's going on here?

    OK, thanks, that helps. The Details sheet has a value of 20 in A3 and frmData.lblService.Caption contains "blah" (not really) so the filter only copies rows where the value in cells of the "blah"...
  8. Replies
    3
    Views
    274

    MsOf10 What's going on here?

    It's not often I come across code I don't understand but I need help here. Can someone explain what's going on, particularly the use of the rng Range? Note that Details!A3 has a value of 20.

    ...
  9. Replies
    4
    Views
    270

    Re: Create Data Report

    No, not the portable edition and yes all all service packs added. I didn't think selecting all the common controls would help but I tried it anyhow and it didn't help.
  10. Replies
    4
    Views
    270

    Re: Create Data Report

    Thanks for the reply but I already have those two selected (along with Addin Class) and this is my menu.
    126707
  11. Replies
    4
    Views
    270

    Create Data Report

    In all the years I've used VB6 I never before tried to create a data report. I wanted to do it now but 'Add Data Report' is not in my 'Project' menu. I tried to add it by dong View/Toolbars/Customize...
  12. Replies
    2
    Views
    765

    Re: Ribbon X Designer

    How stupid of me. Thanks.
  13. Replies
    2
    Views
    765

    [RESOLVED] Ribbon X Designer

    I've just come across the Ribbon Editor and I hope that someone who is experienced using it can help me because I'm probably doing something wrong but when I add a tab I don't see this (as shown in...
  14. Replies
    2
    Views
    483

    MsOf10 Re: Remove Sheet Disabled

    You're right. I just verified that it's the same way in Excel 2007.
  15. Replies
    2
    Views
    483

    MsOf10 [RESOLVED] Remove Sheet Disabled

    I was teaching myself how to modify ribbon XML so that I could disable some sheet tab context menu items (note that things like Application.CommandBars("Ply").Controls("Rename").Enabled = False don't...
  16. Replies
    27
    Views
    25,799

    Re: [VB6] Picture/Video Viewer

    I also use XP Professional 32-bit SP3 but I don't remember how to find out my SP level for VB6. My FreeImage.dll is in the same folder as Picture Viewer.vbp, however my version of the dll is much...
  17. Re: Opening a file with a NON-default program

    Thanks Tanner_H, while I have Parallels Tools installed and I have full sharing of files between Windows and MAC, I could not find SmartSelelect. However the article you referred me to got on the...
  18. Re: Opening a file with a NON-default program

    dilettante, I'm probably missing something but I can already open a movie using ShellExecute and I don't understand how your code solves my problem which is getting it to use the MAC Quicktime Player.
  19. Re: Opening a file with a NON-default program

    Thanks. What are ssfPROGRAMFILES and ssfDESKTOP?
  20. [RESOLVED] Opening a file with a NON-default program

    My situation is this. I use Parallels Desktop to run a Windows Virtual Machine on my MAC, and I can easily access MAC files from Windows and Vice Versa. What I'd like to be able to do is to use VB6...
  21. Why the USA is never going to win a World Cup

    https://www.youtube-nocookie.com/embed/-T7zyezBkuY?rel=0
  22. Re: Windows XP doesn't remember desktop theme

    I assume that you are asking about a Windows reboot rather than a MAC reboot. If so then, as I'm sure you know, Windows standard operating procedure is to ask me to close (or it will close) all...
  23. Re: Windows XP doesn't remember desktop theme

    I use Parallels Desktop and when rebooting everything is supposed to be saved and it is with the exception of the theme. It used to be saved but no longer is. The problem has persisted through...
  24. Re: Windows XP doesn't remember desktop theme

    If by "xp embedded" you mean as a virtual machine, then yes.
  25. Re: Windows XP doesn't remember desktop theme

    Thanks for reminding me of my previous duplicate question. I forgot all about it. In any case I tried one of the suggestions which was to rename the "Luna" theme but it didn't help. All it did was to...
  26. Windows XP doesn't remember desktop theme

    I have a theme that I created a long time ago that I like to use for my desktop. When I go to the control panel and select it, it works fine but ever time I need to reboot, the setting is lost and...
  27. Replies
    1
    Views
    201

    This is a "must see"

    https://www.youtube.com/watch?v=RC_0NzJ2mWA&feature=youtu.be
  28. 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...
  29. 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...
  30. Re: [RESOLVED] Where are Excel VBE icons stored

    Thanks.
  31. 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...
  32. 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...
  33. Replies
    21
    Views
    945

    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...
  34. Replies
    21
    Views
    945

    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".
  35. Replies
    21
    Views
    945

    Re: Overlap between to add-ins

    In both versions 'Version Compatibility' is set to 'No Compatibility'.
  36. Replies
    21
    Views
    945

    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...
  37. Replies
    21
    Views
    945

    Re: Overlap between to add-ins

    Same problem:(
  38. Replies
    21
    Views
    945

    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...
  39. Replies
    21
    Views
    945

    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...
  40. Replies
    21
    Views
    945

    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...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width