Dear All,
Is it possible to protect a folder or a doc/xls or any file name so that
nobody can rename/change the file/folder name.
Thanks & regards,
Usha
--
--
Some important links for excel users:
1. Follow us on TW
look here if that's what you mean:
http://www.erlandsendata.no/english/index.php?d=envbaolecontroloutlook
Sub ListAllItemsInInbox()
regards
r
2010/12/13 Santosh Vishwakarma
>
> Hi
>
> Can any one let me know how to get the information about outlook folder
> items (Inbox) and get them in reco
yes sr
see this link
http://sites.google.com/site/chilexcel/desbloqueos-y-removepass
2010/12/15 SAJID MEMON
> Hi All Experts,
>
> Can we crack any VBA password like attachment !
> If Yes then please give me tips.
>
> awaiting your positive responce
>
> sajid memon
>
>
> --
>
>
this is a sheet to manage the current projects;
under flag; n/a and completed column there are check boxes;
if check box under flag is checked then figure becomes red;
if check box under completed is checked figure turns into green from
red;
if n/a is checked then figure turns into grey;
so in s
Outrageous! We like simple. :) Many thanks Paul.
Pete
On Dec 15, 1:50 pm, Paul Schreiner wrote:
> If that's the case, use:
>
> ShtName = sheet11.Name
>
> Range("N15") = "=SUM('" & ShtName & "'!AC3403:AC3409)*1000"
>
> Paul
>
>
>
> - Original Message
> > From: Susan
> > To: MS EXCEL A
I love it when simple code works so well. Thank you!
--
--
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 @ http:
Keep in mind that Excel doesn't know "time".
It knows "numbers".
Time is simply the "fractional part of a day"
9:30 is 0.3958333 of a day.
10:00 is 0.417 of a day.
so, 9:30 - 10:00 is: -0.0208334
Now really, is 12/15/2010 -01:30 PM a valid time?
Of course not... how ca
You could simply:
On Error Resume Next
Workbooks("File1.xls").Close
Workbooks("File2.xls").Close
On Error Goto 0
Paul
- Original Message
> From: 0 1
> To: MS EXCEL AND VBA MACROS
> Sent: Wed, December 15, 2010 10:36:02 AM
> Subject: Re: $$Excel-Macros$$ Check if two files are open; i
If that's the case, use:
ShtName = sheet11.Name
Range("N15") = "=SUM('" & ShtName & "'!AC3403:AC3409)*1000"
Paul
- Original Message
> From: Susan
> To: MS EXCEL AND VBA MACROS
> Sent: Wed, December 15, 2010 11:00:07 AM
> Subject: Re: $$Excel-Macros$$ Reference sheet number in macro
There's a couple of ways.
One I like is to check the current login ID.
then, if it's YOURS, prompt you for permission to execute.
Another way is to check the path.
I copy the file to a Development location before opening.
Since it is NOT in the "production" path, it does not automatically run.
Pa
I have a workbook that I would like to have updated nightly by the
scheduler. To that end, I have created a sub workbook_open that calls
the macro that I need to run.
How do I stop the macro from running when I open the workbook
manually? I know I can open the workbook holding down the shift key
Thank you Dave. Perhaps you can clarify:
I'm not sure that this will work as I'm asking the macro to repopulate
a cell with a formula. Inside the instruction, is the sheet name, and
I'm not sure if it will accept a sheet number in it's place.
In the following instruction, I'm looking for the cor
Hi All,
When I subtract 9:30 from 10:00 (Data Type :Time),all I get to see is
###.How do I go about resolving this issue.I require a positive number 0:30
inspite of the result turning out to be negative.
FYI
=(1-2)
Current Expecting
19:309:30
210:00 10:00
Daniel,
Excellent. Thank you very much. Both of these work exactly as I
wished.
I have now located ENVIRON in the VBA-Help. I see that I can use this
to read other environment variables as shown in
ControlPanel>System>Advanced>EnvironmentVariables. However, COMPUTER-
NAME and USER-NAME are no
Daniel,
Excellent. Thank you very much. Both of these work exactly as I wished.
I have now located ENVIRON in the VBA-Help. I see that I can use this to read
other environment variables as shown in
ControlPanel>System>Advanced>EnvironmentVariables. However, COMPUTER-NAME and
USER-NAME are not
Using two separate if-then statements did the trick. But now I have a
related problem.
I'm trying to reverse the code in order to *close* the sheets, if they
are open. I figured I could use the same code for the Function
WorkbookOpen ..., but a new subroutine for closing them:
Public Sub CloseSou
Hi,
1. Formula should be (in H3 :
=SUMIF('STOCK SUMMERY'!A3:A5,REPORT!A3,DAMAGE!B2:B5)
2. The drinks in column A should be in the same order on each sheet.
Regards.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de Rajesh K
Try :
ComputerName = Environ("ComputerName")
User = Environ("UserName")
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de keelta
Envoyé : mercredi 15 décembre 2010 15:22
À : MS EXCEL AND VBA MACROS
Objet : $$Excel-Macros$$ O
Is it possible to obtain within an VBA Excel macro:
- the name of the computer on which the macro is running (as in
ControplPanel>System>ComputerName
- the name of the Windows logged in user
--
--
Some important link
Hi Kantilal,
Thanks for your reply. Could you please save this attachment in excel 2003?
Is that possible in excel 2003?
Regards,
Alisha
On Thu, Dec 9, 2010 at 5:56 AM, Kantilal Badale
wrote:
>
>
> check the attachment see if it helps .
>
> Kantilal Badale
>
>
>
>
> On Tue, Dec 7, 2010 at 4:06
Hi Experts
Pls find the attachment ,& tell me whats wrong in the formula
STOCK SUMMERY - 1 st sheet
OPENING PURCHASESALEBALANCE
COLA 1000 250 700 550
SODA500100 300 300
WATER 400 150
Hey Ayush,
Appreciate if you look into this one.
Rgds
Santosh
-- Forwarded message --
From: Santosh
Date: Mon, Dec 13, 2010 at 9:44 PM
Subject: $$Excel-Macros$$ Outlook Folder Items Information
To: MS EXCEL AND VBA MACROS
Cc: jainayus...@gmail.com, robb@gmail.com
Hi
Can
Dear Danial, Gud Morng.
Thanks a ton dear for your feedback & valuable support, its very useful for
me.
hv a gud day,
Thanks Again
Bye & Take Care
Deepak (ROHAN)
91-9818247278, 91-8860567680
On Tue, Dec 14, 2010 at 9:35 PM, Daniel wrote:
> Hello,
>
> I needed to add a helper column (sheet
Dear All Group Member, Kind Attn- Mr. Ayush Jain,
I need a excel macro book for start to bottom level creating macro,
preparing interview skill & help VB also.
Please suggest.
--
Thanks,
Prabhakar Thakur
New Delhi
+919953736776
--
--
Hi,
I am doing a month to year, home budget spreadsheet and on tab name "RAW"
column F1, I have a drop down list that contains about 12 subjects , such
as groceries, home maintenance, AT&T ..etc. This drop down list will sort
all such selected subjects like 'groceries' and SUM for me at last
Getting Invalid Outside Procedure.
On what was sheet12 I opened the VBA editor and entered:
shtname = ActiveSheet.Name
In the macro located in the sheet11 I entered:
Sub RefreshFormulasInSummary_15()
Sheet11.Select
Range("N15") = "=SUM(" & shtname
Hi Guys,
Hopefully spomeone here can help me out, as I am now totally
frustrated with this problem.
- Purchase new computer
- Installed Windows 7 64 bit.
- Intsalled both Excel 2003 & 2007.
I have many files that have use macros. I never had a problem running
any of them under XP. After debbing
27 matches
Mail list logo
