Search:

Type: Posts; User: AngelJ; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Can't unselect the "First Row Contains Column Headings" option when i try to append my tables

    I don't have 2003 installed, so I can't test to be sure we're talking about the same exact thing. But if that's true, then I'm confused too. :confused:
  2. Replies
    29
    Views
    3,707

    Re: Best way to web scrape using excel as database

    Yes, the Navigate method follows the links. This code uses a For Each loop to iterate through the links. Look into VBA loops for a better understanding of that.


    The pattern for this gets much...
  3. Re: Macro to automatically convert prt scr image-based text to real text in cell

    Subscribing because I've always wondered about OCR in VBA but never got around to trying it. This seems like a good place to start: Microsoft Office Document Imaging Object Model
  4. Replies
    9
    Views
    526

    Re: Query Between Unrelated Tables

    I always assume end users won't follow directions, and that they'll do everything they can to break the applications I develop for them. :stickouttounge:
  5. Replies
    29
    Views
    3,707

    Re: Best way to web scrape using excel as database

    Nope, sorry. I actually thought the code might scare you into doing this manually until you learned VBA, which wouldn't be such a bad idea as this is not a great project to start VBA on. But, I'll...
  6. Replies
    29
    Views
    3,707

    Re: Best way to web scrape using excel as database

    That's correct. There is no output besides those message boxes. The purpose of that sample was to show you how to navigate through the pages and retrieve information from them. The rest is up to...
  7. Replies
    29
    Views
    3,707

    Re: Best way to web scrape using excel as database

    lol, yup, you have to do the same thing for the other two libraries: Microsoft HTML Object Library, and Microsoft VBScript Regular Expressions #. Just choose the regular expressions one with the...
  8. Replies
    29
    Views
    3,707

    Re: Best way to web scrape using excel as database

    Follow these instructions from my earlier post to set a reference to each of the libraries listed at the top of the code:
  9. Replies
    29
    Views
    3,707

    Re: Best way to web scrape using excel as database

    There's no easy way to do this that I'm aware of. I think you might have just underestimated what's involved. This isn't the best project to start learning VBA, but here's a sample that may get you...
  10. Replies
    29
    Views
    3,707

    Re: Best way to web scrape using excel as database

    I wasn't working on this, but it sounded like Norie might have been.

    If you can post the work you've done so far and the troubles you've been having, then I'd be happy to help.
  11. Replies
    29
    Views
    3,707

    Re: Best way to web scrape using excel as database

    Sorry if my post didn't seem very helpful, but I had to make assumptions about your level of VBA experience. I'm sure there are several people on these forums who can help you.


    Here is a sample...
  12. Replies
    29
    Views
    3,707

    Re: Best way to web scrape using excel as database

    If you know HTML and VBA, one way to do it is with the Microsoft Internet Controls library. I'm sure you can find some samples by googling 'screen scraping with vba' or something like that.

    I've...
  13. Re: Query For Sorting and group by based on 2 columns

    Great, just making sure. :biggrin:
  14. Re: Query For Sorting and group by based on 2 columns

    To add to my previous post, I know you said the ID won't change back in the same month. But the query will handle it the same even if it changes back to A3 in March, or even later, which is why I ask.
  15. Replies
    6
    Views
    282

    Re: Data Import Advice

    Glad that worked for you! First name, last name, and birth date sounds good, but yeah, anything other than a social security number is going to have the possibility of getting it wrong.
  16. Re: Query For Sorting and group by based on 2 columns

    You're welcome! I'm glad that worked for you. Just to be clear, that query first sorts by the earliest date that occurs per ID, then by date, which is how I understood your request. So if two...
  17. Replies
    6
    Views
    282

    Re: Data Import Advice

    I think doing it with queries should be good. But, rather than thinking of it as a single operation that does one thing in the new client case, and another thing in the existing client case, I would...
  18. Replies
    6
    Views
    282

    Re: Data Import Advice

    Are you doing this in VBA or with queries?
  19. Replies
    1
    Views
    348

    Re: Highlighting Rows in Excel from Access VBA

    What do you need help with exactly? I'm assuming you have VBA experience in working with Access and Excel. If you're just having trouble automating Excel from Access, then does this help?


    Sub...
  20. Re: Adding an Attachment Error '3251' Operation is not Supported for this Data Type of Object.

    In that case I'd say you're doing quite well! :biggrin:

    Anyway, for now it looks like you're all set with the LoadFromFile method. But, if you want to switch to storing the files off the database...
  21. Re: Query For Sorting and group by based on 2 columns

    Ah, I think I see now what I was missing.

    In that case, does this work Abi?


    SELECT Table1.*
    FROM Table1
    INNER JOIN
    (SELECT ID,
    MIN(Table1.[Date]) As [Date]
  22. Re: Adding an Attachment Error '3251' Operation is not Supported for this Data Type of Object.

    No problem, it happens. It's an easy one to miss because of how VBA requires parentheses sometimes and requires that they're removed other times. It stands out to me because I work in other...
  23. Re: Query For Sorting and group by based on 2 columns

    I must be missing what Joe4 is talking about. Based on post #3, this simple query returns the results posted.


    SELECT * FROM Table1 ORDER BY ID, Date
  24. Re: Adding an Attachment Error '3251' Operation is not Supported for this Data Type of Object.

    On the line of code that gives you the error you are treating LoadFromFile as a property instead of a method. Does removing that equal sign fix the problem?
  25. Replies
    11
    Views
    1,459

    Re: VBA loggin into a website

    Also, have you tried navigating to that site manually to make sure everything's working there?
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4