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