Search:

Type: Posts; User: Leith Ross; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.08 seconds.

  1. Replies
    11
    Views
    862

    Re: VBA - PublishObjects HTML Script

    Hello BradH,

    The problem is with PublishObjects. This is a collection object that is saved when the workbook is saved and closed. As you pointed it, it keeps growing. Here is macro that will...
  2. Re: VBA count number of emails in Outlook folder/subfolders, rumtime error 5

    Hello lyric025,

    Did you load the Scripting Runtime Library in your VBA References?
  3. Re: VBA count number of emails in Outlook folder/subfolders, rumtime error 5

    Hello lyric025,

    You have set your object variable olItem to the Items collection object. You will need to use an index to return a single item from the collection. You can not display the full...
  4. Replies
    5
    Views
    105

    Re: email area using Yahoo

    Hello rfletcher35,

    The wrong port number can result in transport failed to connect. The SMTP port number for Yahoo is 465.
  5. Replies
    5
    Views
    105

    Re: email area using Yahoo

    Hello rfletcher35,

    While it is easy to copy a range as a picture to the clipboard, it becomes difficult to incorporate it into multiple emails. It would be easier to copy the Range into the HTML...
  6. Replies
    5
    Views
    121

    Re: Searching an array for a match

    Hello roscoe,

    Unless you need to automate this process, the simplest approach would to filter the list and do a copy and paste to a different sheet.
  7. Re: find value and eneter date in a different cell

    Hello JamRivera,

    Can you post a screen shot of a worksheet with the multiple FDA listings? Thanks.
  8. Re: VBA to fill array with delimited data from text file

    Hello Wetbury,

    Okay, that was my fault. For some reason I thought you wanted the data transposed on the worksheet. I changed the macro so the output is line by line.

    My apologies Rick for...
  9. Re: VBA to fill array with delimited data from text file

    Hello Geoff,

    I sent my email address to you by Private Message.
  10. Re: VBA to fill array with delimited data from text file

    Hello Geoff,

    Since all my test files were transposed correctly, including the one I created from your posted data, something has changed. Can your post your text file on a file sharing site or...
  11. Re: VBA Vlookup reference to number more than 10 digits

    Hello NDMDRB,

    If I could see the complete file that would be best.
  12. Re: VBA to fill array with delimited data from text file

    Hello Westbury,

    The new array must be sized to hold the transposed data. In this macro, the data is read in as a byte array. This allows for fast checking of end of line characters and delimiters....
  13. Re: VBA Vlookup reference to number more than 10 digits

    Hello NDMDRB,

    I can help you better if you could either send me a copy of the workbook or post it to a file sharing site where I can download it. Would either option be possible?
  14. Re: find value and eneter date in a different cell

    Hello JamRivera,

    I just back from doing some invoicing. I am not with it today. The compile error was due to trying to assign a object to a long integer. The line correction is below.


    ...
  15. Re: find value and eneter date in a different cell

    Hello JamRivera,

    Sorry, here is the corrected code...


    Sub FDADATE2()


    Dim Cell As Range
    Dim LastRow As Long
  16. Replies
    6
    Views
    134

    Re: Simplifying this Macro Help

    Hello nymyth,

    The result of a formula calculation does not trigger a Worksheet_Change event. However, a Data Validation list that uses cell values or has values hard coded into it, will trigger a...
  17. Replies
    6
    Views
    134

    Re: Simplifying this Macro Help

    Hello nymyth,

    Can you give me an example of the drop down reference?
  18. Re: find value and eneter date in a different cell

    Hello JamRivera,

    Here is the macro without using a For Next loop.



    Sub FDADATE2()


    Dim Cell As Range
  19. Re: find value and eneter date in a different cell

    Hello JamRivera,

    You realize that if you offset 2 columns to the right of "A" you will overwrite what is column "C". Is that correct?
  20. Replies
    6
    Views
    134

    Re: Simplifying this Macro Help

    Hello nymyth,



    Private Sub Worksheet_Change(ByVal Target As Range)


    Dim col As Variant

    If Target.Cells.Count > 1 Then Exit Sub
  21. Re: VBA Vlookup reference to number more than 10 digits

    Hello NDMDRB,

    First do not use the Change Event for this. The reason is you want to validate the entire barcode after it has been entered. The Change event happens every time a key is pressed.
    ...
  22. Replies
    4
    Views
    111

    Re: Macro for opening a pdf

    Hello bamaisgreat,

    Change the folder and file names in the macro below to what you will be using.

    Copy the code and paste it into a new VBA Module in your Workbook.



    Private Declare...
  23. Re: Search in TXT file and return line to Excel

    Hello jphumani,

    I downloaded both of your files. This is the code I used for the UserForm and it worked.



    Function buscar()


    Dim Archivo As String
  24. Re: Search in TXT file and return line to Excel

    Hello jphumani,

    This problem is like the riddle "How do you eat an Elephant?". The answer: A piece at a time. The preferred method of handling large files is to do it in pieces or "chunks". A file...
  25. Replies
    10
    Views
    2,368

    Re: arrays count unique items?

    Hello zrx1200,

    Using the percent symbol after a number declares it as an Integer Type (signed 16 bit). It is the same as Dim i As Integer.

    Here is a list of Type Declaration Characters used in...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4