excel automation

I have a worksheet that gets over 80,000 rows daily, must of it needs to be filtered and ends with around 100 to 300 rows only. Sorting the unwanted values and deleting rows manually is a pain and it takes me from 2 to 3 hours so I started doing with VBA using a code I found on this forum which...

I have tried to use the following script from an old message on this board in Office 365 to open a new worksheet and name it with the current date. This code only opens a new sheet with the name "Sheetx" (x is increasing numbers). I would also like to be able to open the new sheet from a...

Hi I need a vba code which could compare 2 worksheets which has data in different sort order The data tables have no primary key and I need help in identifying how this can be compared to identify differences by reducing manual effort Once the data is compared between 2 worksheets, the code...

Hi I am trying to create a userform in a MASTER workbook where I want help in listing all Open workbooks including CSV files listed in a Userform combo box. This combobox should include all open workbooks including the ones which are not saved in the local drive. The master WB should be...

Hi Mate, I have 10 individual excel sheets with data & I need all the 10 different sheets data into one excel sheet and need to trigger the mail

We at work have quite unique problem. We have 12 word docs out of which few ( basis requirements)need to be printed for every job. Can anyone help to create excel sheet / or guide so that those word documents can be printed from excel itself and each having unique sequential number and date...

Hi all, I have multiple workbooks that are created weekly which needs to be sent out to the corresponding parties. This is very time consuming and sometimes workbooks are missed in the process. There are about 100 workbooks. The workbook contains the name of the supplier and then a date is...

Hey,I have a sheet of Engineers Name with allocated complaint numbers and their mobile number. i want to create a Macros script so that every time i apply filter on a particular engineer and press a Macros Created Keyboard short cut it copies engineer mobile number. Engineer Mobile Number...

Hi All, Need vba code to convert 'Mod' sheet from text to column in 'Row Data' sheet by click of 'Text to Column' button. The data selected in 'Mod' sheet should be converted to column done manually by clicking 'Text to Column' -> 'Delimited' -> 'Space' Sheet attached...

Hi, I wonder if there are any Excel automation Experts who can help explain and solve the following: we've been using Excel 2010 on a workstation and a Server ok. It's being run under some superuser domain account. (\\mydomain\mylovelySyperUser) DCom Security and Launching User Tab is also...

Guys i have cross-posted in other forums, please go through the links to find replies to my posts - http://www.excelforum.com/excel-prog...ml#post3617163 http://www.excelguru.ca/forums/showthread.php?2769-Validation-for-data-mismatch&p=11910#post11910 Hi All, I used to copy row data from...

Hi All, Greetings.! I have excel sheet with 1 Lakh data. I need to form delete queries by using 2 columns. For example, <tbody> Column1 Column2 100 A 200 B1 100 A2 300 C1 200 B2 300 C2 </tbody> Sample Query I formed manually is, delete from table1 where...