• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by Anar

  1. A

    Automatic OK

    Thank you, shrivallabha I will try to use your option. fyi, I have found solution myself. I used appication.displayalerts= false to disable all message boxes.
  2. A

    Hi,

    Hi,
    • Anar
    • Profile post
  3. A

    Automatic OK

    Thanks, but I could not figure out how I can apply the case you shared to my case. Could you please be more concrete?
  4. A

    Automatic OK

    The case is not about Power Query at all, rather more about how to click on OK button automatically in Excel.
  5. A

    Automatic OK

    Actually, there is no code. I used Power Query to import data from web and and set refresh frequency to 5 minutes in Connection Properties. So Excel connects to web sites every 5 minutes and imports data. But, the process is not successful always - sometimes Excel cannot retrieve data and...
  6. A

    Automatic OK

    Could you please explain a bit more? I am not much good at VBA.
  7. A

    Automatic OK

    Hi, In Excel I created several tables over Power Query by connecting to web sites. I have set tales Refresh every 30 minutes. But sometimes the web sites do not respond and message box appears about it. Can I configure Excel to automatically click on OK button so that it disappears...
  8. A

    Excel selects updated tables instead of summary table

    Solution found by myself. See here: http://www.excelforum.com/showthread.php?t=1128735&p=4327294
  9. A

    Excel selects updated tables instead of summary table

    Hi, I have several tables create over Web query using Power Query. And I have summary table created over those tables. I want to refresh the tables so that my summary table shows the latest figures. When I update the tables Excel automatically selects last updated table. But I need Excel to...
  10. A

    Getting data from web with Power Query

    Thank you.
  11. A

    Getting data from web with Power Query

    Hi, Marc L I use Excel 2016 an it is not possible. Thank you for the link. I am reviewing it. Do you think it is possible to do with VBA?
  12. A

    Getting data from web with Power Query

    Thank you, David. Unfortunately it does not help. I want to select date range in web-page and then import to Excel. But I cannot to it. You may try yourself here http://www.investing.com/commodities/crude-oil-historical-data
  13. A

    Getting data from web with Power Query

    Thank you. I actually want to import over Power Query so that I can update and modify data easily.
  14. A

    Getting data from web with Power Query

    Dear Ashhu, how did you importd data to Excel? Over Power Query? or Copy/Paste?
  15. A

    Getting data from web with Power Query

    Hello, I need to get data from web (Crude Oil Historical Prices - Investing.com). But I want to get data not for the last month as seen over the web-page, but for the greater date range. There is option to select start and end date on web-site. However, when I select the range and run, I...
See more
Back
Top