automation vba

Hi Fox :) Case: I have a summary tab that has the same tables in all the models I have built and unified with the same tables as PPT, it requires me to fill in the result after any updates in the model inputs(which is daily). This is quite challenging if I work on 5 urgent projects solo. I...

Hi everyone, Basically, I have a list of names and reasons for people being on a list. Plus the date their names were added to the list. What I'm wanting is for the line with their info to be removed after 7 days when we open the spreadsheet. Referring to the image, lets take row 2-4. Their...

New to browser automation here. I am trying to open a webpage and browse a list of entries. The bot has to open the first one , execute some tasks ,once done proceed to the next entry until the end. Can someone with exp. give some hints. Thanks a ton. I get a "object doesnt support this method"...

Hi guys, I am relatively new to Excel so please excuse any errors or stupidity on my part. I have a dataset from which I need to filter out values. The data range is from Column A to Column AA. In columns V to AA I have some vlookups that are returning the value of #N/A. I need the VBA to work...

Hello All, Based upon resources found on the internet (various forums, websites, communities) I did able to create one excel solver macro which automates the solver calculations. Each solver calculation involves setting target cell to zero by changing variable cell. both are single cell...

Hi I am trying to automate a website through VBA , I am able to select or click items with id , but for one link id is not available , it contais href and class . Can someone please help me out . I have just started using VBA . After inspect item this is the html part : <DIV...

Hi, I am looking to make emails for each line in excel that reads Y email is needed. It would take the line and make a table to send to users. Anyone done this vba before? I am just finding selected ranges and big tables pasted to outlook. I would it to loop each line to create bulk emails.

I have entered Roll Nos in B2, B3, B4 and B5 (1706571, 1706572, 1706573, 1706574) and I want their percentages to be entered in column C2, C3, C4 and C5 respectively for which i have written a vba code. But this code is only showing value for cell B2 and not for rest data, moreover percentage...

Hi to everyone, I use to check this forum a lot as a quest, but now I need your help because I am 0 in macros. I have a task management file, where we assign task to a team consisting of 4 people, with specific deadlines. I want that when I will mark the status of a task as `done` and after...

Hi All, Can some one help in automating the notepad data replacement. I have data of 6 columns and 2 rows that consists of names and numbers count, and I have a date in my notepad along with same components that are in excel. I need to automate like when ever I had updated values in excel...

I made up this sports data so none of it is accurate or even remotely right but it is for the sake of the real data I am using. (Sorry it's a long explanation) http://i.stack.imgur.com/3ay85.png Overview: This is a picture of a scorecard I am working on that reports on various metrics related...

Hello, I hope people find this idea an interesting idea and easy to solve. Recently I came across the following code which has been very useful as a find and replace tool. Dim Rng1 As Range Dim InputRng1 As Range, ReplaceRng1 As Range xTitleId = "Parkway Data Cleanser" '(I changed these...

Hi, As first I need to say I'm very new to VBA. I have took upon myself to build an automation for IE for my departament which when done will go to the website and put reference number in and search for certain client info. I got stuck on very first hurdle and been researching internat for past...

Hi Guys, I hope and believe that you can help me here. I am Jain with excel vba programming and I am creating a break tracker program using excel with vba. My excel file contains the data for all employees. I have a Userform where the user will enter his employee ID which will pull up his data...

Apologies if I am not posting in the correct forum, please feel free to move if it needs to be. We are in the middle of collecting a pretty big set of data that we are about to summarise so we can then analyse, and would appreciate some help in either creating a Macro, or writing a little bit...

Hi everyone! I'm pretty new to excel programming, so I apologize for any awkwardness in wording my problem. Recently I'm trying to make a database of Bank Identification Number (BIN) from binlist.net using Web Query. It basically works like this : for example I want all the information for the...

Hi, I want to download a bunch of data from the following website:BM Unit Data I can only download a day at the time, and a unit at the time, so I don't want to do this by hand. I've written a sub that goes to the website and sets the attributes in Java. This works for everything but the...

Hello, I am looking for help in optimizing an Excel workbook I have. I am using Windows 7 64-bit SP1. Excel 2010. MS Access 2003. This workbook contains links through a shared drive to multiple other excel worksheets. It also contains data connections to Access 2003 select queries. I have VBA...