Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 3.25 seconds.

  1. Re: String has quote by default. How to remove that quote from stringin VBA EXCEL?

    have you tried the parameters for find? lookAt should allow to specify xlPart that should find the value between the quotes
  2. Replies
    5
    Views
    175

    Re: Office 365 Pros and Cons

    personally i think your windows version is more of an issue than the office version
  3. Replies
    1
    Views
    208

    Re: Voice chat over lan in word environment

    i am sure there are some samples for chat programs in the codebank for vb6 and earlier
    while these are probably based for use on the internet, you should be able to limit any of them local area...
  4. Replies
    11
    Views
    353

    Re: BrowseForFolder

    i also prefered XP, and stayed with it for some time,
    i ended up giving up on XP when firefox kept falling over and some other problems, plus some of my VB programs did not work correctly for people...
  5. Replies
    11
    Views
    353

    Re: BrowseForFolder

    there are some threads in this forum detailing how to install vb6 onto w10, as long as you have install disks, maybe bout time you upgraded
  6. Replies
    4
    Views
    215

    Re: Updating formulas for future rows

    most code i write is just to add a missing functionality to someoneelses commercial program, very simple stuff mostly

    the above spreadsheet was created by a friend, i have been updating it...
  7. Replies
    4
    Views
    215

    Re: Updating formulas for future rows

    i think i have solved this with a vba code
    but now the whole problem has become irrelevant, as the spreadsheet will probably be obsolete in a short time, and only kept for history

    how things...
  8. Replies
    4
    Views
    215

    Updating formulas for future rows

    i have a formula that i may need to change the ranges within the formula on occasion, without affecting results for previous rows
    a simple example is

    =C5*P$3-F5+N4, where c5 is in the current...
  9. MsOf10 Re: What can cause Excel to think I have over a million rows

    i do not see where is the problem with the worksheet, but
    you can try some variation of this code to fix the workbook


    Sub dr()
    Dim r As Range, ns As Worksheet
    lr = Cells(Rows.Count,...
  10. MsOf10 Re: What can cause Excel to think I have over a million rows

    1,048,576 is the last row on a sheet, so it appears that the entire sheet is being used

    out of interest how many columns does it think you are using? 16384 is the number of columns on a sheet

    i...
  11. Re: Use special characters as a prefix for function or variable names

    i doubt if it would cause a problem as the ide does not allow such in an english version, must start with an alpha only
  12. Replies
    6
    Views
    213

    Re: Novice Macro Amendment Question

    try like

    lastrow = cells(rows.count, 3).end(xlup).row
    range("c2").resize(,lastrow -1).copyno need to select the cells to copy
  13. Re: Syntax Styles, Shortcuts and binding in VBA

    is that different than if the variable are fully dimensioned? i don't believe so, the bigger issue there is the possibly incorrect use of & or +, depending on the desired result
  14. Replies
    11
    Views
    504

    Re: Fast Ping (non-blocking)

    seems to be a far from perfect solution
  15. Re: Syntax Styles, Shortcuts and binding in VBA

    unlike some other languages where all variables on a line are defined by the last type
    vb6 /vba has to have every variable type defined individually, makes this shortcut style attractive

    i...
  16. Replies
    11
    Views
    504

    Re: Fast Ping (non-blocking)

    have a look at the code posted by olaf
    https://www.vbforums.com/showthread.php?729677-need-help-on-multi-thread-pinger&p=4476707&viewfull=1#post4476707

    i also have some similar code (no idea...
  17. Replies
    9
    Views
    529

    Re: PictureBox Question

    182219this is the project as downloaded from microsoft, you will have to adapt the code to your project
  18. Replies
    9
    Views
    529

    Re: PictureBox Question

    you can resize the the form to fit the desired size
    microsoft had an example for this (printing the form into the picturebox regardless of the size of the form, or whether it was all visible on the...
  19. Replies
    7
    Views
    341

    Re: [RESOLVED] crossword answer vb6

    oops an array of textboxes, glad you got it to work
  20. Re: VB6 exe doesnt work on Windows 10 as well as previous Windows systems.

    Many things

    probably not

    post the parts of the code that are causing issues, including variable and API declares
  21. Replies
    7
    Views
    341

    Re: crossword answer vb6

    you could try like

    For Count = 1 To 25
    oIE.document.All.Item("tasks[" & (Count + 5640) & "]").Value = me.controls("textbox" & count).text
    Next Countno need for double loops, which was...
  22. Replies
    8
    Views
    288

    Re: Problem getting Excel Object Library

    as an aside, you can turn off some of those alerts

    oXLapp.displayalerts = false, this may save some of those issues, but remember to turn the alerts back on before the app goes out of scope, else...
  23. Replies
    6
    Views
    358

    Re: how to delete rows based on calculation

    i gave an example to do just that, checks every cell in column K till it comes to an empty row, then delete all rows that match the criteria
    to correct the code in the original example, change the...
  24. Replies
    6
    Views
    358

    Re: how to delete rows based on calculation

    simple
    if range("k3") < 0.6 then range("k3").entirerow.delete


    as this is a large sheet, you should not delete the rows within the loop, there are 2 reasons for this, but add the ones to be...
  25. Re: This old dog needs to learn new tricks

    optionally just get a win 10 box or laptop
    min 8gb ram and ssd, but other than that can be pretty low end (i3, onboard video and small disk space) for excel, you can move your existing office 2010...
  26. Replies
    1
    Views
    154

    Re: webbrowser insert value help

    so does it find the correct element, or does the loop just go straight past the correct element?
  27. Re: webbrowser ele variable not defind issue

    probably does not have option explicit at the top of the module


    dim ele as objector you can use the specific object type
  28. Re: [RESOLVED] EXCEL2007 Win7 Merged Cells: Test 2 rows in vertically merged cell is

    maybe

    activesheet.usedrange.rows.count ' or whatever sheet objectmind sometimes it may lie, if rows have been used but the values cleared, or there are blank rows at the top of the worksheet, i...
  29. Replies
    2
    Views
    215

    Re: Converting Word to PDF with Bookmarks

    what is the criteria to link the page number to to be displayed to the original reference?

    can you supply a sample document, and information as to how you are creating the pdf from the word doc
  30. Re: EXCEL2007 Win7 Merged Cells: Test 2 rows in vertically merged cell is inconsiste

    you can test if a cell is merged like

    if rng.MergeCells then
  31. Replies
    5
    Views
    509

    Re: Code each item of ComboBox

    this may be how i would write the procedure, using a select case rather than many else ifs and avoiding selecting many cells to assign values
    you could avoid using 2 lines for each case just by...
  32. MsOf10 Re: Conditional formtting of today's date

    that is 2010
    conditional formatting > highlight cell rules > a date occurring
  33. MsOf10 Re: Conditional formtting of today's date

    182100is this what you want?
  34. Replies
    2
    Views
    336

    MsOf10 Re: Combobox Rowsource

    did you try setting the rowsource to the named range again?

    when i tested the entries in the combobox reflected the deleted items anyway
  35. Re: VBA store data from file in web to matrix

    you need a reference to microsoft xml (ver 3 seems to work ok), it is mentioned further down the page, note i did not get the example to work fully

    possibly by a pivot table
  36. Re: Challenges Working with winsock and Ms Access VBA

    we can only assume you are using a 64bit version of office?
    and that your variables strdata and chands have values assigned to them prior to using?

    the small test i tried appeared to open a...
  37. Re: VBA store data from file in web to matrix

    in vb6 you can use a user control, but i doubt that applies to VBA, but you can download using xmlhttp (which you are already doing) asychronously, that is downloading multiple files at the same time...
  38. Replies
    7
    Views
    570

    Re: Winsock, what is it?

    basically you send and receive packets, get the server responses which could be web pages, files or emails, depending what you asked for, read back the packets, assemble the data and display however...
  39. MsOf07 Re: EXCEL Macros quit working: My Set EXCELWorkBook = Statement fails

    also global is a bit old school, public should be enough if placed in a standard module
    also we have no idea how you are disposing of your objects when finished with them

    the bits of code as...
  40. Re: VBA store data from file in web to matrix

    can you download the files on a daily or weekly basis as a background task, then save them to the local machine, ready to go

    also the website may include terms of use that do not allow automated...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width