Search results

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.

Hi,

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

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

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...

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

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...

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

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...

Thank you.

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?

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

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

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

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...

Hi, Thank you for the advice.

Hi, Somendra Misra I know about the reply and I am not satisfied with it. If I were satisfied I would put comments on both forums stating that I got what I need. I think there was no need to share the link here. Anar

Hi, Let me explain the case in a different way - there is an Excel file for tracking of daily activities and users want to review it in the morning, at work before doing everything else. Sometimes people forget to open and review it. So to open this Excel file automatically and every day it...

Thank you, I know how to find and files to Windows startup folder. But, not everyone knows how to do it, so I want to automate it via VBA so that a user within Excel file saves the copy of the file to Windows startup folder.

Hello, I need help with VBA code to put file to Windows Startup folder so that the file is open-ed automatically on every Windows start up. Thank you, Anar

Hello, I want to add/remove Pivot Table Value Field item with a macro. Want to then assign the code to a button and when clicking the button the addition and removal should alternate. Please Help.

xld, as I said, sometimes it does, sometimes it does not. I would say that in most of the cases it does not retrieve data and returns #N/A error.

I know that SP reads from closed workbook. I have just tested it again with my files. It is strange that sometimes it works, sometimes it does not. I think there is a limitation issue here, since Excel has limitations for data retrieved from closed files.

Here is the formula while source file is closed: =(SUMPRODUCT(--('Link to source file[Source file name.xls]Source file sheet'!$I$3:$I$100=$A4),--('Link to source file[Source file name.xls]Source file sheet'!$C$3:$C$100=C$2),('Link to source file[Source file name.xls]Source file...

Hello, I have a problem with SUMPRODUCT formula. I have searched internet, including this website for help, but could not find anything. I have a file (destination file) where I put Sumproduct formula from another files (source files). Formulas work in sheet1 in destination file, but not in...