date:20110427

$$Excel-Macros$$ Re: Please Help.................

2011-04-27 Thread ashish koul

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 Report*"  button.
>  Please see attached sheet..
>
> Thanks in Advance
>
> --
> Thanks & regards,
> Noorain Ansari
>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>
>


-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ RE: Multiple file Formatting

2011-04-27 Thread ashish koul

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)
If Not objFolder Is Nothing Then
SelectFolder = objFolder.Items.Item.Path
End If
End Function

Sub FORMATMULTIPLE()

application.screenupdating = false

' tool -> reference -> Microsoft shell control and automation
Dim fldpth As String
Dim fld, fil As Object
Dim j, a As Long
Dim ask, ask2 As Workbook
fldpth = SelectFolder("Select Folder", "")
Set fso = CreateObject("scripting.filesystemobject")
Set fld = fso.getfolder(fldpth)

For Each fil In fld.Files

Set ask2 = Workbooks.Open(fil.Path)
ask2.Activate

-- paste your code for activeworkbook here



ask2.Close
Next fil
 application.screenupdating = true

End Sub
























On Wed, Apr 27, 2011 at 2:15 AM, Muni  wrote:

> Hi Srinivas,
>
> if all the files are under same folder than u can write an macro which
> opens each file automatically and then which runs your macro for formatting.
>
> You can use fso file object and then you can open each file in the folder
> using the for next where u can call ur macros
>
> Hope this might help.
>
> Please let me know if you need any further help on this
>
>
> On Tue, Apr 26, 2011 at 11:46 AM, Chidurala, Shrinivas <
> shrinivas.chidur...@citi.com> wrote:
>
>> Please help.
>>
>> 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
>>
>>
>> -Original Message-
>> From: Chidurala, Shrinivas [ICG-GTS]
>> Sent: Monday, April 25, 2011 9:10 PM
>> To: excel-macros@googlegroups.com
>> Subject: Multiple file Formatting
>>
>> Dear Gurus,
>>
>> I have created the attached macro for formatting of 50 to 60 files
>> everyday which are receive from system. But to run this macro i need to open
>> and then run. It taking too much time.
>>
>> Please can you advise to prepare the macro which will give facility do
>> similar formatting of all files at a time, if i save all files in specific
>> folder.
>>
>> Find attached sample file for your reference.
>>
>> Thanks in Advance
>>
>> Regards,
>> Shrinivas
>>
>> --
>>
>> --
>> 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://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Regards
> Muni
>
> --
>
> --
> 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://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 17 Messages in 11 Topics

2011-04-27 Thread saggi

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, renuka chari  wrote:
> > thanks to all here i am attaching one sheet here how to remove this
> > kind of special characters help me plz
>
> > --
>
> > --- 
> > ---
> > 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://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel

-- 
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ Help on Macro

2011-04-27 Thread Prashant

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

Try,

 

Hello,

Try :

Sub Import()

Dim Enrgt As String, lgRow As Long, Tabl, inCol As Integer

Dim inCalculationMode As Integer

Application.ScreenUpdating = False

inCalculationMode = Application.Calculation

Application.Calculation = xlCalculationManual

Sheets.Add

Close #1

Open "d:\donnees\daniel\mpfe\TB.txt" For Input As #1

 

Do While Not EOF(1)

Line Input #1, Enrgt

Tabl = Split(Enrgt, " ")

If Tabl(LBound(Tabl)) = "No" Then

Line Input #1, Enrgt

Tabl = Split(Enrgt, " ")

lgRow = lgRow + 1

col = 7

For i = 47 To UBound(Tabl)

If Tabl(i) <> "" Then

col = col + 1

Cells(lgRow, col) = Tabl(i)

End If

Next i

col = 0

Line Input #1, Enrgt

Tabl = Split(Enrgt, " ")

For i = 0 To 7

If Tabl(i) <> "" Then

col = col + 1

Cells(lgRow, col) = Tabl(i)

End If

Next i

Exit Do

End If

Loop

Do While Not EOF(1)

Line Input #1, Enrgt

Tabl = Split(Enrgt, " ")

col = 0

If UBound(Tabl) >= 0 Then

If UBound(Tabl) > 0 And IsNumeric(Tabl(LBound(Tabl))) Then

lgRow = lgRow + 1

For Each Item In Tabl

If Item <> "" Then

col = col + 1

Cells(lgRow, col) = Item

End If

Next Item

End If

End If

Loop

Close #1

Application.Calculation = inCalculationMode

Application.ScreenUpdating = True

End Sub

 

Regards.

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Prashant
Envoyé : mardi 26 avril 2011 09:25
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Help on Macro

 

Dear All,

 

Find attached text file - tb report, I want to culture the data of the txt
file, so that It can be used in excel. Desired output is shown in book-1.

 

Need a marco to get desired output from text, automatically.

 

Regards,

 

Prashant

-- 

--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 

--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


-- 
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Need Help urgent Please

2011-04-27 Thread syed aliya raza hashim

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 so
it is going to expire from current date then so it has to prompt me when we
open the file and display the message "under UPS Tab your product id
1002&1003 expired" same as for all the tab it should display the meassage
for all the tab if date is expired into one message box
like for same all other tab
-- 
syed aliya

-- 
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Need Help.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Please Help.................

2011-04-27 Thread STDEV(i)

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 wrote:

> Dear Experts,
>
> How can Hide only workbook but userform should be visilble and work as it,
> when we click on "*Eng In out Report*"  button.
> Please see attached sheet..
>
> Thanks in Advance
>
> --
> Thanks & regards,
> Noorain Ansari
>

-- 
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Query (mr_ansari).xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Please Help.................

2011-04-27 Thread NOORAIN ANSARI

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) at time of userform
> deactivated or unloaded
> Application.visible = False
>
> se attachaed workbook
>
>
>
> On Wed, Apr 27, 2011 at 1:38 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 Report*"  button.
>> Please see attached sheet..
>>
>> Thanks in Advance
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>>
>
> --
>
> --
> 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://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Thanks & regards,
Noorain Ansari

-- 
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Refreshing Pivot Table using VBA Code

2011-04-27 Thread Chandra Shekar

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 excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Bold & set color some text in msgbox

2011-04-27 Thread Dhartikumar Sahu

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 tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Need Help Urgently on how to Parse data

2011-04-27 Thread Mog Obahor

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 are different
A   B CD E
   F  G  H I
akd  oij4eij   oin  01-1220 alkmd  klmd
   Joe Bloe   lkdlkjd  04/13/2012
adfl   pojp ad  01-3123  aldad
 dfd Ben Janaklndl  01/22/2011
ioej   oijdooij   01-3123 adfdf
dfadSuzy J  akddfd 02/12/2012

I need a macro that will run through the contiguous data and delete the
ENTIRE row of data where the data between all occurence are old but keep the
latest farthest date.  So using the above example, I want to delete row 2
since the date is 1/22/2011.  There are times when there are 3 or 4
occurences in the data  so the determining factor of deleting the rows is
based on the dates.

After all the parsing andn sorting is done, I need it to sort the entire
spreadsheet data based on the date in Col I
Also I want the year of 2011 and 2012 separated either by separate sheets..

So in a nutshell it starts out with one sheet then ends up with two sheets
one with data for 2011 and the other with data for 2012

Thanks..

-- 
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Need Help urgent Please

2011-04-27 Thread syed aliya raza hashim

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-Apr-2011
1003   28-Apr-2011


the output would be for 1002 because 26 april ia less than the system date
or today date,same for all the tab



On Wed, Apr 27, 2011 at 4:04 AM, ashish koul  wrote:

> try this
>
>
>
> On Wed, Apr 27, 2011 at 12:50 PM, syed aliya raza hashim <
> hashim...@gmail.com> wrote:
>
>>
>> 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 so
>> it is going to expire from current date then so it has to prompt me when we
>> open the file and display the message "under UPS Tab your product id
>> 1002&1003 expired" same as for all the tab it should display the meassage
>> for all the tab if date is expired into one message box
>> like for same all other tab
>> --
>> syed aliya
>>
>> --
>>
>> --
>> 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://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
>  --
>
> --
> 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://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
syed aliya

-- 
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ How to reduce the file size

2011-04-27 Thread Sundarvelan N

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 group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Bold & set color some text in msgbox

2011-04-27 Thread Abhishek Jain

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
> Dhartikumar Sahu
>
> --
>
> --
> 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://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ How to reduce the file size

2011-04-27 Thread rajan verma

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. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regards
Rajan verma
+91 9158998701

-- 
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ RE: Multiple file Formatting

2011-04-27 Thread Chidurala, Shrinivas

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@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of ashish koul
Sent: Wednesday, April 27, 2011 12:47 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ RE: Multiple file Formatting

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)
If Not objFolder Is Nothing Then
SelectFolder = objFolder.Items.Item.Path
End If
End Function

Sub FORMATMULTIPLE()

application.screenupdating = false

' tool -> reference -> Microsoft shell control and automation
Dim fldpth As String
Dim fld, fil As Object
Dim j, a As Long
Dim ask, ask2 As Workbook
fldpth = SelectFolder("Select Folder", "")
Set fso = CreateObject("scripting.filesystemobject")
Set fld = fso.getfolder(fldpth)

For Each fil In fld.Files

Set ask2 = Workbooks.Open(fil.Path)
ask2.Activate

-- paste your code for activeworkbook here



ask2.Close
Next fil
application.screenupdating = true

End Sub
























On Wed, Apr 27, 2011 at 2:15 AM, Muni 
mailto:muni.r...@gmail.com>> wrote:
Hi Srinivas,

if all the files are under same folder than u can write an macro which opens 
each file automatically and then which runs your macro for formatting.

You can use fso file object and then you can open each file in the folder using 
the for next where u can call ur macros

Hope this might help.

Please let me know if you need any further help on this


On Tue, Apr 26, 2011 at 11:46 AM, Chidurala, Shrinivas 
mailto:shrinivas.chidur...@citi.com>> wrote:
Please help.

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


-Original Message-
From: Chidurala, Shrinivas [ICG-GTS]
Sent: Monday, April 25, 2011 9:10 PM
To: excel-macros@googlegroups.com
Subject: Multiple file Formatting

Dear Gurus,

I have created the attached macro for formatting of 50 to 60 files everyday 
which are receive from system. But to run this macro i need to open and then 
run. It taking too much time.

Please can you advise to prepare the macro which will give facility do similar 
formatting of all files at a time, if i save all files in specific folder.

Find attached sample file for your reference.

Thanks in Advance

Regards,
Shrinivas

--
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.com
4. Learn VBA Macros at 
http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.com

To post to this group, send email to 
excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel



--
Regards
Muni


--
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.com
4. Learn VBA Macros at 
http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.com

To post to this group, send email to 
excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel



--
Regards

Ashish Koul
akoul.blogspot.com
akoul.wordpress.com
My Linkedin Profile


P Before printing, think about the environment.




--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitte

Re: $$Excel-Macros$$ help

2011-04-27 Thread vijayajith VA

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 wrote:
>
>> Thanks
>>
>>
>> Hai
>>
>> just i want to know y used VLOOKUP(VLOOKUP is used
>>
>> one Vlookup is enough rit?
>>
>>
>> On Mon, Apr 25, 2011 at 9:13 PM, ashish koul wrote:
>>
>>> see if it helps
>>>
>>> name:-   =VLOOKUP(A25,A4:$C$8,2,0)
>>>
>>> lecture =VLOOKUP(VLOOKUP(A25,$A$3:$C$8,3,0),$A$13:$C$16,3,0)
>>>
>>>
>>>
>>>
>>> On Mon, Apr 25, 2011 at 6:36 PM, vijayajith VA 
>>> wrote:
>>>
 hai


 Please see the attched exl file..

 i need your help

 thanks

 --

 --
 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://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

>>>
>>>
>>>
>>> --
>>> *Regards*
>>> * *
>>> *Ashish Koul*
>>> *akoul*.*blogspot*.com 
>>> *akoul*.wordpress.com 
>>> My Linkedin Profile 
>>>
>>>
>>> P Before printing, think about the environment.
>>>
>>>
>>>  --
>>>
>>> --
>>> 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://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>  --
>>
>> --
>> 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://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Regards
> Muni
>
>  --
>
> --
> 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://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ Refreshing Pivot Table using VBA Code

2011-04-27 Thread Daniel

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

 

Regards.

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Chandra Shekar
Envoyé : mercredi 27 avril 2011 11:31
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Refreshing Pivot Table using VBA Code

 

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 excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Font for password

2011-04-27 Thread Rajesh K R

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

-- 
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Please Help

2011-04-27 Thread Chidurala, Shrinivas

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 links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Help.xls
Description: Help.xls

$$Excel-Macros$$ Macro to make Excel File Expired after few times open & close

2011-04-27 Thread Zafar Iqbal

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
Olayan Descon Industrial Co, Jubail, KSA
Email: ziqba...@gmail.com

-- 
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Please Help

2011-04-27 Thread ashish koul

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.
>
> Thanks in Advance
>
> Regards,
> Shrinivas
>
> --
>
> --
> 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://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Macro to make Excel File Expired after few times open & close

2011-04-27 Thread 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 2
You can make a code to do not open after 4 registers in column zz

I will try to find the file to send you

Best Regards

André Luiz D´Avila


2011/4/27 Zafar Iqbal 

> 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
> Olayan Descon Industrial Co, Jubail, KSA
> Email: ziqba...@gmail.com
>
> --
>
> --
> 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://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Macro to make Excel File Expired after few times open & close

2011-04-27 Thread André D'Avila

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 escreveu:

> 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 2
> You can make a code to do not open after 4 registers in column zz
>
> I will try to find the file to send you
>
> Best Regards
>
> André Luiz D´Avila
>
>
>
> 2011/4/27 Zafar Iqbal 
>
>> 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
>> Olayan Descon Industrial Co, Jubail, KSA
>> Email: ziqba...@gmail.com
>>
>> --
>>
>> --
>> 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://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>

-- 
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


File.xlsm
Description: Binary data

RE: $$Excel-Macros$$ Excel spell out word from number

2011-04-27 Thread vikram

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@googlegroups.com
Subject: Re: $$Excel-Macros$$ Excel spell out word from number

 

Dear Vikram

i am attached   "rupees-word.bas   " macro file with this mail , do the
following steps

   1. open the excel file
   2. select tools - macros - visual basic editor -  file - import - select
"rupees-words.bas" close it
  3. save the excel file
  4. again open


note : Select Macro Security Medium

Mothilal.J




On Sat, Apr 23, 2011 at 6:09 PM, vikram  wrote:

Hi,

 

Please advice the way by which we can view such macros and add in our
workbooks.

 

As this function is showing in sheet attached but I am not able to get this
add to new workbook.

 

Kindly help in this regard.

 

Regards,

 

Vikram 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of jmothilal
Sent: Saturday, April 23, 2011 12:03 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Excel spell out word from number

 

Dear Friend


here with i am attached fle macro file u add this.

Thanks with

Mothilal.j
Vellore-2

On Wed, Apr 20, 2011 at 7:33 PM, Tony O  wrote:

I have an Excel spreadsheet with a column of numbers.  I would like
each number to be
spelled out, for example

B1=4
C1=four

B2=99
C2=ninety-nine.

How would I go about this with a macro?

--

--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel




-- 
J.Mohilal
Universal Computer Systems
# 16, Brindavan Complex
Otteri, Vellore-2

-- 


--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 

--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel




-- 
J.Mohilal
Universal Computer Systems
# 16, Brindavan Complex
Otteri, Vellore-2

-- 

--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page

Re: $$Excel-Macros$$ Need Help urgent Please

2011-04-27 Thread ashish koul

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 = SWA1 & vbNewLine & Sheets("UPS").Cells(j, 1).Value
End If

Next j
Sheets("Router").Activate
For j = 2 To Sheets("Router").Range("a1").End(xlDown).Row
If CDate(Sheets("Router").Cells(j, 2).Value) <= DateSerial(Year(Now),
Month(Now), Day(Now)) Then
SWA2 = SWA2 & vbNewLine & Sheets("Router").Cells(j, 1).Value
End If
Next j
Sheets("SMPS").Activate
For j = 2 To Sheets("SMPS").Range("a1").End(xlDown).Row
If CDate(Sheets("SMPS").Cells(j, 2).Value) <= DateSerial(Year(Now),
Month(Now), Day(Now)) Then
SWA3 = SWA3 & vbNewLine & Sheets("SMPS").Cells(j, 1).Value
End If
Next j

MsgBox "UPS" & ":-" & vbNewLine & SWA1 & vbNewLine & "" &
vbNewLine & "Router" & ":-" & vbNewLine & SWA2 & vbNewLine & ""
& vbNewLine & _
 "SMPS" & ":-" & vbNewLine & SWA3
Sheets("UPS").Activate
End Sub


-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Re: Please Help.................

Re: $$Excel-Macros$$ RE: Multiple file Formatting

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 17 Messages in 11 Topics

RE: $$Excel-Macros$$ Help on Macro

$$Excel-Macros$$ Need Help urgent Please

Re: $$Excel-Macros$$ Please Help.................

Re: $$Excel-Macros$$ Please Help.................

$$Excel-Macros$$ Refreshing Pivot Table using VBA Code

$$Excel-Macros$$ Bold & set color some text in msgbox

$$Excel-Macros$$ Need Help Urgently on how to Parse data

Re: $$Excel-Macros$$ Need Help urgent Please

$$Excel-Macros$$ How to reduce the file size

Re: $$Excel-Macros$$ Bold & set color some text in msgbox

Re: $$Excel-Macros$$ How to reduce the file size

RE: $$Excel-Macros$$ RE: Multiple file Formatting

Re: $$Excel-Macros$$ help

RE: $$Excel-Macros$$ Refreshing Pivot Table using VBA Code

$$Excel-Macros$$ Font for password

$$Excel-Macros$$ Please Help

$$Excel-Macros$$ Macro to make Excel File Expired after few times open & close

Re: $$Excel-Macros$$ Please Help

Re: $$Excel-Macros$$ Macro to make Excel File Expired after few times open & close

Re: $$Excel-Macros$$ Macro to make Excel File Expired after few times open & close

RE: $$Excel-Macros$$ Excel spell out word from number

Re: $$Excel-Macros$$ Need Help urgent Please

25 matches

Site Navigation

Mail list logo

Footer information