$$Excel-Macros$$ help regarding send keys

hi i am trying to select the all the data of page and paste into excel Sub ABC() Dim IE Dim objShell Set IE = CreateObject("InternetExplorer.Application") Set objShell = CreateObject("WScript.Shell") With IE .Left = 20 .Top = 20 .Height = 540 .Width = 9

Re: $$Excel-Macros$$ Data mapping from one excel workbook to another excel workbook

Hi Ramesh, I think it would be good idea to attach a sample file, Harry On Apr 22, 7:39 pm, Ramesh Katta wrote: > Hi Friends, > > I need to map data from one excel workbook to another excel workbook. > I need to open the source workbook then need to create new workbook > and some cells of data

$$Excel-Macros$$ Help with Autofill Increment

Hi. I am trying to find a formula to calculate the average of the first 20 values in a column, then the average of the 20 20 values and then the average of the third 20 values etc. I tried to do this by simply summing the first 20 values and dividing them by 20: sum(B2:B21)/20. This works for the

$$Excel-Macros$$ Help

HI I need a macro to upload excel files on website automatically. I checked below link http://www.motobit.com/tips/detpg_uploadvbaie/ but it doesn't actually works. -- -- Some important links for excel users: 1.

$$Excel-Macros$$ Need help to complete a Excel Model..

Hello Friends, I build a model for Excel Test, Its having 3 sheets. sheet1-- Instructions sheet2-- Test Question sheet3--- Data for the Test question. Once if a candidate click on the Hyper link (which is in sheet1 - this will take to test question sheet i.e., sheet2), It should start tim

$$Excel-Macros$$ Data mapping from one excel workbook to another excel workbook

Hi Friends, I need to map data from one excel workbook to another excel workbook. I need to open the source workbook then need to create new workbook and some cells of data needs to be maped from source workbook to newly created workbook. Source workbook has one sheet (Source) newly created work

$$Excel-Macros$$ Need Macro code for the below issue

Hello Friends, I need a Macro code which should do the below function in the opened workbook. Please help me out: # Go to each sheet and convert as PDF file and save the same in the same path. PDF file should be named as "B1" cell content in the worksheet. # The above function shuld do it al

Re: $$Excel-Macros$$ Help with Conditionally Formatting

If the cells under consideration can hold only two values, "YES" or "NO", then may be you can use Data validation and allow only those two values. In error message, you can type whatever you want to display. regards, Harsh On Thu, Apr 22, 2010 at 5:29 AM, Amol Pradhan wrote: > Hi, > > I need h

Re: $$Excel-Macros$$ Consolidating Unequal Lists

Hello Dear, Are you looking for dependent list,or you want shorting of data. Have a look on attached sheet,I hope it will fulfill your requirement. Hope it Will Help Happy To Help :) Prashant Tripathi On Wed, Apr 21, 2010 at 4:52 PM, royhamill wrote: > Hello, > I have 2 lists of dat

Re: $$Excel-Macros$$ MCA certification help

Dear Alok Following is the link For Ms Excel Master Certification. http://www.microsoft.com/learning/en/us/exam.aspx?ID=77-602&locale=en-us Hope it Will Help Happy to Help :) Prashant Tripathi On Thu, Apr 22, 2010 at 10:53 AM, rf1234 rf1234 wrote: > Dear alok > In my knowledge Micros