automation vba

  1. J

    Remove cell contents based on date - VBA

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

    Selenium VBA click on item in a table (do other stuff) and proceed to next item in the table,do until empty

    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"...
  3. T

    VBA to filter and extract data

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

    copy previous value of variable cell to another cell location in same spreadsheet

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

    VBA - Web Automation Internet Explorer href issue

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

    VBA Tables To Outlook

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

    data not imported in excel

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

    Move Row with a specific text in a cell to different worksheet.

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

    Automation script for replacing data in notepad that exists in excel

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

    Making scorecard with data pulled from flat files more dynamic in excel-VBA

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

    Using a loop function to copy and paste a list of named ranges

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

    IE Automation VBA - method 'document' of object 'iwebbrowser2' failed

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

    Employee Break Tracker Program Using Excel Vba - Excel

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

    Macro, VBA code, PowerPivot help required to automate creation of summary sheets for large dataset

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

    Change Dynamic Web Query Parameter/ Web Query Automation

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

    Error when trying to set attribute of a Java element - date

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

    Excel External Links & Access Connection

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top