Search Results - VBForums

Search:

Type: Posts; User: MartinLiss

Page 1 of 13 1 2 3 4

Search: Search took 0.43 seconds.

  1. MsOf10 Re: Help adding Named Range via VBA

    Thanks!! That was driving me nuts.
  2. MsOf10 [RESOLVED] Help adding Named Range via VBA

    I have a VBA code line that says


    ActiveWorkbook.Names.Add Name:="X1_RANGE", RefersTo:="=Interval_Frequency!" & STARTCOL & STARTROW & ":" & strEndCol & STARTROW

    TheNamed range is deleted prior...
  3. Re: [RESOLVED] Copy Visible Rows to Variant Array Without Looping

    Thanks.
  4. Re: [RESOLVED] Strange Problem with Thousands Separator

    I found the problem. In File|Options|Advanced the 'Use system separators' checkbox had somehow become unchecked.
  5. [RESOLVED] Strange Problem with Thousands Separator

    I'm running Windows XP and today I saw that my toolbar had disappeared so I rebooted. Now for some reason while my Regional settings (shown on the left) are correct, Excel 2010 is using the wrong...
  6. Re: Copy Visible Rows to Variant Array Without Looping

    Sorry but you missed the key words in my title.
  7. Re: Copy Visible Rows to Variant Array Without Looping

    Thanks but as I stated in my question I want to do it without looping. I have 9 different sets filtering criteria and I surely don't want to loop through 90,000 rows 9 times.
  8. Re: Copy Visible Rows to Variant Array Without Looping

    That probably works for ranges and while I gave examples of what happens with the rng and Frng ranges, I really want to copy the values of the visible cells to a Variant array. That's normally done...
  9. Re: Copy Visible Rows to Variant Array Without Looping

    That's pretty much what I did with

    Set rng = MySheet.AutoFilter.Range
  10. [RESOLVED] Copy Visible Rows to Variant Array Without Looping

    I have an Excel 2010 worksheet with 90,000+ rows that I AutoFilter down to 20 rows. I'd like to copy those 20 visible rows to a variant array without having to loop through the 90,000 rows looking...
  11. Re: Help Needed Getting Started on New VB6 Add-In

    I probably wouldn't have thought about the conditional compilation operators, so thanks. Let's see if I can do any operator:)
  12. Re: Help Needed Getting Started on New VB6 Add-In

    Interesting idea. I've used sub-classing a couple of times. The challenge will be to get it to work in the IDE and stably.
  13. Help Needed Getting Started on New VB6 Add-In

    I've written a half dozen or so add-ins for both VB6 and VBA and I'd like to be able to write one that completes "paired" operators. For example if a programmer types in "IF x = 1 Then" in the IDE...
  14. Replies
    4
    Views
    330

    MsOf10 Re: Slow the user down?

    Thanks, the addition of the Cancel = True did it.
  15. Replies
    4
    Views
    330

    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.
  16. Replies
    4
    Views
    330

    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...
  17. MsOf10 Re: Open Password Protected Excel Workbook From Access

    It didn't change anything. Excel still prompts me for a password.
  18. 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.
  19. 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...
  20. Replies
    3
    Views
    303

    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"...
  21. Replies
    3
    Views
    303

    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.

    ...
  22. Replies
    4
    Views
    340

    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.
  23. Replies
    4
    Views
    340

    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
  24. Replies
    4
    Views
    340

    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...
  25. Replies
    2
    Views
    798

    Re: Ribbon X Designer

    How stupid of me. Thanks.
  26. Replies
    2
    Views
    798

    [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...
  27. Replies
    2
    Views
    521

    MsOf10 Re: Remove Sheet Disabled

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

    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...
  29. Replies
    27
    Views
    26,190

    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...
  30. 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...
  31. 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.
  32. Re: Opening a file with a NON-default program

    Thanks. What are ssfPROGRAMFILES and ssfDESKTOP?
  33. [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...
  34. Why the USA is never going to win a World Cup

    https://www.youtube-nocookie.com/embed/-T7zyezBkuY?rel=0
  35. 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...
  36. 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...
  37. Re: Windows XP doesn't remember desktop theme

    If by "xp embedded" you mean as a virtual machine, then yes.
  38. 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...
  39. 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...
  40. Replies
    1
    Views
    213

    This is a "must see"

    https://www.youtube.com/watch?v=RC_0NzJ2mWA&feature=youtu.be
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width