Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 0.11 seconds.

  1. Replies
    5
    Views
    131

    Re: Counting and finding years

    depending if you want a formula or vba
    assuming all the dates are in a single column like column A
    =INT((MAX(A:A)-MIN(A:A))/30)
    of course just calculating for 30 day months only is a bit rough, if...
  2. Replies
    10
    Views
    616

    Re: create app for this temp email site

    i would think this would be against the terms of the site
  3. Re: please help data type mismatch select sum

    assuming that the comma is just a decimal or thousands separator not a list of multiple numbers
    you should not store formatted numbers, just numeric as some numeric field type, leave formatting for...
  4. Re: Error no: 484 Problem getting printer information from the system. in VB 6 app

    your attachments are broken
  5. Replies
    16
    Views
    610

    Re: PrintCommunication COM error

    you should be able to test quite simply in excel vba


    Dim p As PageSetup
    Set p = Sheets("sheet1").PageSetup
    p.Application.PrintCommunication = Falsethough as print communication is a property...
  6. Re: vb6: textbox remove space at end

    probably would work when you leave the textbox, else you need to put code in keypress or some other key event to monitor for spaces as the are typed, remove spaces as typed, then put back if some...
  7. Re: A simple solution to accesing a webpage from vb6

    shellexecute will allow you to open a webpage in the default browser, but not interact with it

    w10 still has internet explorer installed, even though they don't want you to use it any longer,...
  8. Re: A simple solution to accesing a webpage from vb6

    there are many examples in this forum of basic code to access web pages, but as not all web pages are equal, any or none of may work for you
    also any code to access web pages may go of of date as...
  9. Re: LynxGrid : grid autosize columns to form size

    did you try dividing rhe width of the grid by the number of columns and making that the width of each column?
  10. Re: how do i wait till a for statement to finish

    some sort of status bar, then update during the loop
    or change to an egg timer cursor or similar, then change back when loop finishes
  11. Replies
    1
    Views
    296

    Re: Appointment calander

    i am sure it would be possible, back in vb5 i created a datepicker, just using std controls, a command button, labels and picturebox,
    also i had forgotten, but there was a thread here recently...
  12. Re: Fix This: Strictly Find That String Only

    If LCase(Left(i.Name, InStr(i.Name, ".") - 1)) = LCase(n) Then to make code easier and probably more efficient i put "prom" into variable n
    as this is case sensitive I converted both to lcase to...
  13. Re: Is it worth buying vb6 cd is it expensive

    then you need to buy vb6 where ever you can find it, as suggested, it certainly is not available from microsoft
  14. Re: mouse drag not working in vb6 editor

    thank you right on the money, so easy i have been really missing this, no idea how it might have got changed
  15. Re: Check if a barcode scanner is launched

    probably too late by then, most modern bar code scanners just work as a keyboard input, so it may be possible to detect some keyboard input and the active control, change the focus and warn the user...
  16. Replies
    11
    Views
    569

    Re: PointsToScreenPixelsX

    i think this one will do what you want with minimum changes

    http://www.cpearson.com/excel/SetParent.aspx
  17. Re: Is it worth buying vb6 cd is it expensive

    you can download and use visualstudio, which includes vb.net, for free, but it is not vb6 which is now obsolete in the real world, only us dinosaurs still using it

    the licencing for vb6 is quite...
  18. Replies
    4
    Views
    318

    Re: how to fix this

    instead of this you would have loop through all the items in the zip file and compare each to list 3, a huge amount of extra processing

    you can use the API to match items in the listbox for exact...
  19. Re: windows dialog pops up file replace / skip

    there is an option 16 for copyhere that will allow to overwrite any existing files without prompt, but as far as i know, nothing to skip existing files
  20. Replies
    7
    Views
    556

    Re: I need help to modify this calendar

    this fixes the month headers to as described

    For i = 9 To 12
    .TextMatrix(0, i - 9) = CStr(mvarYear - 1)
    .TextMatrix(1, i - 9) = MonthName(i)
    Next
    ...
  21. Re: mouse drag not working in vb6 editor

    no add ins at all
  22. Re: mouse drag not working in vb6 editor

    not sure when it stopped working correctly, but it has been for a while now
  23. Re: mouse drag not working in vb6 editor

    hard to move the execution point that way though
  24. [RESOLVED] mouse drag not working in vb6 editor

    recently i have found that i can not drag blocks of code when editing or drag the code execution point when stepping through code
    i am not sure if there are any other symptoms

    this is not...
  25. Re: VB6 Program Compiling Errors -Still Waiting on someone to help.

    do not post the executable, only the project and sample data files, i doubt many will email you
  26. Replies
    7
    Views
    556

    Re: I need help to modify this calendar

    try like

    for i = 9 to 12
    .TextMatrix(0, 0) = CStr(mvarYear - 1)
    .TextMatrix(1, 0) = MonthName(i)
    next
    For i = 1 To 10
    .TextMatrix(0,...
  27. MsOf365 Re: [Word] MS Word: VBA macro works normally in only debug mode

    you could try replacing sleep with doevents
  28. Replies
    14
    Views
    522

    Re: Open document Word with macro (.docm)

    that object library refers to word 2019, whether this is relevant to your problem is unclear
    maybe you can try late binding to see if it changes anything

    change like

    Dim mword As Object, mdoc...
  29. Replies
    14
    Views
    522

    Re: Open document Word with macro (.docm)

    can you open the docx or docm files if you do it manually from windows?
  30. Re: How to connect VB6 program with Google Sheet?

    use the google sheets API

    see
    https://ramblings.mcpher.com/integratingappswithotherplatforms/googlesheetsv4apifromvba/
  31. Replies
    14
    Views
    522

    Re: Open document Word with macro (.docm)

    it may be that a dialogue asking the user to allow macros is being shown, as it is not visible to be dismissed the document is just hanging waiting for response

    test by reducing the security level...
  32. Replies
    2
    Views
    259

    Re: VB6 chat client over internet

    i am sure there is a chat client server example in codebank vb6
  33. MsOf10 Re: Speed up the copying of data from one worksheet to another

    copy the complete ranges into arrays change all the data in the array and rewrite to cells, will be much faster
  34. Re: Increase number of undos in VBIDE for VBA7.dll

    feed it
  35. Replies
    6
    Views
    336

    Re: Urgent need this done simple code

    you can try like

    Set sh = CreateObject("shell.application")
    Set n = sh.Namespace(Text11.Text & "downloaded\kof95.zip")
    Set nn = sh.Namespace(Text11.Text & "downloaded\")
    dest = nn.self.Path &...
  36. Replies
    7
    Views
    433

    Re: Handling Non-Existent Printer Error

    test for each p in printers then set one that is known can work without error, may need to test if printer is online
  37. Replies
    6
    Views
    336

    Re: Urgent need this done simple code

    that looks like a slow way to do it
    just loop through the files in the zip and use dir (or the shell equivalent) to check if each already exists in the destination, if not then extract, no need to...
  38. Replies
    6
    Views
    551

    Re: Combing Macros For Copying Ranges

    i thought you might need to move down a row, if not offset(0) can be omitted

    Range(aa).Select

    i would, as far as possible, avoid working with active anything, also avoid selecting ranges or...
  39. Replies
    6
    Views
    551

    Re: Combing Macros For Copying Ranges

    looks like what i was suggesting, does it work as desired?
  40. Replies
    6
    Views
    551

    Re: Combing Macros For Copying Ranges

    you can use the address of the activecell to return to it like


    Sub Macro1()

    Dim ws As Worksheet

    Set ws = Sheets("INTERNAL")

    If ActiveCell.Column = 2 Then
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width