Re: $$Excel-Macros$$ How to learn VSTO with excel.

Hi, MSDN library would help... see the below link:- http://msdn.microsoft.com/en-us/vsto/dd162436 Best Regards, DILIPandey On 6/22/11, Mr excel excelkeec...@gmail.com wrote: hi all, I want to learn VSTO for excel.anybody please give me the notes,pdf or urls for learning. thanks

$$Excel-Macros$$ Extract only 10 digit mobile number

Dear Expert, I need your help because I have more data of Multiple format. I want extract only 10 digit mobile number. Please find enclose example file. -- -- One Team One Dream One Goal Warm Regards, Brajesh 7503020750 Life is Very beautiful !!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep

$$Excel-Macros$$ Sort TCP/IP Address in Excel

Are you a reporting analyst in IT firm, network engineer, networking analyst or any one who works on network data? If yes, then you ever tried to sort TCP/IP Addresses, I'm sure something like red list in this figure, would have happened and you must have desired the green list. This is the

Re: $$Excel-Macros$$ Private sub selection-change preventing copy paste

Hi Vasant Thanks for your reply.I don't know exactly what is flag in VBA, however I think it is something like a condition. Within in my limitation I just modify the code. Private Sub Worksheet_SelectionChange(ByVal Target As Range) if range(AH1)0 then Application.EnableEvents = False

Re: $$Excel-Macros$$ Extract only 10 digit mobile number

Hi Ashish, i have below code but i dont know whts the wrong with this. please chekc and guide me thansk for you continues help. Thanks, Rakesh. *Sub mobile() Dim i As Integer Dim strPath Dim strFile Dim UB For i = 1 To 400 strPath = Cells(i, 1) strFile = Split(strPath, .) UB = UBound(strFile)

Re: $$Excel-Macros$$ Sort TCP/IP Address in Excel

Thanks Ashish for sharing this. Really very informative (Infact the website itself contains huge information on VBA). Hope to see something for sorting on Numbers... Thanks, Anish On Fri, Jun 24, 2011 at 3:29 PM, OpenExcel.com 26may.1...@gmail.com wrote: Are you a reporting analyst in IT

$$Excel-Macros$$ Excel macro errror

-- please help while i m coding new xl fine in 2007 getting below errorr what to do. attached is the error Rakesh Joshi -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

$$Excel-Macros$$ Save file

Hi, How to save excel files in a different workstation (LAN ) which is password protected. Thanks, Chandra Shekar B -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

RE: $$Excel-Macros$$ Save file

Copy and Paste From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Friday, June 24, 2011 5:02 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Save file Hi, How to save excel files in a different workstation (LAN )

Re: $$Excel-Macros$$ Save file

I need thru VBA. On Fri, Jun 24, 2011 at 7:21 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Copy and Paste ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar *Sent:* Friday, June 24, 2011 5:02 PM *To:*

Re: $$Excel-Macros$$ Protect : Charts, Shapes Data

I am blocked from attaching a file I guess. Not sure why. So here's how you do it. 1. Hold CTRL and right-click on the button shape as well as the chart. Go to format and properties, and then uncheck the lock 2. After deselecting the shapes, select only the button, again go to format and