Search:

Type: Posts; User: jdc2000

Page 1 of 13 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    7
    Views
    204

    VS 2012 Re: Beginner - start help

    VBA info links:

    https://docs.microsoft.com/en-US/office/troubleshoot/word/autoexec-autoopen-macros-word

    https://docs.microsoft.com/en-us/office/vba/word/concepts/customizing-word/auto-macros
    ...
  2. Re: Customer Name which can contain a string and integer

    If all you need is to determine whether a consecutive 4 digits is in the name, assuming that you will not have 5 or more consecutive digits, the following link might be useful.
    ...
  3. Re: Change screen resolution - device independent

    baka -

    Here is the section I saw from your linked document:



    Post the code for your function that is not working on Windows 8+.
  4. Replies
    2
    Views
    202

    Re: ERROR Failed to export the report

    That is not much information to go on. When does the error occur? Is an error from Crystal Reports when it is generating the report? Where is Crystal reports getting the data for the report - from...
  5. Re: Visual Basic NMEA serial port problem

    Lots of extra data, but missing some crucial data in this post.

    So, if I am correct in my analysis, you are attempting to read in GPS data through a serial port to your old software but using a...
  6. Re: Two things I can't seem to figure out VS2017, wpf

    https://www.onmsft.com/how-to/move-screen-keyboard-windows-10-windows-10-mobile#:~:text=When%20the%20keyboard%20appears%20and,up%20and%20down%20the%20screen.
  7. Replies
    8
    Views
    365

    VS 2017 Re: Sort a 2D Array on two columns

    Possibly useful link:

    http://vbcity.com/forums/t/67392.aspx
  8. Replies
    8
    Views
    365

    VS 2017 Re: Sort a 2D Array on two columns

    I am guessing that ssabc is thinking of something like an Excel spreadsheet, sorted on 2 columns.
  9. Replies
    4
    Views
    343

    Re: New to VBA and need help!

    Possibly useful links to get you started:

    https://gregmaxey.com/word_tip_pages/using_a_macro_to_replace_text_wherever_it_appears_in_a_document.html
    ...
  10. Replies
    4
    Views
    459

    Re: vbscript import xml data to excel

    You could still use Excel to import the .xml data and transfer it, but automate that process using VBScript.

    Possibly useful links:
    ...
  11. Replies
    4
    Views
    459

    Re: vbscript import xml data to excel

    Excel can import .xml files. It might be easier to do that and use VBA to copy that data to the sheet you want to add it to.
  12. Re: SOLVED -- Active Reports prints picture different size on some PCs

    This can happen if someone has set the printer they are using to something strange that affects how the margins or other print layout settings are set up.
  13. Replies
    1
    Views
    262

    Re: How to perform operation in socket.io?

    Possibly useful link:

    https://stackoverflow.com/questions/1337419/how-do-you-convert-numbers-between-different-bases-in-javascript
  14. Replies
    6
    Views
    409

    Re: Digital Certificates

    https://www.pcmag.com/how-to/enable-internet-explorer-mode-windows-11
  15. Re: VB for Applications - MS Word - String.Subtring(3, 7) not working

    I don't see where you are actually using the jobNum as part of the file name.

    Have you checked to see what thisDate actually contains?

    Check to see what ActiveDocument.Path & thisDate would be....
  16. Re: File copy seems to fail on Windows Embedded

    If you use Windows Explorer on the thin client, and can locate the file, click on the path and copy it to Notepad. That should show you where the file actually is. I always set Windows to show the...
  17. Replies
    4
    Views
    370

    Re: COUNTIF woes

    Possibly useful links:

    https://www.exceltrick.com/how_to/count-unique-values-excel/
    ...
  18. Replies
    6
    Views
    526

    Re: Issue with Foxpro connection

    Since it was working OK, and is still working OK on a local system, my first thought is that something is redirecting the path somewhere on the server. Does the path have a full specification (drive...
  19. Replies
    22
    Views
    1,231

    Re: LibreOffice

    AccessShell -

    I think what wqweto was getting at was that if you use WPS Office (they have a free version) instead of LibreOffice, then it would be much easier to program that since it is very...
  20. Replies
    13
    Views
    949

    Re: Problem with Shortcuts.

    OK, those file names are .exe files and should not contain reserved words.

    Here is a link with information on how to pin a .bat (batch) file to the Taskbar:
    ...
  21. Re: Excel VBA method "Value" of object 'range' failed

    What line of code do you get the error on?
  22. Replies
    13
    Views
    949

    Re: Problem with Shortcuts.

    What name are you trying to give the Shortcut?

    Post the file name for the application (Example: MyApp.exe)

    Have you tried the method where you call Explorer.exe to launch the program from a...
  23. Replies
    13
    Views
    949

    Re: Problem with Shortcuts.

    You can just ignore the "free download" ads.

    The issues that the links mentioned included certain reserved words that cannot be in a Taskbar shortcut. To test for this, try renaming your Taskbar...
  24. Replies
    13
    Views
    949

    Re: Problem with Shortcuts.

    Possibly useful links:

    https://www.tipsdotcom.com/cannot-pin-program-to-taskbar.html

    https://www.tenforums.com/general-support/4407-cant-pin-certain-desktop-shortcuts-taskbar.html
  25. Re: Show available workbooks in date descending order

    Zvoni -

    That is what I thought the normal behavior should be.

    Possibly useful links:

    https://wordribbon.tips.net/T013604_Default_Sort_Order_in_the_Open_Dialog_Box.html
    ...
  26. Re: Show available workbooks in date descending order

    I do not recall the Excel 2019 File Open dialog sorting the files on my system by date, but I will check out one of my systems with Office/Excel 2019 later today and see what order I actually have.
  27. Replies
    9
    Views
    773

    MsOf365 Re: Add second sheet to Workbook in Code

    VB .NET link:

    https://social.msdn.microsoft.com/Forums/vstudio/en-US/17998487-b9e9-427c-92d4-4dd1f638fe0c/add-sheets-to-excel-via-vbnet?forum=vsto
  28. Replies
    9
    Views
    773

    MsOf365 Re: Add second sheet to Workbook in Code

    Possibly useful links:

    https://www.automateexcel.com/vba/add-and-name-worksheets/

    https://www.vbforums.com/showthread.php?391665-Tutorial-FAQ-How-to-Automate-Excel-from-VB6-(or-VB5-VBA)
    ...
  29. Replies
    14
    Views
    767

    Re: vb6 mouse click without moving mouse?

    No macro recorder in Outlook:

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/7fa3a3b4-36a6-4821-b00e-d411e0c89fec/macro-recording-feature-for-outlook-not-available?forum=outlookdev
    ...
  30. Replies
    14
    Views
    767

    Re: vb6 mouse click without moving mouse?

    What could you possibly do with received emails in a picture box? For that you could just screen capture the Outlook window.

    Outlook is not going to let you automate it that way, precisely to...
  31. Replies
    7
    Views
    432

    Re: VB 6.0 Comm Port number higher than 16

    Set Device Manager to Show Hidden Devices, then you can delete them.
    ...
  32. Replies
    9
    Views
    773

    MsOf365 Re: Add second sheet to Workbook in Code

    So, what happens with the code? Error message (post here), does nothing, etc.?

    Possibly useful link:
    ...
  33. Replies
    7
    Views
    432

    Re: VB 6.0 Comm Port number higher than 16

    There was, and probably still is, a way to limit the COM port numbers:
  34. Replies
    13
    Views
    692

    Re: Error process start on windows 11

    Possibly useful link:

    https://winaero.com/run-as-administrator-in-windows-11-multiple-way-to-start-apps-elevated/

    Scroll down in the above article to see how to always start a program with...
  35. Replies
    13
    Views
    692

    Re: Error process start on windows 11

    You may want to check the user accounts that have access rights to the D:\AnyDesk folder on both systems. Compare them to see what user have what rights on the Windows 10 system where everything...
  36. Replies
    4
    Views
    566

    Re: MS Office Click-to-Run Service

    Microsoft does not want you to keep it disabled. To do that, you might have to write a monitoring program that looks for it and checks its status, then sets it back to disabled periodically. The...
  37. Re: Using VB6 - Lost Contact With COM1.

    You might be waiting quite a while for a reply from Gigabyte.

    I would test the COM port to see if it is working while you are waiting.

    If it has failed, you may need an add-in card:
    ...
  38. Re: Using VB6 - Lost Contact With COM1.

    If that does not work, use the links I posted on How to Test a COM Port to see if the COM port is actually working. Just because Device Manager says it is working does not mean that is actually...
  39. Re: Using VB6 - Lost Contact With COM1.

    It looks like that motherboard does have a serial port header. If that is where the rear panel connector goes to, then you have a real serial port. The place to try a reinstall would be in Device...
  40. Re: Using VB6 - Lost Contact With COM1.

    Is this a real COM port, with actual serial port hardware, or a USB to serial type of COM port?

    How to test a COM port:

    https://www.startech.com/en-us/faq/serial-loopback-test-rs232-windows
    ...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width