Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 4.63 seconds.

  1. 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 =...
  2. 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...
  3. 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
  4. 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 =...
  5. 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,...
  6. Replies
    1
    Views
    120

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

    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
  8. 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...
  9. 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...
  10. 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...
  11. 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
  12. Replies
    8
    Views
    349

    MsOf10 Re: Circular Reference

    unless microsoft has broken something in later versions
  13. Replies
    8
    Views
    349

    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
  14. Replies
    8
    Views
    349

    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...
  15. 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...
  16. 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
  17. 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,...
  18. Replies
    4
    Views
    261

    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...
  19. Replies
    14
    Views
    410

    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
  20. Replies
    4
    Views
    261

    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
  21. Replies
    3
    Views
    309

    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...
  22. Replies
    3
    Views
    309

    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...
  23. 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
  24. Replies
    6
    Views
    366

    Re: Cannot Register vbzip11.dll

    did you elevate to register?
  25. 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...
  26. 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)...
  27. 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
  28. Re: mimic Windows 1.0 graphical interface with VB6

    you should try the vbdirectory parameter in the dir call
  29. Replies
    6
    Views
    621

    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
  30. 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...
  31. Replies
    6
    Views
    621

    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...
  32. Replies
    1
    Views
    305

    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...
  33. Replies
    6
    Views
    621

    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...
  34. 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...
  35. Re: Cannot debug 'Subscription out of range error'

    as r is returned as a fully qualified range you can not specify it on some sheet anyway
    unless the sheet is also entered in the inputbox, range r will always be on the active sheet when the inputbox...
  36. Re: Programatically Change Number Values In A String

    if that is the only string type then you could split the string on the "-" and add the +10 to both elements of the array, but if the strings could contain other characters you would need to loop...
  37. Replies
    9
    Views
    582

    Re: Move to line

    open again
    or read all into an array
  38. Replies
    5
    Views
    506

    Re: VBA Internet Explorer Click a button

    as it is internal, ask whoever designed it to provide an API, not much anyone external can do anything to help, can't see the html code of the page or test against the site
  39. Replies
    5
    Views
    506

    Re: VBA Internet Explorer Click a button

    if you want to pm me with a link to the actual site, include username and password, i will have a look and test
    other than that, if the button is on a form, have you tried tried to submit the form?...
  40. Replies
    5
    Views
    506

    Re: VBA Internet Explorer Click a button

    what code have you tried? and what results?
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width