automation

I have set my workbook to retrieve data from a website which gives prices of stocks. It refreshes hourly. I then have some cells that make calculations based on the stock prices using a simple formula. I am trying to make it so that every time the data refreshes, it recalculates based on the...

Hi, I am trying to copy information to another tab based on a criteria, and save as PDF. I know how to copy different cells from one tab and paste in different cells in another tab, but this time I need to copy values only if there is no 'Yes' in the column D (starting at row 2). Once the...

I have this code which was working fine last week but today is giving me the following error Run-time error -2147217376 (80041020) Automation Error Anybody know why or how to overcome it, the code is just importing an XML file into excel Application.CutCopyMode = False...

Alright folks, I'm trying to set up a file that pulls up a company Intranet via IE, fills in a few fields and then hits "go" to populate a list. It's triggering an "automation" runtime reror because of the Set doc = IE.document line (Line 7) and I suspect is has something to do with...

I have the following line of code that is causing the "Automation Error Exception Occurred" error. Works fine in other versions of Office.I tried to record a macro to see how Office 2016 handles clearing a sort, but using that code just caused errors. Any help would be appreciated...

Good Morning, I’m hoping that some kind soul out there can help me with a roadblock I’ve encountered in my quest to manipulate a website with VBA. I am using MS Excel 2010 and Internet Explorer 11.0.56. I’m somewhat comfortable with VBA but have never used it to navigate to a website, enter...

Hi I would like to seek some advice on how I can do the following. I have a macro(I use a do while loop to check and insert the extra row) that sorts out data in a certain format by inserting a line(row) in between 2 rows effectively separating the data set. After running my macro, I am...

Hi All, Does anyone know when this type error "Internal OLE automation error" comes while running MS query? I can run other query without any issue. Any help would be appreciated. Regards, Mukesh

I never knew this was possible, but i came across a dashboard where input is magically simplified because other tables when refreshed, "fetch" specific data wich was inserted on the main table. It's not formulas or anything, lemme tell how it works so someone can explain me how to reproduce it...

Hello, I would like to integrate Outlook and Excel. I have a workbook that I use to keep track of clients and prospects. It keeps track of where they are in the sales process. When they get to a point that they want to have a meeting, I have to manually mark the day in Outlook to make a...

Hi! Thank you for your replies. Is it possible to programmatically zip ALL the folders in a directory into INDIVIDUAL zipped folders in that SAME directory? For example, say I had the following directory: C:\Users\john\target and there were FILES and FOLDERS in that directory and I only wanted...

Hi guys i've set a macro up to take me to a webpage. ... now i want to select all and paste all information into "sheet1" cell a1 on my excel document and then copy and paste the data as vales into another tab (don't know the cell ranges yet depends on how the data is important. however on the...

Hi All I frequently use the RDBMerge add-in, from Ron de Bruin. I've been using it for years with no problems. However since changing to Windows 10 I've been getting frequent Automation Errors & it just crashes mid-merge. Does anyone have any suggestions on how to fix? Many thanks Bill

Hi, Help! Please. How can i insert .cls once i opened my excel file. I need the automation of the excel once it's opened. Thanks, Zaldy

Hi Excel members, Understand the concept of a vlookup and how i can search within another sheet or document however i'd like to automate this. This could be easily done however the files are different each week. I'm sure i can name the files to be the same but need help with the code behind it...

Has anyone ever used one of the options in the automation add-ins? Just wondering why they might be useful, is there anything useful in there or is it just another Excel white elephant

I'm performing a Date calculation on a table column. Any ideas why this is causing an Automation error? =IF([@DATE]>NOW(),"X","") When I stop the debugger and allow the worksheet to re-calculate the formula, everything works as should... Saving the worksheet without this calculation...

For example, I'm on yelp and search for 'burgers' in 'maine' I have a for loop to scrape each of the 10 results and then click the link to get the next 10, until page 5 (so 50 results in total) I run into a problem at number 11 (where page 2) would start. I think a the source of the...