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
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
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
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:
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
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
>
*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
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,
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
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
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) !
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
et(1)
> Temp.Cut Destination:=Sheets("Sheet2").Range("E" &
> Rows.Count).End(xlUp).Offset(1)
> End If
> End If
> Next i
> Columns("A"
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
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
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
> 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
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,
>>
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
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
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
& 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
>>
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
>
&
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??
--~--~-~--~~~---~--~~
---
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.
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
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
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
--~--~-~--~~~---~--~~
-
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
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
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:
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
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
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
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
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
>
>
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
> Regards
> *Ashish **Jain*
> Analyst, CSC Australia
> Microsoft Certified Application (Excel) Specialist
> Technical Trainer - Excel and VBA
> Author -> www.excelitems.com
> +91--40-48-43
>
> -------
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
'
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
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
41 matches
Mail list logo