$$Excel-Macros$$ need formula to extract on email ids

Hi All, need formula to extract on email ids Regards, Lucky -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN

Re: $$Excel-Macros$$ Salary sending problem

Hi Vaibhav, It's really unbelievable... Even I can also use your module for my salary details. :) Thanks a ton for such type of valuable post on group. Vaibhav, I need a small change in your macro, I always sent salary details to reporting managers and he/she forward the same to concern

$$Excel-Macros$$ any spread sheet to get P/E, P/BV, P/S, ROCE etc data for Indian stocks ?

Dear Members Are there any spread sheets or semi automatic / automatic ways to get the Price Earnings, Price by book, Price to Sales, ROCE etc data of Indian Stocks ? I recall reading something on this group about either XL sheets with Macros or XL sheets that helped download data from public

Re: $$Excel-Macros$$ Re: set my vba password through vba code

Hi Ayush thanx for reply. but can i protect my vba password. ( no one can break the password). Thanks Regards Dhartikumar On Sat, Dec 11, 2010 at 2:39 PM, Ayush jainayus...@gmail.com wrote: Hi Dharti, Good Question! I just did a quick check of the VBproject object model and don't find

Re: $$Excel-Macros$$ Error

Dave, Before that i used the concatenate function, so i want to autofill upto the adjacent column. Thanks, Vebhav Jain On Mon, Dec 13, 2010 at 8:32 AM, Dave Bonallack davebonall...@hotmail.comwrote: Hi Vebhav, You seem to be trying to autofill a range based on where the range currently

Re: $$Excel-Macros$$ Vlookup in Macro

U can use on error goto msg msg: Inputbox() On Dec 13, 9:52 am, Raj Mahapatra rajafs...@gmail.com wrote: hi Vaibhav, thanks for this. but i want to dispaly an input box as *lookfor is not in the rng* while there is error. On Fri, Dec 10, 2010 at 1:32 PM, in.vaib...@gmail.com wrote:

$$Excel-Macros$$ SMS through MS Excel

Excel Experts, Is it possible to send message (SMS) through MS Excel. If yes, Pls give me an idea or some sample macro file. Thanks, Manish Pansari -- -- Some important links for excel users: 1. Follow us on

RE: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 9 Messages in 6 Topics

I think that when info is added to a pivot table data source then the table is refreshed the items in the dropbox should display in alphabetical order, currently this does not happen and if you want it you have to re-make the table. From: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Macro to Sort

Hi, Is there a way or VBA Code that can prevent excel from saving. EG: if any value in cell A1 is not entered or Cell A1 is left blank , then i should not be able to save the excel and should get an error message Please enter value in A1 cell. Please help... really urgent. Thanks! Navneet

Re: $$Excel-Macros$$ Macro to Sort

Excel has Event macros. Open the VBA Editor. Select the 'Thisworkbook' module in the Project Explorer. In the VBA editor window, top-left there is a pull-down. Select Workbook the default event macro is the Open event. in the right-hand pulldown, select BeforeSave. In this macro, test for

Re: $$Excel-Macros$$ Error Handler

So.. your macro seems to be creating a new file with a name defined with wrkbk_nm1 Now, you want to check to see if the file exists and if it does, treat it as an Error? well.. the logic is somewhat odd, but I can at least point you in the right direction. Check out the FileSystem Object.

Re: $$Excel-Macros$$ Macro to Sort

Dear Navneet, Please do not post your questions in other topics in discussion and create a new post going forward as per the group policy. You have posted a query in Macro to Sort topic. This is definitely possible to prevent excel from saving if some condition is not met. You need to write code

Re: $$Excel-Macros$$ Re: set my vba password through vba code

Hi Dharti, There are softwares available which can crack your VBA password easily but if you make a complex password using combination of numeric, alphabets and special characters then I think it is difficult to break. I hope it answers your question. Feel free to write back in case of further

Re: Fwd: $$Excel-Macros$$ Skip blank cells while copying a list

Hi, Copy data in separate sheet, Then select all data in that coloumn, Now select blank cells, by pressing ctr + G (i.e. Goto) then select Blank Cells and Delete all Rows. Sent on my BlackBerry® from Vodafone -Original Message- From: Rajasekhar Praharaju

$$Excel-Macros$$ Re: Tab name changes, macro references old name

Thank you! Pete On Dec 11, 2:09 am, Ayush jainayus...@gmail.com wrote: Hi Pete, No Question is silly question... :) In case the sheet name changes, you can give reference of sheet index. Here is example: USE -- Sheets(3).Select The digit 3 is the 3rd sheet of the workbook. I hope

Re: $$Excel-Macros$$ Error Handler

Hello, Thank you for your reply is there any way where I can simplify this code. Thank you Chandra Shekar On Mon, Dec 13, 2010 at 7:39 PM, Paul Schreiner schreiner_p...@att.netwrote: So.. your macro seems to be creating a new file with a name defined with wrkbk_nm1 Now, you want to check

Re: $$Excel-Macros$$ Error Handler

Hello, I changed the code still its not working please let me know whats the problem is Sub create_wrkbk(ByRef wrkbk_nm As String) On Error GoTo errorhandler Application.DisplayAlerts = False Set fso = CreateObject(Scripting.FileSystemObject) ext_wrkbknm = Mid(wrkbk_nm, 1,

$$Excel-Macros$$ Outlook Folder Items Information

Hi Can any one let me know how to get the information about outlook folder items (Inbox) and get them in recordset. The below link may help. Please Check let me know.

RE: $$Excel-Macros$$ Error

Hi Vebhav, If the adjacent column you want is column 7, then try: Selection.AutoFill Destination:=Range(Cells(2, 8), Cells(Cells(Rows.Count, 7).End(xlUp).Row, 8)) I don't have a sample sheet, so I can't test it. Let me know if it works. If the adjacent column is not column 7, then change