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" <brave.sur...@gmail.com> wrote: > Hi All, > > Anyone knows how to write macro to activate applications inside citric. > > Let me k

$$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 @

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

Experts any inputs for the below requirement? On 23-Mar-2017 1:43 pm, "suresh k" <brave.sur...@gmail.com> 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

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

$$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 @

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 brave.sur...@gmail.com 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

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

-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 for the following cases. Case 1: I have

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

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

*, 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:* Tuesday, February 04, 2014 10:56 AM *To:* Excel group *Subject:* $$Excel-Macros$$ Access other

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

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

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

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

, Sep 28, 2011 at 9:01 PM, suresh k brave.sur...@gmail.com wrote: 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

$$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 :

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

...@gmail.comwrote: what about 6 and 3 as a match for 9 On Wed, Sep 28, 2011 at 9:01 PM, suresh k brave.sur...@gmail.com wrote: Hi All, Any macro man can help me on this. I have attached the excel with my query. /Suresh

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 brave.sur...@gmail.com Date: Wed, Sep 7, 2011 at 10:39 PM Subject: Re: $$Excel-Macros$$ Re

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

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 sanjoy.nath...@gmail.comwrote: Please give the file attached I will make it for you. On Fri, Feb 5, 2010 at 3:32 PM, suresh k brave.sur...@gmail.com wrote: Hi, I

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 brave.sur...@gmail.com 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

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

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

...@gmail.comwrote: Below code 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 Sent via BlackBerry Wireless On Fri, Sep 11, 2009 at 10:23 AM, suresh k

$$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 brave.sur...@gmail.com wrote: Hi Harmeet, Thanks for your reply. In this case, after running the userform. I need to click on that. And the time will count from that time. So If I dont

$$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$$ 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 amreshkushw...@gmail.comwrote: Hi My All Friends, Please find the attached file i want count working days absent date and half day of employee Please let me

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

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 PM, suresh k brave.sur...@gmail.com wrote: Hi Guyz, Whenever we

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

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

$$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 dcolarde...@free.fr 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 group *Subject:* $$Excel-Macros

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

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