Yes they are static
On Thursday, July 17, 2014 3:21:37 PM UTC+5:30, Vabz wrote:
Is header in Raw data static?
On Wed, Jul 16, 2014 at 5:22 PM, Prakash Gusain gusain...@gmail.com
javascript: wrote:
Hi All,
Attached file has two tabs (Raw Data OutCome). What I am trying to
achieve
Hi All,
Attached file has two tabs (Raw Data OutCome). What I am trying to
achieve is transposing column F G of the Raw Data onto OutCome tab. The
catch is to transpose basis the role which is listed as heading of Outcome
tab.
If in the list we have more than open person with similar role,
I want to capture an image and save to specified location in system
using vba. Also need the file address in the active cell.
Thank you in advance for your help.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
, Prakash Gusain gusainprak...@gmail.comwrote:
I want to capture an image and save to specified location in system
using vba. Also need the file address in the active cell.
Thank you in advance for your help.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise
Insert Symbol
Select the one you want. If not found change the font from drop
down.
Prakash
On Jan 31, 7:47 pm, bhupendra singh raghav
raghav.bhupen...@gmail.com wrote:
Hi Group,
I Need a spacial Symbol insert to excel work sheet. there is any opetion.
Please suggest.
Regards
Raghav.
Hi
I want to send emails with constant subject but with variable matter
to people in the my list. I am using Lotus notes as email client.
For example:
Column A has my mail matter. A1: xcvb, A2: assd A3: qwer A4: poiu
Column B has email addresses. B1: x...@gmail.com B2: a...@gmail.com
B3:
@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prakash Gusain
Sent: Dec/Fri/2011 01:56
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Send Personalized emails in Lotus Notes
Hi
I want to send emails with constant subject but with variable matter to
people
parameters
Sub sendMymail()
SendNotesMail(Subject , attachment, ReceipentEmailID, bodytext, ,True)
End Sub
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prakash Gusain
Sent: Dec/Fri/2011 02:53
To: MS EXCEL AND VBA MACROS
and/or the project developers have full access to.
Asa
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prakash Gusain
Sent: Sunday, December 25, 2011 9:54 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Disable delete
@googlegroups.com]
On Behalf Of Prakash Gusain
Sent: 26 December 2011 11:20
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Backup file on every save
Hi
I am trying to find the code to create a backup of file on every occasion
user saves the file. But I want to specify the location
Hi
I am trying to find the code to create a backup of file on every
occasion user saves the file. But I want to specify the location
where the backup file will be created.
I know the feature to create the backup of file but want to specify
the location where it saves the backup.
Thanks in
How can I disable the delete of an excel file? I don't want my user
to delete the excel file kept at a location.
Thanks in advance.
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help,
Sub FillInternetForm()
Dim objIE As Object
Set objIE = CreateObject(InternetExplorer.Application)
objIE.Navigate http://www.cvent.com/RFP/NewSupplierRequest.aspx?
vtt=1
objIE.Visible = True
Do While objIE.busy
While objIE.busy
DoEvents
Wend
Loop
;
objIE.Visible = True
Do While objIE.busy: Loop
objIE.Document.getElementById(txtSupplierName).Value = PRAKASH
End Sub
Regards,
Sam Mathai Chack (GL)
On Fri, Oct 21, 2011 at 12:32 AM, Prakash Gusain
gusainprak...@gmail.comwrote:
Sub FillInternetForm()
Dim objIE As Object
Dear Rakesh,
This code will help you get the desired result.
Sub ChangeAll()
Dim sh As Worksheet
Dim cl As Range
For Each sh In ActiveWorkbook.Worksheets
For Each cl In sh.UsedRange
If cl.Value 0 Then
cl.Value = 0
End If
Next
Hi,
Can any one provide me any code using which I can break the password
of any excel add in?
Prakash
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
=VLOOKUP(IF(SUM(VLOOKUP(DAY(L1),A20:B50,2,FALSE),VLOOKUP(MONTH(L1),C20:D31,2,FALSE),VLOOKUP(TIME(HOUR(L1),MINUTE(L1),SECOND(L1)),E21:G44,3,TRUE))K8,SUM(VLOOKUP(DAY(L1),A20:B50,2,FALSE),VLOOKUP(MONTH(L1),C20:D31,2,FALSE),VLOOKUP(TIME(HOUR(L1),MINUTE(L1),SECOND(L1)),E21:G44,3,TRUE))-
Dear Vinod,
The sum formula is giving correct solution if you mean by 0:20 mins. Kindly
explain where are you facing the issue or why do you think the sum for 4:30
is not correct.
--
Best Regards!
Prakash Singh Gusain
*Please visit my blog (**click here http://prakashgusain.blogspot.com/**)*
this is done plz ignore
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
Can you post the file? It will help us a lot!
--
Best Regards!
Prakash Singh Gusain
*Please visit my blog (**click here http://prakashgusain.blogspot.com/**)*
--
--
Some important links for excel users:
1. Follow
at 11:35 PM, Ahleah1031 jeannie.car...@chase.comwrote:
can't seem to attach the test file, could you advise as to how???
On Jan 27, 12:08 pm, Prakash Gusain gusainprak...@gmail.com wrote:
Can you post the file? It will help us a lot!
--
Best Regards!
Prakash Singh Gusain
*Please
=IF(ISERROR(VLOOKUP(B4,$E$3:$F$3,2,FALSE)),IF(ISERROR(VLOOKUP(B4,$H
$3:$I$3,2,FALSE)),VLOOKUP(B4,$K$3:$L$3,2,FALSE),VLOOKUP(B4,$H$3:$I
$3,2,FALSE)),VLOOKUP(B4,$E$3:$F$3,2,FALSE))
On Jan 25, 10:57 pm, Aamir Shahzad aamirshahza...@gmail.com wrote:
Hi experts,
Can I find values in multiple sheets
Hi,
I would like to know, how can I attach file with solution while
responding? Sorry being new to group I don't know anything about it.
Please take time to answer my query. It'll be a great help.
Regards
Prakash
--
HOW TO PASTE THE EXCEL FILE WHILE REPLYING.. RAKESH I AM SENDING
YOU THE SOLUTION ON YOUR ID... LET ME KNOW IF THAT HELPED..
On Jan 21, 11:34 am, saggi realsa...@gmail.com wrote:
not getting any idea after seeing ur data,
plz elaborate ur issue
On Jan 21, 4:21 am, Prakash Gusain
What are you looking for Rakesh? Kindly explain it little bit more.
Prakash Singh Gusain
http://prakashgusain.blogspot.com
On Jan 20, 6:01 pm, Rakesh Sharma rksharma...@gmail.com wrote:
*Hi ,*
*
*
*
*
*Please help me to make simple dashboard to modified .*
*
*
*for reference see
26 matches
Mail list logo