Try ths code
Private Sub Workbook_Open()
Dim i, j, k As Long
Dim SWA1, SWA2, SWA3 As String
SWA1 = ""
SWA2 = ""
SWA3 = ""
Sheets("UPS").Activate
For j = 2 To Sheets("UPS").Range("a1").End(xlDown).Row
If Sheets("UPS").Cells(j, 2).Value <= DateSerial(Year(Now), Month(Now),
Day(Now)) Then
SWA1 = SW
Hi,
Can u please send me the file I need to attach as per below instructions.
Thanks for your help.
Regards,
Vikram
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of jmothilal
Sent: Monday, April 25, 2011 12:05 PM
To: excel-macros@googleg
Zafar,
I attached a excel file and readapted for your need.
Just change in my code the "Sheet" and the "collumn" for a less visible one
as possible.
You can open and save the file for 4 turns only...
Good Luck!
Best Regards
André Luiz D´Avila
Em 27 de abril de 2011 16:20, André D'Avila
Hey,
im not an expert but a long time I did something close to what you need...
Each time the file is opened and after the user enable macro security, i did
a code to write in Plan1 column ZZ line 1 "=now()"
After save it, the 2 time the user open the file, it writes down the date
and time in line
try this
=B3/(RIGHT(C3,LEN(C3)-FIND("~",SUBSTITUTE(C3,"
","~",LEN(C3)-LEN(SUBSTITUTE(C3," ","")*1)
On Wed, Apr 27, 2011 at 7:32 PM, Chidurala, Shrinivas <
shrinivas.chidur...@citi.com> wrote:
> Dear Gurus,
>
> Please advise any formula to calculate the Book Value in given attachment.
>
> Tha
Dear All,
Can someone help in making a macro which will make the Excel file expired
after few tries of open & close. For example, file can be opned, saved &
closed for four times but this file should not open after 5th time to open.
Please help. Thanks
Regards,
ZAFAR IQBAL
Incharge Planning
Olaya
Dear Gurus,
Please advise any formula to calculate the Book Value in given attachment.
Thanks in Advance
Regards,
Shrinivas
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and li
Hi Experts,
In my worksheet I used a cell to enter my secret password. I made the
file in way that the formulas in that sheet will work only if that
value is correct. I want hide the secret password from others. eg I
need the fonts like or # . How can I do it.
Regards
Rajesh kainikkara
Hi,
Paste the following macro in Sheet1 module :
Private Sub Worksheet_Change(ByVal Target As Range)
'A1:F10 is data for pivot table 1 G1:I10 is data for pivot table 2...
If Not Intersect(Target, Union([A1:F10], [G1:I10])) Is Nothing Then
ThisWorkbook.RefreshAll
End If
End Sub
Reg
thanks
muni
On Wed, Apr 27, 2011 at 2:02 AM, Muni wrote:
> two vlookup is used to extract data from 2 different data sets first to
> extract the department based on roll number and then to extract the lecturer
> name from department data set
>
>
> On Tue, Apr 26, 2011 at 9:19 AM, vijayajith VA
Thanks a lot Ashish sir.
Regards,
Shrinivas
Citi(r) Global Transaction Services - India
UB City, Canberra Block, # 24, Vittal Mallya Road,
Bangalore - 56 00 01.
Ph- +91-80-4144 6339 / 6340
Email - shrinivas.chidur...@citi.com
From: excel-macros@googlegroup
Save File in .xlsb fomat
On Wed, Apr 27, 2011 at 4:35 PM, Sundarvelan N wrote:
> How to reduce the file size
>
> --
> Thanks
> N.Sundarvelan
> 9600160150
>
> --
>
> --
> Some important links for excel users:
> 1. Fo
Not without extensive use of APIs. Use an userform instead which can be
formatted in any way you like.
On Wed, Apr 27, 2011 at 3:36 PM, Dhartikumar Sahu wrote:
> hi experts
>
> Is there any way to set some (not all) of the text to bold when using the
> MsgBox in VBA.
>
> Thanks & Regards
> Dhart
How to reduce the file size
--
Thanks
N.Sundarvelan
9600160150
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN g
Hi Ashish,
Thanks for replying but it is showing for only 28-April-2011 see what i want
to display the meassage which date has been expired eg.today date is 27
april ,so the message display for less than the today date or system date
for example
Product Date
1001 3-May-2011
1002 26-
I have an excel file with a list of column data. first of all, after the
data is sorted based on the Col D, then I need a routine to check if any row
data in Col D occurs more than once. If it occurs more than once..
For example: Column D has data on Row 2 and Row 3 same but the Date on
Column I
hi experts
Is there any way to set some (not all) of the text to bold when using the
MsgBox in VBA.
Thanks & Regards
Dhartikumar Sahu
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tric
Hi,
In sheet1 I have 5 pivot table and source in sheet2. Here I need macro which
refresh pivot table when I paste new data.
Thanks in Advance.
Regards,
Chandra Shekar B
9845976015
--
--
Some important links for ex
Thanks a lot of Setiywati(STDEV). and Ashish...
it's working fine
On Wed, Apr 27, 2011 at 3:50 PM, STDEV(i) wrote:
> by hiding application objec at time of userform initialized or activated
> Application.visible = False
>
> and don' forget to unhide the aplication (excel)
by hiding application objec at time of userform initialized or activated
Application.visible = False
and don' forget to unhide the aplication (excel) at time of userform
deactivated or unloaded
Application.visible = False
se attachaed workbook
On Wed, Apr 27, 2011 at 1:38 PM, NOORAIN ANSARI wr
Hi,
In my sheet there are three tab 1)UPS tab 2)Router tab 3)SMPS tab
so there are date column as well is there
my question :when we open the excel file it should prompt me the message the
date is going to expire on which tab
for example :suppose in UPS tab for product no 1002&1003 date is 26 Apr s
Dear Daniel,
Many thanks , its working fine
Regards,
Prashant
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Daniel
Sent: 26 April, 2011 10:23 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Help on Macro
Tr
Use Clean (a1) Formula
Clean Formula remove special character from cell which r not visible.
regards
Vijay
On Apr 26, 1:31 pm, Yogesh Gohil wrote:
> Hi Renuka,
>
> You can use TRIM formula. Like
> =TRIM(A1)
>
> Thanks and Regards
> Yogesh Gohil
>
>
>
>
>
>
>
> On Tue, Apr 26, 2011 at 11:12 AM,
save all work in a directory and run the macro and choose taht directory
Function SelectFolder(Optional Title As String, Optional TopFolder _
As String) As String
Dim objShell As New Shell32.Shell
Dim objFolder As Shell32.Folder
Set objFolder = objShell.BrowseForFolder _
(0, Title, 1, TopFolder
try this
Private Sub CommandButton1_Click()
ThisWorkbook.Windows(1).Visible = False
UserForm1.Show
End Sub
On Wed, Apr 27, 2011 at 12:08 PM, NOORAIN ANSARI
wrote:
> Dear Experts,
>
> How can Hide only workbook but userform should be visilble and work as it,
> when we click on "*Eng In out
25 matches
Mail list logo
