$$Excel-Macros$$ FW: Amount clean after closed file

2013-03-14 Thread Umesh Gupta
From: umeshj...@live.com To: davebonall...@hotmail.com Subject: Amount clean after closed file Date: Thu, 14 Mar 2013 15:00:46 +0530 Hello Dave I need soluation when closed excel file amount will be clean Thanks -- Are you

$$Excel-Macros$$ Macro for filter data send it to respective user through mail

2013-03-14 Thread sagaraher
Hello, I am looking for Macro for filter data send it to respective user through mail, pl find details below 1) I have various dept like SCM / Mktg / Engg / HR etc data attached to each dept, when we apply filter we can see data related to particular dept. 2) I want to create separate excel

Re: $$Excel-Macros$$ Macro for filter data send it to respective user through mail

2013-03-14 Thread अनिल नारायण गवली
Dear Sagar, From which mail u want to send the file ? from gmail,yahoo, or from outlook??? Warm Regards, Gawli Anil On Thu, Mar 14, 2013 at 3:29 PM, sagaraher sagara...@gmail.com wrote: Hello, I am looking for Macro for filter data send it to respective user through mail, pl find

Re: $$Excel-Macros$$ FW: Amount clean after closed file

2013-03-14 Thread David Grugeon
In the This Workbook module put the following Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Sheet1.TextBox1.Text = ThisWorkbook.Save End Sub Regards David Grugeon On 14 March 2013 19:37, Umesh Gupta umeshj...@live.com wrote: -- From:

$$Excel-Macros$$ Re: Find Distance and Time between two cities using Google Map In excel

2013-03-14 Thread sagaraher
Can you pl tel me how to run it, as I cant see option available in view- Macro On Saturday, February 25, 2012 6:31:12 PM UTC+5:30, ashish wrote: Hi Group Try this udf it will help you in finding the time and distance between two cities using Google Map -- *Regards* * * *Ashish

Re: $$Excel-Macros$$ Macro for filter data send it to respective user through mail

2013-03-14 Thread Sagar Aher
Outlook On Mar 14, 2013 3:37 PM, अनिल नारायण गवली gawlianil8...@gmail.com wrote: Dear Sagar, From which mail u want to send the file ? from gmail,yahoo, or from outlook??? Warm Regards, Gawli Anil On Thu, Mar 14, 2013 at 3:29 PM, sagaraher sagara...@gmail.com wrote: Hello, I am

Re: $$Excel-Macros$$ Required Macro for unique no

2013-03-14 Thread Viney
Hi Shiva, this is my first post to the group... try this macro Sub RemoveDuplicates() ' ' Macro2 Macro ' ' Sheets(Sheet1).Select Columns(B:B).Select Selection.Copy Columns(H:H).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _

$$Excel-Macros$$ Re: Required Macro for unique no

2013-03-14 Thread Prince
Hi Shiva Why dont you use remove Duplicate option of excel itself. regards prince On Thursday, March 14, 2013 4:47:13 PM UTC+5:30, shivapr...@gmail.com wrote: Dear champs, please find the attchement of test sheet any one provide macro for unique no. plase help me. -- Regards,

$$Excel-Macros$$ Re: Find Distance and Time between two cities using Google Map In excel

2013-03-14 Thread Prince
Alt+F11 regards PRINCE On Thursday, March 14, 2013 4:18:32 PM UTC+5:30, sagaraher wrote: Can you pl tel me how to run it, as I cant see option available in view- Macro On Saturday, February 25, 2012 6:31:12 PM UTC+5:30, ashish wrote: Hi Group Try this udf it will help you in finding

$$Excel-Macros$$ My Excel is Crashing!!

2013-03-14 Thread rajan verma
New thread i know , every user face it lets post here the possible reasons of crashing excel and find out the way to get rid of it. -- Regards Rajan verma +91 9158998701 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook

$$Excel-Macros$$ Replace a character to equal sign - VBA

2013-03-14 Thread André D'Avila
Guys, please help me. Inside VBA, i want to replace the character # below, to the equal sign... #Tech!$AB3 To =Tech!$AB3 Teoricaly is easy but the code doesnt work!!! Cells.select Selection.Replace What:=#, replacement:== -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

$$Excel-Macros$$ Excel 13 macros

2013-03-14 Thread Wayne Field
I moved up to Excel 13 less than a month ago with functioning spreadsheets. Last night Microsoft wiped out the sort macros on my most used spreadsheet. No problem; I'll just re-enter them. Oops, clicking MACTOS I find RECORD MACRO is greyed out. This sort macro sorts twice each of four

Re: $$Excel-Macros$$ Excel 13 macros

2013-03-14 Thread David Grugeon
What happens if you go Alt-F11 to open the VBE? Are macros enabled? Have a look at file/options/security (or could be .../advanced/security and look at macro security. Might alsoneed to look in Trust Centre Settings. All based on Office 2010 - but it is similar. My guess is that along with

Re: $$Excel-Macros$$ Required Macro for unique no

2013-03-14 Thread अनिल नारायण गवली
Dear Viney, GoodReally appreciate your first post . that good.Keep it up... Pls do helping to our forums Warm Regards. Gawli Anil On Thu, Mar 14, 2013 at 4:54 PM, Viney vineyme...@gmail.com wrote: Hi Shiva, this is my first post to the group... try this macro Sub