Search:

Type: Posts; User: jdc2000

Page 1 of 13 1 2 3 4

Search: Search took 13.63 seconds.

  1. 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),...
  2. 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...
  3. Replies
    5
    Views
    195

    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...
  4. 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.
    ...
  5. Replies
    5
    Views
    195

    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
  6. Replies
    5
    Views
    154

    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
    ...
  7. 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...
  8. Replies
    1,499
    Views
    66,046

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

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

    Re: Arrow buttons in the tab control

    If it is VB .NET:

    https://www.pcreview.co.uk/threads/hiding-tabcontrol-horizontal-scroll-buttons.3268427/
  10. 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
  11. Replies
    11
    Views
    289

    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. ...
  12. Replies
    11
    Views
    289

    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...
  13. Replies
    11
    Views
    289

    Re: Timestamp on data change

    Attached is a test workbook that does not get that error.
  14. Replies
    3
    Views
    1,984

    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
  15. Replies
    7
    Views
    218

    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
    ...
  16. 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...
  17. Replies
    7
    Views
    218

    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
  18. 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...
  19. 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...
  20. 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+
    ...
  21. 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/
  22. Thread: Spam Tracking

    by jdc2000
    Replies
    6
    Views
    192

    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...
  23. 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...
  24. 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...
  25. 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:
    ...
  26. 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)).
  27. Replies
    18
    Views
    1,298

    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?
  28. 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
    ...
  29. Replies
    1
    Views
    323

    Re: design a PDF-layout in Visual Studio 2019

    Possibly useful links:

    https://www.codeproject.com/Articles/23105/Programmatically-Complete-PDF-Form-Fields-using-Vi
    ...
  30. Replies
    1,499
    Views
    66,046

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

    https://www.zdnet.com/article/microsoft-excel-blunder-developers-blamed-for-loss-of-thousands-of-covid-19-test-results/
  31. Re: Vb6: search for more than one word in textbox

    If InStr(1, RichTextBox1.Text, "a") And InStr(1, RichTextBox1.Text, "b") And InStr(1, RichTextBox1.Text, "c") Then
    ' Do whatever
    End If




    What do you mean "it stopped working after a...
  32. Replies
    6
    Views
    330

    Re: evento per combobox

    Possibly useful links:

    https://www.vbforums.com/showthread.php?508872-on-screen-keyboard-using-VB6

    https://www.codeguru.com/columns/vb/making-an-onscreen-keyboard.html
  33. Replies
    6
    Views
    330

    Re: evento per combobox

    This is an English speaking web site. Run your text through Google Translate before posting:

    maybe i found a little way to get started and that is:

    My.Computer.Keyboard.SendKeys ("a", True) 'I...
  34. Replies
    6
    Views
    330

    Re: evento per combobox

    Translation:

    Good evening, with Vb.net in a form I reproduced a virtual querty keyboard, because in my application I cannot call the windows one. Among other things, I will use a touch panel...
  35. Re: vb.net Use a different WebBrowser1 base than IE-11 ?

    Note that even if you set it to report IE11, you will still get "Browser not supported" reports from a lot of web pages, even if the page would actually work in IE11.
  36. Re: Add a sub-folder in Package & Deployment Wizard

    Possibly useful link:

    https://www.samlogic.net/visual-installer/tips/tips-pages/create-installation-for-vb6-application/create-installation-for-vb6-application.htm
  37. Re: Add a sub-folder in Package & Deployment Wizard

    Are you wanting to add items to the User's Start Menu folders, or the All Users Start Menu folders?

    You should be able to create folder subfolders as needed and place items in them.
  38. Re: Add a sub-folder in Package Development Wizard

    Possibly useful links:

    http://etutorials.org/Programming/Mastering+visual+studio+.net/Chapter+6.+Setup+and+Deployment/6.7+File+System+View/
    ...
  39. Re: Send Commands To CMD Window (without sendkeys)?

    https://www.vbforums.com/showthread.php?614894-Need-to-start-a-command-line-window-and-send-a-string-to-it
  40. Re: Help with Appending Access from Excel

    It would be helpful if we knew what line was actually causing the error.

    Possibly useful link:
    ...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width