Search:

Type: Posts; User: jdc2000

Page 1 of 13 1 2 3 4

Search: Search took 7.05 seconds.

  1. Re: DisplayResolution 2560 x 1440 gives run-time 6 overflow error program made with

    Monitor:
    https://www.walmart.com/ip/TCL-43-Class-4K-UHD-LED-Roku-Smart-TV-4-Series-43S421/220975865...
  2. Re: How to remove system tray icon of another application?

    Depending on how knowledgeable the child is, they might just look in Task Manager or Services. You can set the user profile to hide the icon, but that can be overridden by the user. To really hide...
  3. Re: How to remove system tray icon of another application?

    Without stopping it or killing the process/service?
  4. Replies
    14
    Views
    404

    Re: Date Type Mismatch

    What do you get with this code:



    Debug.Print ThisWorkbook.ActiveSheet.Cells(i2, 10).Value
  5. Replies
    14
    Views
    404

    Re: Date Type Mismatch

    What happens if you try this:



    startdate = CDate(ThisWorkbook.ActiveSheet.Cells(i2, 10).Value)
  6. Replies
    8
    Views
    422

    Re: List file from http://www.mysite/public/

    Let me Google that for you:

    https://www.aspsnippets.com/Articles/Display-list-of-files-from-Server-folder-in-ASPNet-GridView.aspx
  7. Re: Pastespecial Paste Columnwidths code break

    Try this:



    Sub Save()

    Dim wb As Workbook, mypath As String
    With Worksheets("Master").UsedRange

    Set wb = Workbooks.Add
  8. Thread: vba issue

    by jdc2000
    Replies
    4
    Views
    249

    Re: vba issue

    I am still not clear on how your VBA code and the EPIC.exe file are linked. Where is your text file written out? Is it created by your VBA code or by the EPIC.exe program?
  9. Replies
    8
    Views
    497

    Re: GET version from exe

    Now you tell us. Next time, try mentioning that in your initial post.

    https://www.daniweb.com/programming/software-development/threads/200626/display-version-number-in-vb6
  10. Replies
    8
    Views
    497

    Re: GET version from exe

    If the creator of that .exe file supplied a version number, then if you hover the mouse pointer over the my.exe in Windows (File) Explorer, it should show. You can also try right-clicking on the...
  11. Replies
    5
    Views
    346

    Re: iterate table in access database

    Step by step process:

    1. Open a web browser

    2. Enter https://www.google.com into the address bar

    3. When the page loads, enter "microsoft access get table names from database" into the...
  12. Replies
    3
    Views
    220

    Re: Adapt excel macro to accept dir.

    Post the VBA code here (inside CODE tags) so we can see it without needing to access another web site.
  13. Re: VBScipt to print multiple excel files with multiple tabs within a folder

    You can have your script get the path of the current directory (assuming that your script is in the same directory as the files to print), then get the names of the files to print (all .xlsx files),...
  14. Re: VBScipt to print multiple excel files with multiple tabs within a folder

    Can we assume that your 5 workbooks have fixed names? If yes, then you can just add some lines to open each of them and print them out.

    oExcel.Workbooks.Open currentPath & " \ " & "Additional...
  15. Replies
    5
    Views
    309

    Re: Check if Date is greater than todays date

    Regarding your code line in post #1, who knows what data types the 2 expressions will be. If you actually tried the code I posted, your issue would probably be solved. That codes compares a String...
  16. Re: Excel VBA Macro to start a local video in fullscreen mode using a shortcut

    The only other way would be if you could somehow determine when the video had stopped playing, then kill WMPlayer.
    ...
  17. Replies
    5
    Views
    309

    Re: Check if Date is greater than todays date

    If CStr((Format(rs.Fields("ShipDate"), "yyyy-mm-dd")) > CStr(Format(Now(), "yyyy-mm-dd"))) = True Then


    Or



    Option Explicit
  18. Replies
    5
    Views
    299

    MsOf365 Re: Word - Fill Image in Mail Merge

    Possibly useful links:

    http://www.gmayor.com/mail_merge_graphics.htm

    https://community.spiceworks.com/how_to/2675-using-mailmerge-to-insert-images
    ...
  19. Re: Excel VBA Macro to start a local video in fullscreen mode using a shortcut

    For item 1:
    The setup steps for creating the batch file need Administrator access, however, you should not actually need to run the batch file As Administrator to get it to work. It should not give...
  20. Replies
    1,636
    Views
    75,863

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

    https://www.zdnet.com/article/singapore-startup-develops-covid-19-breath-detection-test/
  21. Replies
    5
    Views
    267

    Re: Arrow buttons in the tab control

    If it is VB .NET:

    https://www.pcreview.co.uk/threads/hiding-tabcontrol-horizontal-scroll-buttons.3268427/
  22. Re: Excel VBA Macro to start a local video in fullscreen mode using a shortcut

    Possibly useful link:

    https://smallbusiness.chron.com/start-windows-media-player-full-screen-54710.html
  23. Replies
    16
    Views
    636

    Re: Timestamp on data change

    Is the cell that gets the time stamp always the same, or always at the end of the sheet with the updated data?

    I have an idea on how to change the code so it will work with a selected range. ...
  24. Replies
    16
    Views
    636

    Re: Timestamp on data change

    I never try to set cell values using a Range qualifier, so I have not seen this error before.

    Will the cells you are wanting to compare always be in sheets in the same workbook?
    If yes, and you...
  25. Replies
    16
    Views
    636

    Re: Timestamp on data change

    Attached is a test workbook that does not get that error.
  26. Replies
    3
    Views
    2,115

    Re: Xaml in Xamarin Forms

    Possibly useful links:

    https://www.includehelp.com/xamarin/use-special-symbols-in-label-as-text.aspx

    https://docs.microsoft.com/en-us/xamarin/xamarin-forms/user-interface/text/label
  27. Replies
    7
    Views
    301

    Re: running powershell through vb.net

    Possibly useful links:

    https://tecadmin.net/powershell-running-scripts-is-disabled-system/

    https://superuser.com/questions/106360/how-to-enable-execution-of-powershell-scripts
    ...
  28. Re: Determine Who's Dropping My Server Connection

    The USB might be a concern of you were using a USB to ethernet adapter.

    If you have an ethernet connection on the motherboard, you should be OK.

    Make sure that there are no Sleep options turned...
  29. Replies
    7
    Views
    301

    Re: running powershell through vb.net

    Possibly useful link:

    https://www.emoreau.com/Entries/Articles/2018/06/Running-a-PowerShell-script-from-a-Net-application.aspx
  30. Re: Determine Who's Dropping My Server Connection

    You need to check the hard to find link for the Advanced Power Settings. Microsoft hides things they don't want you to see. Also, access it through the old style Control Panel, not the new Settings...
  31. Re: Determine Who's Dropping My Server Connection

    If your mouse move program prevents the drops, then it is almost certainly Windows 10 that is dropping the connection.

    Check the Power settings to make sure that only the screen turns off when...
  32. VS 2019 Re: How do I output from a PShell script (PSObjects?) to a WinForms TextBox in real-t

    More links:

    https://forums.asp.net/t/2131798.aspx?How+to+execute+a+PowerShell+script+and+continuously+write+the+output+to+a+TextBox+
    ...
  33. VS 2019 Re: How do I output from a PShell script (PSObjects?) to a WinForms TextBox in real-t

    Possibly useful links:

    https://www.sapien.com/blog/2014/12/15/display-output-in-a-gui-application-copy/

    https://blogs.lessthandot.com/index.php/desktopdev/mstech/powershell-in-your-vb-net-1/
  34. Thread: Spam Tracking

    by jdc2000
    Replies
    6
    Views
    252

    Re: Spam Tracking

    The link below may be close to what you are looking for:

    https://www.spamhaus.org/rokso

    Spammers change domains and IP addresses all the time, since many of them use hijacked computers. This...
  35. Re: Excel 2019: ActiveX-Listbox works on my computer, but not on another Computer

    Are they greyed out? I assume that you cannot click on the text box and enter anything.

    I would check the Windows version and Excel version between the 2 machines to see if there are any...
  36. Re: Setting header text in different column for .xls file

    If you are wanting to double-click on a .csv file and have it open in Excel with leading zeros preserved, you are out of luck. Excel will automatically remove them if you open files this way. There...
  37. Re: Setting header text in different column for .xls file

    You can import a .csv file into Excel and keep the leading zeros. The method to use depends on how you are loading the .csv file.

    Possibly useful links:
    ...
  38. Re: Setting header text in different column for .xls file

    That looks more like a comma separated .csv file. You could replace the separator commas with Tab characters (Chr$(9)).
  39. Replies
    18
    Views
    1,430

    Re: ThunderVB installed - problem at loading VB6

    You did run the VB6 install and SP6 install from an Administrator account, As Administrator, and run VB6 the same way?
  40. VS 2019 Re: How to create a symlink using Visual Basic code?

    Possibly useful links:

    https://stackoverflow.com/questions/31795650/creating-symbolic-links-using-visual-basic
    ...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width