+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 28 of 28

Extracting DATA

  1. #16
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 2016 365 Subscription (Win 10 - Home)
    Posts
    15,999

    Re: Extracting DATA

    Have you asked this same question on another forum?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  2. #17
    Registered User
    Join Date
    10-11-2014
    Location
    Noitacol, Acirema
    MS-Off Ver
    2016
    Posts
    43

    Re: Extracting DATA

    Quote Originally Posted by Luigi802 View Post
    OH, I see, I'm new to this Power query, I just found out about it a few minutes ago on another forum, thanks I'll give it a try!
    OK, so it won't let me import the receipt cause when I use PQ to bring up the page it only brings up the login page

  3. #18
    Registered User
    Join Date
    10-11-2014
    Location
    Noitacol, Acirema
    MS-Off Ver
    2016
    Posts
    43

    Re: Extracting DATA

    Quote Originally Posted by AliGW View Post
    Have you asked this same question on another forum?
    Yes, I usually post to more than 1 forum

  4. #19
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 2016 365 Subscription (Win 10 - Home)
    Posts
    15,999

    Re: Extracting DATA

    Do you really? Oh dear ...

    Rule 08: Cross-posting Without Links

    Your post does not comply with Rule 8 of our Forum RULES. Do not cross-post your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

    No further help to be offered, please, until the OP has complied with this request.

  5. #20
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    not-us
    MS-Off Ver
    PC: 5F / 61 / 7E0 (PQ/PP)
    Posts
    7,308

    Re: Extracting DATA

    Quote Originally Posted by Luigi802 View Post
    OK, so it won't let me import the receipt cause when I use PQ to bring up the page it only brings up the login page
    so log in and go to the page with your receipts

    did you try the first point?

    and, what is important, did you read information from the link from post #13 ?

    or read here:

    How to run Web Query

    Pull data into MS Excel with Web Queries
    Last edited by sandy666; 01-03-2018 at 01:25 PM.
    sandy (NO CAPS)
    Excel can do everything but still doesn't read user's wishful thinking
    The ready made solution will not teach anyone anything

    A logical description of the problem is the basis of dialogue and a rapid solution. Nobody sits in your head to understand your way of thinking
    Note: English is not my native language
    Keep It Sophisticatedly Simple

  6. #21
    Registered User
    Join Date
    10-11-2014
    Location
    Noitacol, Acirema
    MS-Off Ver
    2016
    Posts
    43

    Re: Extracting DATA

    Quote Originally Posted by AliGW View Post
    Still waiting for you to post the link.
    https://chandoo.org/forum/threads/ex...ng-data.36853/

  7. #22
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 2016 365 Subscription (Win 10 - Home)
    Posts
    15,999

    Re: Extracting DATA

    Thank you.

  8. #23
    Registered User
    Join Date
    10-11-2014
    Location
    Noitacol, Acirema
    MS-Off Ver
    2016
    Posts
    43

    Re: Extracting DATA

    You're welcome, sorry about that

  9. #24
    Registered User
    Join Date
    10-11-2014
    Location
    Noitacol, Acirema
    MS-Off Ver
    2016
    Posts
    43

    Re: Extracting DATA

    Quote Originally Posted by sandy666 View Post
    so log in and go to the page with your receipts

    did you try the first point?

    and, what is important, did you read information from the link from post #13 ?

    or read here:

    How to run Web Query

    Pull data into MS Excel with Web Queries
    Yes, I read post#13, and I did it from the page with my receipt, but it still gave me the login page, IDK I have a few ideas I could try

  10. #25
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    not-us
    MS-Off Ver
    PC: 5F / 61 / 7E0 (PQ/PP)
    Posts
    7,308

    Re: Extracting DATA

    Web Query is different than PowerQuery
    did you try Web Query? (full answer please, because " I read post#13 " - is not answer you read info from link)

  11. #26
    Registered User
    Join Date
    10-11-2014
    Location
    Noitacol, Acirema
    MS-Off Ver
    2016
    Posts
    43

    Re: Extracting DATA

    Quote Originally Posted by sandy666 View Post
    Web Query is different than PowerQuery
    did you try Web Query? (full answer please, because " I read post#13 " - is not answer you read info from link)
    The 1st way, by clicking From Web on the Get External Data tab does paste the website in the sheet but it's no more usable then if I manually copy/pasted it myself. And the second way, once I get to this point, Capture.JPG I can't do anything else to log into the page it says "In the Access Web dialog box, click a credentials option, and provide authentication values." I can't find the "Access Web" dialog box. Plus I can't just click where it says username and password because it won't let me

  12. #27
    Registered User
    Join Date
    10-11-2014
    Location
    Noitacol, Acirema
    MS-Off Ver
    2016
    Posts
    43

    Re: Extracting DATA

    OK, I now just have to figure out how to sort and filter into these query tables, thanks a lot, you've been a lot of help, but at this point I think I'll just be buggin you lol.

  13. #28
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    not-us
    MS-Off Ver
    PC: 5F / 61 / 7E0 (PQ/PP)
    Posts
    7,308

    Re: Extracting DATA

    I can't help you more than I did without result of query so try to read more about way you chooseed

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1