Search:

Type: Posts; User: jdc2000

Page 1 of 13 1 2 3 4

Search: Search took 0.24 seconds.

  1. Replies
    12
    Views
    183

    Re: $%%$$%# Personal.xlsb

    Another links:

    https://www.mrexcel.com/board/threads/personal-workbook-keeps-opening-how-do-i-stop-it.78137/

    https://bettersolutions.com/excel/macros/personal-xlsb.htm
  2. Replies
    12
    Views
    183

    Re: $%%$$%# Personal.xlsb

    Try a System Restore to a point before you created the file.
  3. Replies
    12
    Views
    183

    Re: $%%$$%# Personal.xlsb

    What part of that did not help? If you have macros in Excel, that file will exist, although it is normally hidden.

    https://www.excelvbasolutions.com/2017/08/how-to-remove-personalxlsb-file.html
    ...
  4. Replies
    12
    Views
    183

    Re: $%%$$%# Personal.xlsb

    Possibly useful link:

    https://www.groovypost.com/howto/stop-personal-xlsb-opening-excel/
  5. Replies
    3
    Views
    168

    Re: VB6 test environment setup

    If you do not have the source code for the VB6 application, then it would be hard to determine if there was something else that might need to be changed or not. There may be some hard-coded link...
  6. Replies
    11
    Views
    204

    Re: More programmer pet peeves

    "Aw Snap"
  7. Re: Do you know how to access BT Email Login ?

    This is not really an Application Testing question, more like General PC.

    Possibly useful link:

    https://www.bt.com/help/email/need-help-logging-in/need-help-logging-in-to-your-bt-email-
  8. Re: Cannot overwrite Combobox Value with new text

    Did you get any errors? If not, then it is probably allowed. If it did not do what you were expecting, that is a different question.

    Did you put a break point on each statement and then check to...
  9. Re: Why is my form locking up my computer when it loses focus?

    The users would not see any difference, other than that the controls would not scroll, only the data would.
  10. Re: Why is my form locking up my computer when it loses focus?

    OK, so you have 2 records on that screen. Can your form be resized so that you can see more than 2 records at a time without scrolling? At the maximum form size, how many records could actually be...
  11. Re: Why is my form locking up my computer when it loses focus?

    With 1400 controls, how would you even find the one you wanted to use?

    Maybe a screen capture of what your form looks like might be helpful. We might then be able to suggest some ideas.
  12. Re: [RESOLVED] How do I make a .crt (certificate) file that actually can be uninstall

    Thanks for the update. This looks like it will be quite useful.
  13. Replies
    1
    Views
    139

    Re: Access Error Runtime Error 3075

    That error would generally indicate a problem with your query, however, it is probably not the complete error message. The complete message would be helpful.

    Also, the actual text of that huge...
  14. Re: [RESOLVED] (Different Macro) if sheet is blank then do nothing(macro modification

    Not sure where you got those code ideas. Did you even look at the links I posted? Since we do not know what sort of data format your sheets are supposed to contain, we can only guess as to the best...
  15. Re: (Different Macro) if sheet is blank then do nothing(macro modification)

    What modifications did you make, and what were you wanting them to do? We need details of your idea for a check for a blank sheet. Also, post the code you tried.
  16. Replies
    7
    Views
    431

    VS 2015 Re: Executable file keeps deleting

    What antivirus or antimalware programs are you running? Chances are, one of those is detecting a VB program and thinking it is malware, and zapping it. Try disabling your antimalware/antivirus and...
  17. Re: (Different Macro) if sheet is blank then do nothing(macro modification)

    Other ways to check for a blank sheet:

    http://www.vbaexpress.com/forum/showthread.php?11681-Solved-Check-if-sheet-is-blank

    https://excel.tips.net/T003280_Testing_for_an_Empty_Worksheet.html
    ...
  18. Re: If column C has blank cell then delete that entire row in two files(macro correct

    See your other thread:

    https://www.vbforums.com/showthread.php?887948-(Different-Macro)-if-sheet-is-blank-then-do-nothing(macro-modification)&p=5488082#post5488082
  19. Re: (Different Macro) if sheet is blank then do nothing(macro modification)

    Assuming that a valid sheet has a non-blank cell A1, the following would work:



    Sub STEP6CORRECTIONPENDING()
    Dim Wb1 As Workbook, Wb2 As Workbook
    Dim Ws1 As Worksheet, Ws2 As Worksheet
    Dim...
  20. Replies
    4
    Views
    258

    Re: Return Word wdDialogEditFind options

    Maybe:



    wdDialogEditFind.Find


    https://docs.microsoft.com/en-us/office/vba/api/word.dialog.show
  21. Re: Redirect HTTP to HTTPS in IIS 10 / Windows 2016

    Possibly useful links:

    https://tecadmin.net/iis-redirect-http-to-https/

    https://serverfault.com/questions/893315/best-way-to-redirect-all-http-to-https-in-iis
  22. VS 2015 Re: console app only shows console when double clicked

    Right-click on the folder in question, and select Properties. There should be a Sharing and a Security tab. Do this for each computer. Check the differences in the settings between the computer...
  23. Re: windows 10 is blocking this site

    When you do this, you are using a different DNS Server - the one that the free VPN service is using.

    Enter the following command into a Command Prompt window to find out what DNS Servers your...
  24. Re: windows 10 is blocking this site

    It is probably not Windows 10, but more likely the DNS Server that your Windows 10 computer is using that is not blocking, but failing to find this site. You could try changing the DNS Servers to...
  25. Replies
    23
    Views
    664

    Re: Non-US Perspective of US - virus feedback

    https://www.cnet.com/health/5g-coronavirus-conspiracy-theory-sees-77-mobile-towers-burned-report-says/
  26. Re: [RESOLVED] If user computer only NET Framework 3.0, which VS(VB) version is bette

    I have an application that I use that requires .NET 2.0. It will work with the .NET 3.5 installed. On Windows 10, I have to install the .NET 3.5 framework in order to get this application working. ...
  27. Replies
    1,300
    Views
    44,124

    Re: Corona virus, China major city lockdowns, etc.

    https://www.zdnet.com/article/how-many-covid-19-infections-are-asymptomatic-research-shows-it-may-be-a-lot-more-than-thought/
    ...
  28. Replies
    7
    Views
    669

    Re: Browser jumping

    Many web "pages" these days are set up to only load images once you have scrolled down far enough to see them. This is because otherwise you would need a gigabit internet connection and at least an...
  29. Replies
    7
    Views
    669

    Re: Browser jumping

    What method are you using for scrolling? If you are using the mouse wheel, try using the arrow keys or clicking and dragging the scroll bar to see if the results are the same or different. I...
  30. Replies
    42
    Views
    2,757

    Re: Do users like it old?

    I have no plans to jump on Microsoft's bandwagon and make my programs look like they were designed by a third-grader. If I am putting a button on a form, I want it to look like a button so that...
  31. Replies
    42
    Views
    2,757

    Re: Do users like it old?

    Just because Microsoft or some other big company has come out with a "new" or "Modern" style for displaying things does not mean that those new styles are better or more efficient or are easier and...
  32. Re: vBulletin - Current Forum Version and Latest Version

    Just looked at Discourse. It has the typical "modern" look with plenty of bling-bling and eye-candy, but the reviewers also complained that it tends to look cluttered. It also appears to be missing...
  33. Thread: Post Race!

    by jdc2000
    Replies
    64,520
    Views
    5,112,697

    Re: Post Race!

    All of my computers and network gear are on UPS units. I have had to replace the battery in one APC unit, and it was available. When I first set up a home computer, I tested the power at my home...
  34. Thread: Post Race!

    by jdc2000
    Replies
    64,520
    Views
    5,112,697

    Re: Post Race!

    UPS = Uninterruptable Power Supply

    https://www.newegg.com/cyberpower-cp1500pfclcd-nema-5-15r/p/N82E16842102134
  35. Re: PowerPoint - Informing other application that VBA macro is finished

    Possibly useful links:

    https://www.vbforums.com/showthread.php?682427-Sending-Text-to-another-App-using-SendMessage
    ...
  36. Re: PowerPoint - Informing other application that VBA macro is finished

    That might depend on what you might consider "more advanced". VBA can do most of what VB6 can, so it might be possible to have the VBA code send information directly to your VB6 program to indicate...
  37. Re: vBulletin - Current Forum Version and Latest Version

    There are alternative forum software packages available, however, I have seen and used many different forum software packages and I have yet to see one that looks as good as or works as well as...
  38. Replies
    48
    Views
    1,655

    Re: Still no SSL?

    Note that certificates will now expire every year:

    https://www.zdnet.com/article/apple-strong-arms-entire-ca-industry-into-one-year-certificate-lifespans/
  39. Replies
    1,300
    Views
    44,124

    Re: Corona virus, China major city lockdowns, etc.

    177772
  40. Replies
    42
    Views
    2,757

    Re: Do users like it old?

    The "New UI" with its flat look and replacement of menus with cryptic symbols and hieroglyphics is another time waster. You have no idea what to click on to get a task done, and it is hard on the...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width