hi, i'm not PC programmer but i can tell something
you can create a template file and put your Yes to All condition in it
then each tab can check the file value for its decision
or
you can define a Public Variable to save the YestoAll condition in it
and the rest is same
thx
On Tue, Dec 15, 2009 a
Could you all please provide a macro which save each Sheet in a separate
worksheet as directed. Further, each time it updates the records the same
file unless otherwise new sheet has been added to the master workbook.
Regards,
C.G.Kumar
AMW-2
-Original Message-
From: excel-macros@googleg
Hi Abhishek,
Sorry about that. I'll send it tonight when I get home.
Regards - Dave.
Date: Tue, 15 Dec 2009 15:46:56 +0530
Subject: Re: $$Excel-Macros$$ A Simple VBA Query
From: abhishek@gmail.com
To: excel-macros@googlegroups.com
Hi Dave,
I am sorry I can't see any file attached. Plea
It sounds like you are sure that you want to overwrite the preexisting
files every time this procedure is run / executed. If so, The solution
is
" displayAlerts=False "
setting display alert off, would stop the message from being
displayed, But remember to set " DisplayAlerts=True " after the sa
Hi,
Try this code:
Sub DeleteCokeRows()
B = ActiveCell.SpecialCells(xlLastCell).Address
For Each c In Range(Cells(1, 1), B)
With c
Set A = .Find("coke", LookIn:=xlFormulas, LookAt:=xlPart,
MatchCase:=False)
End With
If Not A Is Nothing Then Rows(c.
can we get percentage in pivot table?
say for instance i have physican payer Mg_dispensed columns
Samuel Aetna 100
Samuel BCBS 200
Samuel wellcare 200
when we do a pivot can we get something like this:
samuel Aetna 10020%
samuel BCBS 20040%
samuel wellcare 2
Can anyone help me write a macro that will help me find all rows
containing the word "coke" and delete all of the rows entirely? I'm
having trouble trying to record something like this. In the end about
8,200 rows will be deleted.
Thanks!
--
---
Hello All,
I have created excel roster but i am stuck with formula. I have mentioned
all the information in the excel file.
Appreciate if you'll help me to create automated roster for every month
after inserting the shift for day 1 of the month.
Attached file for further information.
Thanks in
Hi,
I have just started VB programming. I have gone through your query & I think if
you change the code to .To = Sheets("Email").Range("A2").Value then mail will
be sent to e-mail ID mention in cell A2. I do not know how to send mail if you
have more than one emial addrees. But I think this may
Hi,
I haven't used this email code before, but my guess is that you would need a
loop.
Perhaps something like this:
A = 2 'or A = your first row number in the list of emails
Do until Sheets("Email").Cells(A, 1) = ""
With MailSendItem
.Subject = "Test"
.Body = "Testing 1,2,3"
.To = Sheets
You can always check to see if the file exists,
then delete it:
Set fso = CreateObject("scripting.FileSystemObject")
If (fso.fileexists(fName)) Then fso.deletefile fName, True
Paul
From: Sing
To: MS EXCEL AND VBA MACROS
Sent: Tue, December 15, 2009 10:3
Hello,
I have an excel program that creates 6 different tabs and then
attempts to save these different tabs as files in a specified folder.
If the program has already run and the files already exist in this
folder, excel says "A file named 'D:\Spectra Files\SLB-H.SPC' already
exists in this locati
I have a excel 2003 file that contains the following code to send a
email message to several people.
Sub SendMail()
Dim OL As Object, MailSendItem As Object
Set OL = CreateObject("Outlook.Application")
Set MailSendItem = OL.CreateItem(olMailItem)
With MailSendItem
.Subject = "Test"
.Body = "Tes
*Paste your data as link ... Go paste special and click paste as link*
On Tue, Dec 15, 2009 at 6:33 PM, Putta Madaiah wrote:
> Hi All,
>
> Is there any solution that if I update the data in excel that should get
> updated in the powerpoint silde directly.
>
> Rgds,
> Putta Madaiah
>
>
> --
>
> --
Hi All,
Is there any solution that if I update the data in excel that should get
updated in the powerpoint silde directly.
Rgds,
Putta Madaiah
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(V
Well, user can not select the sheet "Pass" unless he opens the VBA (or
creates a macro) which he can't without knowing the VBA password. And
ofcourse, as I said earlier, the password stored in that sheet is user's
password only, which he ALREADY knows, and can change it anytime. The sheet
protect p
Sure will...
Would request to keep group's id in copy of all emails related of the group.
Thanks,
AJ
On Tue, Dec 15, 2009 at 5:12 PM, Rajender Soni wrote:
> Hi
>
> Thanks for your reply, would request you pls approve my friend request in
> gmail.
>
> Regards
> Rajender
>
>
>
> On 12/15/09, Abh
Hi Rajender,
Well, if we wish to prompt user for a password, the password has to be
stored somewhere. I chose a hidden sheet. The sheet "Pass" is xlveryhidden
and can only be accessed via VBA so if we put a password in VBA, it should
give some security to it. However, the password may be stored so
Hi Dave,
I am sorry I can't see any file attached. Please re-send.
Best regards,
Abhishek
On Tue, Dec 15, 2009 at 3:28 PM, Dave Bonallack
wrote:
> Hi Abhishek,
> Have a look at the attached. Details enclosed. Let me know if it suits your
> needs.
> Regards - Dave.
>
>
> --
You are always welcome..!!
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Dec 15, 2009 at 2:33 AM, Vinod N wrote:
> Anyways.. Thanks a to!! Dilipji
>
>
> On Mon, Dec 14,
Hi Abhishek,
Have a look at the attached. Details enclosed. Let me know if it suits your
needs.
Regards - Dave.
Date: Mon, 14 Dec 2009 13:15:55 +0530
Subject: Re: $$Excel-Macros$$ A Simple VBA Query
From: abhishek@gmail.com
To: davebonall...@hotmail.com; excel-macros@googlegroups.com
Hi Da
21 matches
Mail list logo
