Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 0.27 seconds; generated 30 minute(s) ago.

  1. Replies
    4
    Views
    141

    Re: VB / CDO Email Attachment Link

    have you tried double clicking the attachment?
  2. Re: VBA Macro gets slower with every execution

    by not filling it first is the best method

    personally i would change from using application.ontime, change to an API timer


    simplest example


    Workbooks("Etuve.csv").Close False
  3. Replies
    2
    Views
    91

    Re: Recorrer con For en ListView

    even with the translation, this is pretty had to understand

    on which line does the error occur?, what is the value of i and the value of .listitems.count
  4. Re: [RESOLVED] get value for a variable where the name of the variable is composed dy

    you can add all /some controls to a collection of classes of control objects for a type of control, this will allow the receipt of events as well as access to properties (similar to a control array...
  5. Re: VBA Macro gets slower with every execution

    how are you firing the one minute event?

    i would avoid (find an alternative to) all lines that select, activate or use any selection or active anything

    does it really require a userform for...
  6. Replies
    10
    Views
    537

    Re: Excell With V.B

    i have asked for this to be moved (pls do not duplicate) to office development, but it may be separated from the original old thread

    as later versions of excel are quite different, particularly in...
  7. Re: Use VBA to run a code on multiple excel files yet each doesn't save a new sheet

    you should avoid selecting anything or using active anything, to prevent errors, especially when working with multiple workbooks

    try like

    Set wsSource = wb.Sheets(1)
    Set wsSource =...
  8. Re: Manage Excel workbooks from a Powerpoint macro (VBA)

    the error would suggest there is no currently open instance of excel

    there is no need for a reference when using late binding of objects (getobject or createobject) this is ideal when you may not...
  9. Re: How to change plot area size of a shape pasted from an Excel file to a powerpoint

    i do not have powerpoint, so can not give an authoritative answer, but if i was trying to do it, i would look to create a temporary chart, as desired, in excel then just copy that to powerpoint
  10. Re: Manage Excel workbooks from a Powerpoint macro (VBA)

    this should fix your code

    Function PromptForWorkbook() As String
    Dim N As Long
    Dim s As String
    Dim myString As String
    Dim WB As Object
    Dim xl As Object
    Set xl =...
  11. Re: Select non-consecutive columns with a VBA macro

    i would believe this should do what you want

    Dim rng As Range, cel As Range
    Set rng = Selection

    For Each cel In Selection
    Set rng = Union(rng, cel.Resize(Cells(Rows.Count,...
  12. Replies
    1
    Views
    130

    Re: Add a range to a selection

    you can add a selection to a range like

    Set cel = Range("B6")
    Set cel = Union(cel, Selection)
    cel.select

    but it would be hard to have an active cell that is not included in the selection, or...
  13. Replies
    11
    Views
    383

    Re: keep getting a input past end of file

    i would be looking for an end of file marker within the file

    attempt to open the file for binary instead, see if it resolves the error
  14. Re: [Word] Trying to automatically change the font size of numbers in a textbox

    the above code would probably work for any given text, but how you specify the text to work with will change, but you have not given any clue as to the range of text you want to work with

    part of...
  15. Re: [Word] Trying to automatically change the font size of numbers in a textbox

    it certainly was more evident in the sample i tested

    i was only guessing it was even in word, nevermind what type of container, but no mention anywhere about a userform
    maybe s/he will come back...
  16. Re: [Word] Trying to automatically change the font size of numbers in a textbox

    maybe this is just a website issue, but i really can not see the difference in output

    you can try like

    Set tb = ThisDocument.Shapes(1)
    With tb
    For Each ch In...
  17. Re: Is it possible to do this sum?

    looks like he wants the sum of the last or really the min quantity for each item_id
  18. Replies
    8
    Views
    373

    MsOf10 Re: Circular Reference

    unless microsoft has broken something in later versions
  19. Replies
    8
    Views
    373

    MsOf10 Re: Circular Reference

    exactly

    on inspection, while your demo is not as described originally, the formula are in a separate column, it works without error or circular reference, in my excel version
  20. Replies
    8
    Views
    373

    MsOf10 Re: Circular Reference

    i have no idea why it should start to happen, just amazed that it ever worked at all
    you are looking to countif the values matching the cell containing the formula, not an actual value and even if...
  21. Re: VBA code must produce error with message if Excel is not completely filled

    the selected items in the dropdowns are not values in the cells they cover, so have to be tested separately

    this code will check all dropdowns on the worksheet for option selected, then all cells...
  22. Re: VBA code must produce error with message if Excel is not completely filled

    can you post a workbook here (zip first) with some sample data
  23. MsOf13 Re: How do we remake the program to copy not one value value but with range in column

    Sub Insertdata()
    Dim src As Workbook
    Dim fnd As Range
    Dim d As Integer
    Dim lastrow As Integer
    Dim Rng As Range

    Set src = Workbooks.Open("c:\temp\dr\age.xlsm", True,...
  24. Replies
    4
    Views
    282

    Re: New to Word Mail Merge

    create a word mail merge document (or convert an existing document) and attaching the required merge source, then place mergefields for each of the required database fields in the appropriate...
  25. Replies
    14
    Views
    442

    Re: This Macro takes 6 hours to run!!!

    i am sure it could be made faster by avoiding working with the selection object, but instead working with full qualified ranges
  26. Replies
    4
    Views
    282

    Re: New to Word Mail Merge

    not quite sure what you are asking, i would think, generally all fields are returned, just with the records by criteria
  27. Replies
    3
    Views
    327

    Re: Link in email to reply to

    the html would be like this for an html anchor

    <a href="mailto:test@example.com?subject=Testing out mailto!&body=This is only a test!">Second Example</a>you could possibly use a variable to fill...
  28. Replies
    3
    Views
    327

    Re: Link in email to reply to

    you would need to put a mailto href link into the body html of the email you send, while you can automate to fill the recipient, subject and body, it will still require the user to click send on the...
  29. MsOf13 Re: How do we remake the program to copy not one value value but with range in column

    do you want to post a workbook (zip first) with some sample data to test against
  30. Replies
    6
    Views
    378

    Re: Cannot Register vbzip11.dll

    did you elevate to register?
  31. MsOf13 Re: How do we remake the program to copy not one value value but with range in column

    use code tags when posting code

    specify which line contains the error or is highlighted, you still needed an initial value for d
    looks like missing a " before sheet1, typo do until, closing...
  32. MsOf13 Re: How do we remake the program to copy not one value value but with range in column

    this double loop looks terribly inefficient
    try like

    with src.sheets(sheet1")
    do unitl d = lastrow
    set fnd = range("a:a").find(.cells(d, 1)
    if not fnd is nothing then fnd.offset(,1)...
  33. MsOf13 Re: How do we remake the program to copy not one value value but with range in column

    i guess initial value of d = 0
  34. Re: mimic Windows 1.0 graphical interface with VB6

    you should try the vbdirectory parameter in the dir call
  35. Replies
    6
    Views
    634

    Re: excel 2000 question

    of course they can be hard coded, i assumed that you would want to match the value of some cell as
  36. Re: how do we fill in school table age column from age table using age column with vi

    well are you doing this in excel or access tables

    how is this related to your other post that asks the same question, but in excel
    in an access database you should not need to put the data in...
  37. Replies
    6
    Views
    634

    Re: excel 2000 question

    usedrange is a property of a sheet object and would work as posted would work, but you can always choose the range to search in, but as you did not give any clues about which column ( or if they...
  38. Replies
    1
    Views
    317

    MsOf365 Re: Can you find the problem with this?

    so each time any cell in column f is changed then you want to loop through all the cells in f7:f1000?
    you have not specified what problem you are having


    only a guess as to what the problem...
  39. Replies
    6
    Views
    634

    Re: excel 2000 question

    you can use excels find method, to find cell with matching text


    Set fnd = sht.UsedRange.Find(cel)
    if not fnd is nothing then fnd.interior.color = vbredwhere sht is a worksheet object and cel is...
  40. Re: fill a combobox with a sorted files in dir c:\,ydir\

    list the files into an array using DIR to return all the files from the directory, sort the array using quicksort or bubblsort (depending on your preference), then add all the files to the combobox...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width