automation

The idea is to have a topic selection page where i can select yes or no and then based on my answers the next sheet will show all of the topics that i answers yes to. Images can be seen here: https://ibb.co/YfKK6pG AND https://ibb.co/1GpyjmJ Looking it this it maybe could be something where...

I have a product listing that contains a number of items that are of the same type. Each product has a photo associated with it that I would like listed in columns rather than in rows. I know I can transpose the values manually, but I'm looking for a way to automate the whole listing sorting by...

Hello, I'm trying to automatically set the current year and next year in a pivot table using VBA. This is what I have currently Dim CurrentYear as Variant Dim NextYear as Variant CurrentYear = Year(Now()) NextYear = Year (Now())+1 With ActiveSheet.PivotTables("PivotTable1").PivotFields("YR")...

Good morning everyone! I know the text is long but please don't leave just yet. Please keep with me and be patient, I'm a newbie, on the community and on excel! I have this project that I could really use some inputs on how to achieve it (logic, algorithm and code-wise). I have two Excel files...

https://photos.app.goo.gl/JiRjueNTERUmu2ev6 I'm trying to auto populate the area in yellow in the screen shot (see link) with the tasks. Each week a person does a task, the next week they move on to a different task. They never repeat the same task in a 4 week period. Its always a 4 week...

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