Search:

Type: Posts; User: MartinLiss

Page 1 of 13 1 2 3 4

Search: Search took 2.62 seconds.

  1. Re: DllRegisterServer failed with error code 0x80004005

    Same error.
  2. Re: DllRegisterServer failed with error code 0x80004005

    Thanks for trying but I get the same error so I guess it's rewrite time.
  3. Re: DllRegisterServer failed with error code 0x80004005

    Si, I'm sorry to bother you again but when I open the Windows 10 Start menu I see this.
    183046
    Where do I find the Cmd prompt?
  4. Re: DllRegisterServer failed with error code 0x80004005

    Thank you for the useful information that I'll save for future needs, but both methods failed with the same error. The dll was written in 32 bit so I suspect I have to rewrite it in 64 bit.
  5. Re: DllRegisterServer failed with error code 0x80004005

    How do I do that?
  6. DllRegisterServer failed with error code 0x80004005

    I'm fairly new to Windows 10 and I'm trying to register a dll for the first time. When I go to the Cmd prompt and enter regsvr32 C:\My.dll I get the error shown in the Title of this question. I am an...
  7. Replies
    7
    Views
    728

    Re: [RESOLVED] Regex help please

    Thank you all for your help.
  8. Replies
    7
    Views
    728

    Re: Regex help please

    Are you on a Windows or Linux filesystem?==> macOS
    Or are the paths URLs?==> No they are file paths
    Are you trying to match any folders that are exactly "thumbnail" or "derivative"==> I want to...
  9. Replies
    7
    Views
    728

    [RESOLVED] Regex help please

    I have a slideshow application that uses regex to exclude certain pictures based on the picture's file path. It excludes thumbnails with .*/thumb*

    How can I modify that to exclude both thumbnail...
  10. Re: [RESOLVED] Autofilter Criteria Array Parameters

    Thank you all for your suggestions and jdc2000 for the link.
  11. Re: Autofilter Criteria Array Parameters

    I figured out the second part of my question.

    Array(2, strDate)

    but strDate need to be mm/dd/yyyy
  12. [RESOLVED] Autofilter Criteria Array Parameters

    In this autofilter statement

    .Range("$A$1:$D$233").AutoFilter Field:=1, Operator:=xlFilterValues, Criteria2:=Array(2, "9/1/2021")

    what does the bolded 2 represent?

    And how can I change the...
  13. Re: [RESOLVED] Bizarre Windows 10 / Excel 2019 behavior

    Thank you, that worked.
  14. [RESOLVED] Bizarre Windows 10 / Excel 2019 behavior

    I've used the attached workbook in Windows XP / Excel 2010 for 10 years without problems but when I switched to Windows 10 / Excel 2019 I get different results in column E. Column E should look like...
  15. Replies
    0
    Views
    297

    [RESOLVED] Excel date format mystery

    Nevermind.
  16. Re: Excel 2019 Recent Files - File extensions

    I have Windows 10 so it's File Explorer but I found the proper setting. Thanks.
  17. [RESOLVED] Excel 2019 Recent Files - File extensions

    In the list of workbooks I've recently edited in Excel 2019 it only shows the file name. Can I get it to also show the file extension?
  18. Replies
    5
    Views
    524

    Re: Office 365 Pros and Cons

    Thanks. My work is mainly with macros, so alternatives if I want to work on my mac?
  19. Replies
    5
    Views
    524

    Office 365 Pros and Cons

    I currently use Excel 2010 in a Windows XP (yes XP) virtual machine on my mac, but I'm looking for something more modern. Of the Office apps all I need is Excel so is Microsoft 365 Business Basic...
  20. Re: Userform Listbox Unnecessarily Wide

    Thanks!
  21. [RESOLVED] Userform Listbox Unnecessarily Wide

    I have a listbox on a userform that looks like this. The listbox width is set to 88 which is the smallest value that doesn't produce a horiontal scrollbar. Why does it need to be that large?
    182303
  22. MsOf10 Re: [RESOLVED] What can cause Excel to think I have over a million rows

    The problem was resolved by deleting the bottom rows in chunks and saving the file after each deletion.
  23. MsOf10 Re: What can cause Excel to think I have over a million rows

    Thanks, but I know how to find the last row.

    Concerning CZ8669. I didn't mention it in my question but in the workbook I attached I already cleared all formatting and formulas in all the rows...
  24. MsOf10 Re: What can cause Excel to think I have over a million rows

    Thanks but my problem is not finding the correct last row which I believe is row 6808, but rather that because Excel thinks the used range extends to row 1,048,576576
    1) The size of the workbook...
  25. MsOf10 Re: What can cause Excel to think I have over a million rows

    Here is the crazy worksheet. It's too big to attach directly. Disclaimer: I did not create the workbook of which this worksheet is a part.
    ...
  26. MsOf10 [RESOLVED] What can cause Excel to think I have over a million rows

    I've posted similar questions before but haven't been able to solve the problem which is that while I only have about 6800 rows in my worksheet, Excel thinks the last row is 1,048,576! I know that...
  27. Replies
    1
    Views
    404

    Re: [RESOLVED] Deleting non-visible rows

    Resolved it in a different way.
  28. Re: [RESOLVED] This old dog needs to learn new tricks

    Thanks all.
  29. Replies
    1
    Views
    404

    [RESOLVED] Deleting non-visible rows

    Given a worksheet without headers that has been filtered, and given a range that refers to the column that has the filter, i know that the following will delete all the visible rows.
    ...
  30. Re: This old dog needs to learn new tricks

    Thanks. That's one of the things I was thinking about.
  31. [RESOLVED] This old dog needs to learn new tricks

    I currently do a lot of Excel 2010 development in Windows XP as a virtual machine hosted by Parallels Desktop for Mac. I'd like to upgrade to something more modern but I don't know what the best...
  32. MsOf10 Re: Conditional formtting of today's date

    Thanks.
  33. MsOf10 Re: Conditional formtting of today's date

    That doesn't seem to be available in Excel 2010.
  34. MsOf10 [RESOLVED] Conditional formtting of today's date

    I have a row of dates in row 1 where visually today's date is shown as 15-08-2021. The dates are created by adding one to the previous cell's date. Can this be improved on so that it works and...
  35. Replies
    2
    Views
    536

    MsOf10 Re: Combobox Rowsource

    This works.

    Application.EnableEvents = False
    With MyCombobox
    .RowSource = ""
    .Clear
    .ListIndex = -1
    .RowSource = "MyNamedRange"
    End With
    Application.EnableEvents = True
  36. Replies
    2
    Views
    536

    MsOf10 [RESOLVED] Combobox Rowsource

    I have a combobox on a userform that is populated via a RowSource which is a dynamic Named Range. If I delete one of the entries in the Named Range the Named Range address changes as it should, but...
  37. MsOf10 Re: [RESOLVED] Invalid Property Value Mystery

    Thank you both.
  38. MsOf10 Re: Invalid Property Value Mystery

    I want the user to be able to add a new Project ID so how do I get around that?
  39. MsOf10 [RESOLVED] Invalid Property Value Mystery

    In the attached relatively simple workbook, click the "Maintenance" button on the "Projects" sheet. When the userform comes up, type 1 (or any other value that doesn't exist in the list) in the...
  40. MsOf10 Re: Absolutely bizarre workbook behavior

    I looked into this problem several times and it never occurred to me to check to see if those functions were being used as UDFs. Thank you!
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width