$$Excel-Macros$$ Macros for screenshot

Hi All, I have 10 files in my c drive. I have to capture other applications screenshot and paste in all 10 files. I am able to capture screenshot, but not able to paste in 10 excel file. Please suggest macro to paste screenshot in all files Regards, Suresh -- Are you =EXP(E:RT) or =NOT(EXP(E:

$$Excel-Macros$$ Re: Macros for screenshot

Experts any inputs for the below requirement? On 23-Mar-2017 1:43 pm, "suresh k" wrote: > Hi All, > > I have 10 files in my c drive. I have to capture other applications > screenshot and paste in all 10 files. > > I am able to capture screenshot, but not ab

$$Excel-Macros$$ NEED MACRO FOR CITRIX

Hi All, Anyone knows how to write macro to activate applications inside citric. Let me know if any useful links on same. Regards Suresh -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.f

Re: $$Excel-Macros$$ NEED MACRO FOR CITRIX

Any macro man in this group know how to write code to access the application inside citrix. On 12-Feb-2018 7:58 PM, "suresh k" wrote: > Hi All, > > Anyone knows how to write macro to activate applications inside citric. > > Let me know if any useful links on s

Fwd: $$Excel-Macros$$ Re: Marquee in Excel

Hi All, Anyone is there to provide solution for this query.. Is it possible to work on other worksheet while markquee is there in sheet1. /suresh -- Forwarded message -- From: suresh k Date: Wed, Sep 7, 2011 at 10:39 PM Subject: Re: $$Excel-Macros$$ Re: Marquee in Excel To

$$Excel-Macros$$ EXCEL TIP FOR THE WEEK

Hi All, To copy paste for all the cells. Lets say you have the data in A3 and you want to copy to C3:C4 cells.Using mouse to select all the cells is little bit difficult. Now you can do the same with below easy steps. 1. Select B3. 2. Then *Ctrl+C* to copy the data 3. Click once in

$$Excel-Macros$$ VLookup formula

Hi I have one query. I have data in two different sheets. Below are example for you. *Data in sheet 1:* Name Data Date No. Su 12 1/1/99 123 gu 22 2/2/99 124 gg 33 3/3/00125 *Data

$$Excel-Macros$$ Re: VLookup formula

at 6:41 PM, Daniel wrote: > Hi. > > Have a look at the attached file. > > Regards. > > Daniel > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *suresh k > *Sent:* jeudi 16 juillet 2009 09:58 > *To

$$Excel-Macros$$ MS Access

Hi All, Please let me know if anyone know about MS Access or provide me any link, where i can find help. Regards, Suresh --~--~-~--~~~---~--~~ -- Some important links for excel users:

$$Excel-Macros$$ NAMED Range

Hi All, I have selected A1 to A5 and given some name(In Named Range). Now I want to remove it. Anyone know how to do it??? Regards, Suresh --~--~-~--~~~---~--~~ -- Some important link

$$Excel-Macros$$ IF condition formula

Can anyone provide me the formula for below query. Report Date Total Logged Time at Work Hrs 7/2/2009 8.86 7/2/2009 9.03 7/2/2009 7.92 7/2/2009 9.02 7/3/2009 9.05 Answer should be 26.91. Excluding the value less than 8.00 hrs and it should calculate only for one day(7/2/2009). I have tried i

$$Excel-Macros$$ Advanced conditional formatting

Hi Guyz, Whenever we use conditional formatting it will be applied for current cell only. Is there anyway that if the condition is true the entire row should be colored??? Regards, Suresh --~--~-~--~~~---~--~~ -

$$Excel-Macros$$ Re: Advanced conditional formatting

h. > > Attached file has the scenario and the explanation for your query. Thanks > > -- > DILIP KUMAR PANDEY > MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > > On Thu, Aug 27, 2009 at 4:51 P

$$Excel-Macros$$ Macro for copying all data

Hi, Is there any macro for copying all the data from 20 different excel file to a single master file. Plz let me know. Thanks & Regards, Suresh --~--~-~--~~~---~--~~ -- Some important

$$Excel-Macros$$ Re: Count if i appreciate if do this ASAP

Hi Amresh, You can use CONCATENATE function for your query. Attached is the solution. On Thu, Sep 3, 2009 at 2:30 PM, amresh kumar wrote: > Hi My All Friends, > > Please find the attached file i want count working days absent date and > half day of employee > > Please let me know if any doubts.

$$Excel-Macros$$ Userform for 10 secs

Hi, I have created Userform which will open when the excel sheet opens, but how to keep it only for 10 secs. After 10 seconds it should close automatically. Any macro code for that?? --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Re: Userform for 10 secs

ode may help u > > *Sub um()* > *If Application.Wait(Now + TimeValue("0:00:10")) Then* > *MsgBox "Time expired" ' or write "Unload Me" here* > *End If* > *End Sub* > > > Thanks & Regards, > > Harmeet Singh > &

$$Excel-Macros$$ Re: Userform for 10 secs

& Regards, > > Harmeet Singh > > Sent via BlackBerry Wireless > > > On Mon, Sep 14, 2009 at 8:12 AM, suresh k wrote: > >> Hi Harmeet, >> >> Thanks for your reply. >> >> In this case, after running the userform. I need to click on that. And the >>

$$Excel-Macros$$ Hide and unhide option

Hi Excel masters, I have created a macro for maintaining attendance. In sheet 1 i have created a box, If i select Jan. It should go to 2nd sheet and should show only those columns and rows. And remaining all lines should be hided. But it is not working. Any suggestions,,, Many thanks Regar

Re: $$Excel-Macros$$ Hide and unhide option

Dear Excel masters, Anyone know this solution or not? On Tue, Dec 1, 2009 at 1:12 PM, suresh k wrote: > Hi Excel masters, > > I have created a macro for maintaining attendance. > > In sheet 1 i have created a box, If i select Jan. It should go to 2nd sheet > an

$$Excel-Macros$$ Formula required

Hi, I have the very large data to consolidate. To consolidate I need a formula. Below is the example. My Input data will be *Input* Hari Yes Hari No Hari Yes Hari No Hari No Girish Yes Girish No Girish Yes Girish Yes Girish Yes Girish No Girish No And output data s

Re: $$Excel-Macros$$ Formula required

Hi Sanjay, Pls find sample file and let me know if you could help me on this. On Fri, Feb 5, 2010 at 4:09 PM, Sanjoy Nath wrote: > Please give the file attached > I will make it for you. > > > > On Fri, Feb 5, 2010 at 3:32 PM, suresh k wrote: > >> Hi, >>

Re: $$Excel-Macros$$ Formula required

> Best Regards, > -- > DILIP KUMAR PANDEY >MBA-HR,B Com(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > > On 2/5/10, suresh k wrote: >> >> Hi Sanjay, >> >> Pls find sample file

$$Excel-Macros$$ Very tuff macro

Hi All, Any macro man can help me on this. I have attached the excel with my query. /Suresh -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceld

Re: $$Excel-Macros$$ Very tuff macro

rote: > what about 6 and 3 as a match for 9 > > > On Wed, Sep 28, 2011 at 9:01 PM, suresh k wrote: > >> Hi All, >> >> Any macro man can help me on this. >> >> I hav

Re: $$Excel-Macros$$ Very tuff macro

et(1) > Temp.Cut Destination:=Sheets("Sheet2").Range("E" & > Rows.Count).End(xlUp).Offset(1) > End If > End If > Next i > Columns("A"

$$Excel-Macros$$ Save excel with date

Hi, I am trying to save excel file using macro.. The file name should be my name followed by today's date. Is there any macro for this? /Suresh -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor threa

$$Excel-Macros$$ Re: How can i print a range of worksheets from workbooks in a directory

Hi Please remove me from this google groups. thnx On 11/12/08, Tom Jeffries <[EMAIL PROTECTED]> wrote: > I've attached a workbook containing two macros PrintWorkbooks and > Traversethat together do what you are describing. Invoke > PrintWorkBooks and provide the full starting path (e.g. C:\TES

$$Excel-Macros$$ Re: Excel File & VBA Password Remover Tool Required

Hope ayush Jain can help in this query. On Mon, Nov 24, 2008 at 11:32 AM, kamlesh jain <[EMAIL PROTECTED]> wrote: > Dear All, > > Can any body send me Tool / Software for Removing Password from Excel > & VBA. > It will be great help for me. > > Thanks in advance. > > -- > Regards, > Kamlesh Jain

$$Excel-Macros$$ "Next" error

Hi All, Can anyone check whether below codes are correct or not. I am getting error message while i run this code. Private Sub ok_Click() Dim a As Integer a = Val(text1.Text) If a = bp Then Application.ActiveSheet.Unprotect ActiveWorkbook.Unprotect UserForm1.Hide Next End If If a > 2 Then '

$$Excel-Macros$$ Re: "Next" error

> Regards > *Ashish **Jain* > Analyst, CSC Australia > Microsoft Certified Application (Excel) Specialist > Technical Trainer - Excel and VBA > Author -> www.excelitems.com > +91--40-48-43 > > -------

$$Excel-Macros$$ Error - "End If without block if"

Hi All, Can anyone help on this error. Below is the code. Private Sub ok_Click() Dim a As Integer a = Val(text1.Text) If a = bp Then For Each shts In ThisWorkbook.Worksheets shts.Unprotect ActiveWorkbook.Unprotect UserForm1.Hide End If If Not a Then ActiveWorkbook.Protect For Each shts In

$$Excel-Macros$$ Re: Error - "End If without block if"

TextBox1.Value > If A = 123 Then > For Each Shts In ThisWorkbook.Worksheets > Shts.Unprotect Password:=123 > Next > UserForm1.Hide > Else > For Each Shts In ThisWorkbook.Worksheets > Shts.Protect Password:=123 > Next > UserForm1.Hide > End If > End Sub > >

$$Excel-Macros$$ Protect and unprotect all sheets

Hi All, Can anyone provide the vba code to protect and unprotect all sheets in excel. Thanks & regards, Suresh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Exce

$$Excel-Macros$$ Sum query

Hi All, I have attached my query regarding sum function query I know this can be solved through pivot table, but I want the result in formulaes. Pls let me know if anyone can solve this? /Suresh -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) !

$$Excel-Macros$$ Access other applications using macro's

Dear Experts, Can anyone help on my query. I have to activate and other applications like Internet explorer, SAP etc.., through writing macro. Is this possible? /Suresh -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook p

Re: $$Excel-Macros$$ Access other applications using macro's

net Explorer\iexplore.exe"*, > vbNormalFocus 'path of exe file of IE, u can use same for SAP (put exe > filepath) > > End Sub > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *suresh k > *Sent:* Tuesda

Re: $$Excel-Macros$$ Access other applications using macro's

e the document number one by one in a website instead of SAP. On Tue, Feb 4, 2014 at 11:13 AM, Ravinder wrote: > Please advise what u want exactly > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *suresh k > *Sent:* Tuesday,

Re: $$Excel-Macros$$ Access other applications using macro's

*From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *suresh k > *Sent:* Tuesday, February 04, 2014 11:29 AM > > *To:* Excel group > *Subject:* Re: $$Excel-Macros$$ Access other applications using macro's > > > > Hi, > > I need macro

Re: $$Excel-Macros$$ Access other applications using macro's

Hi Ravinder, Any update on the error. On Tue, Feb 4, 2014 at 11:25 PM, suresh k wrote: > I tried, same keys in sap also. > > In my case(macro) i have to navigate couple of times within sap and excel. > But using this macro, once the cursor moves to excel, again it is not >

$$Excel-Macros$$ Study material for LOOPS

Dear Experts, Anyone having study material for learning all kinds of LOOPS. Please do forward. Many thanks. /Suresh -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discusse