Re: $$Excel-Macros$$ Req VBA Code

2012-06-13 Thread Veeru TOC
Dear Team I attached Excel file Sheet1 -Names,Sheet-2 form , when i click command button Create Particular Name with form -- *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** **

Re: $$Excel-Macros$$ Req VBA Code

2012-06-13 Thread Veeru TOC
Dear Nooran sir, thanks for Replay Ineed VBA Code for Thsi Particular sheet,, On Wed, Jun 13, 2012 at 12:24 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Veeru, See attachment, Hope it will help to you. On Wed, Jun 13, 2012 at 12:02 PM, Veeru TOC veerub

Re: $$Excel-Macros$$ Req VBA Code

2012-06-13 Thread Veeru TOC
: Dear Veeru, Please explain more, what you want exactly. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Wed, Jun 13, 2012 at 12:27 PM, Veeru TOC veerub...@gmail.com wrote: Dear Nooran sir, thanks for Replay Ineed VBA Code

$$Excel-Macros$$ extract data after space

2012-04-06 Thread Veeru TOC
-- Dear Excel Group How to extract data after space ,Plz find attachment,,, *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi

Re: $$Excel-Macros$$ extract data after space

2012-04-06 Thread Veeru TOC
On Fri, Apr 6, 2012 at 4:26 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Veeru, Please send attachement. On Fri, Apr 6, 2012 at 4:23 PM, Veeru TOC veerub...@gmail.com wrote: -- Dear Excel Group How to extract data after space ,Plz find attachment

Re: $$Excel-Macros$$ extract data after space

2012-04-06 Thread Veeru TOC
) -- Thanks regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Fri, Apr 6, 2012 at 4:29 PM, Veeru TOC veerub...@gmail.com wrote: On Fri, Apr 6, 2012 at 4:26 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote

Re: Fwd: $$Excel-Macros$$ VBA Classes

2012-04-05 Thread Veeru TOC
Venue,,, Plz,,, On Thu, Apr 5, 2012 at 12:30 PM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote: me tooo *From:* Lokesh Loki lokeshsmg2...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Wednesday, April 4, 2012 7:27 PM *Subject:* Fwd: $$Excel-Macros$$ VBA Classes Hi Experts,

Re: Fwd: $$Excel-Macros$$ VBA Classes

2012-04-05 Thread Veeru TOC
where , On Thu, Apr 5, 2012 at 3:08 PM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote: Delhi NCR *From:* Veeru TOC veerub...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thursday, April 5, 2012 12:57 PM *Subject:* Re: Fwd: $$Excel-Macros$$ VBA Classes Venue,,, Plz

Re: $$Excel-Macros$$ ****** FIVE YEARS COMPLETION******THANK YOU******

2012-03-26 Thread Veeru TOC
Congrats Every one sucessed On Thu, Mar 22, 2012 at 11:25 PM, xlstime xlst...@gmail.com wrote: Congratulation Dear Ayush and all group members On Thu, Mar 22, 2012 at 4:25 AM, Ayush Jain jainayus...@gmail.com wrote: Dear members,** I am proud to announce that the

$$Excel-Macros$$ Compress of images

2012-03-21 Thread Veeru TOC
Dear Group how to compress images -- *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-14 Thread Veeru TOC
Congrats Noorain Sir,, On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Noorain Ansari has been selected as 'Most Helpful Member' for the month of Feb'12 He has posted 156 posts in Feb'12 and helped many people through his

Re: $$Excel-Macros$$ images export in Excel with Image name and Hyperlink

2012-02-23 Thread Veeru TOC
@gmail.comwrote: Veeru, Attached file imports list for all files in a folder (which you would get to choose) and puts them in Column A with hyperlinks. Hope this helps. Credits to the original coder. Thanks, AJ On Thu, Feb 23, 2012 at 12:52 PM, Veeru TOC veerub...@gmail.com wrote

Re: $$Excel-Macros$$ images export in Excel with Image name and Hyperlink

2012-02-23 Thread Veeru TOC
. Veeru, I will have a look in your new requirement after a few hours though I am sure one of the experts from the group would address this by that time. Thanks Abhishek On Thu, Feb 23, 2012 at 1:58 PM, Veeru TOC veerub...@gmail.com wrote: Dear Abishek sir, It's thankfull u and i

$$Excel-Macros$$ images export in Excel with Image name and Hyperlink

2012-02-22 Thread Veeru TOC
Dear All, One folder of images export in Excel with Image name and Hyperlink,,-- *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near

Re: $$Excel-Macros$$ InternetExplorer-automation work-Some crtical

2012-02-16 Thread Veeru TOC
dguille...@gmail.com *From:* Veeru TOC veerub...@gmail.com *Sent:* Thursday, February 16, 2012 6:38 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ InternetExplorer-automation work-Some crtical* *** Dear All

$$Excel-Macros$$ I Macros tutorial software need

2012-02-16 Thread Veeru TOC
-- Dear group , Anybody have mererial for imacros . *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi

$$Excel-Macros$$ Error Code

2012-02-13 Thread Veeru TOC
Dear Group Below type of Error Code Display always what can i do ** ** -- *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi

$$Excel-Macros$$ Highest no with colour

2012-02-10 Thread Veeru TOC
Dear Group How to find Highest no with colour How its possible ,any formula.. -- Normal data: A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 393 Req Data:- A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 386 *ThanksRegards* * * *

Re: $$Excel-Macros$$ Highest no with colour

2012-02-10 Thread Veeru TOC
one among the column or row? and how 48 comes highest in E column ,kindly let us know On Fri, Feb 10, 2012 at 4:51 PM, Veeru TOC veerub...@gmail.com wrote: Dear Group How to find Highest no with colour How its possible ,any formula.. -- Normal data: A B C D E F Total 10

Re: $$Excel-Macros$$ Highest no with colour

2012-02-10 Thread Veeru TOC
) See attached sheet. On Fri, Feb 10, 2012 at 5:07 PM, Veeru TOC veerub...@gmail.com wrote: Sorry . i need Column Normal data: A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 386 . req data:- A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78

$$Excel-Macros$$ Get Text From A llWbs to sheet

2012-02-09 Thread Veeru TOC
Dear Group i can use below vba code get txt from All wbk to 1 sheet , Excel wbk name into A Coulumn how its possible VBA Code:- Sub GetTextFromAllWbs() Dim fpath As String fpath = C:\Users\VEERU\Desktop\dumps 'use filedialog to select a folder Dim

$$Excel-Macros$$ How to protect cells or formulas in excel sheets

2012-02-08 Thread Veeru TOC
Dear Team in excel file i know protect sheets but i need particular Cells put the code or protect how it possible VBA code also no problem -- *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** **

Re: $$Excel-Macros$$ How to protect cells or formulas in excel sheets

2012-02-08 Thread Veeru TOC
, protection tab, uncheck the locked status Now select only those cells that need to be protected, right click, format cell, protection tab, now check the locked status Finally, protect the sheet. now those cells cannot be editted. Sam Mathai Chacko On Wed, Feb 8, 2012 at 10:47 PM, Veeru TOC

Re: $$Excel-Macros$$ Re: Copy of excel files to 1 excel file with excel file name -Solve Problem

2012-02-03 Thread Veeru TOC
Dear Group One folder of some excel file is there ,every excel file has Time i nedd total folder excel file data copy 1 excel file but In start A column i need Excel name how is it possible plz find attachment of folder of excel files Req data

$$Excel-Macros$$ Re: Copy of excel files to 1 excel file -need vba code

2012-02-03 Thread Veeru TOC
Dear Group one folder of excel files copy to 1 excel file -plz need help *ThanksRegards* ** ***Veerendra.Vanam* *TOC TEAM* ***Bhagyanagar Electrical Contractors** H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

2012-02-02 Thread Veeru TOC
Congrats.. *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ** **H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* On Thu, Feb 2,

Re: Fwd: $$Excel-Macros$$ Re: Copy of excel files to 1 excel file with excel file name ,How it's possible

2012-02-02 Thread Veeru TOC
and then fill in col A with the name of the file or the name of sheet1. Please tell us exactly what you want. Don Guillett SalesAid Software dguille...@gmail.com *From:* Veeru TOC veerub...@gmail.com *Sent:* Thursday, February 02, 2012 5:11 AM *To:* excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Re: Copy of excel files to 1 excel file with excel file name ,How it's possible

2012-02-02 Thread Veeru TOC
Dear Group One folder of some excel file is there ,every excel file has Time i nedd total folder excel file data copy 1 excel file but In start A column i need Excel name how is it possible plz find attachment of folder of excel files Req data

Re: $$Excel-Macros$$ pdf to word document

2012-01-31 Thread Veeru TOC
Dear sir, how to convert pdf file to text file... On Tue, Jan 31, 2012 at 6:33 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Try this: ** ** Sub CreatePDF() ** ** Dim wksSheet As Worksheet For Each wksSheet In ThisWorkbook.Worksheets

$$Excel-Macros$$ Re: Solve problem,Plz help me

2012-01-31 Thread Veeru TOC
Dear group, Plz help me ... On Tue, Jan 31, 2012 at 8:32 PM, Veeru TOC veerub...@gmail.com wrote: Dear All, Can i use pivot table up to data came below type but i required this type of data Indus ID Alarm on Site Time IN-1008993 DG on Load 12:16:29

Re: $$Excel-Macros$$ pdf to word document

2012-01-31 Thread Veeru TOC
Thank you.. On Tue, Jan 31, 2012 at 8:01 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Veeru, You can download free pdf to text converter through below link.. http://www.pdf-to-html-word.com/pdf-to-text/ On Tue, Jan 31, 2012 at 7:47 PM, Veeru TOC veerub...@gmail.com wrote

$$Excel-Macros$$ Solve problem,Plz help me

2012-01-31 Thread Veeru TOC
Dear All, Can i use pivot table up to data came below type but i required this type of data Indus ID Alarm on Site Time IN-1008993 DG on Load 12:16:29 Mains Fail 12:14:59 IN-1009598 Mains Fail 19:56:46 19:56:56 Rectifier Fail 19:56:46 Req data: indus id Text IN-1008993 DG on load

$$Excel-Macros$$ Solve problem in excel

2012-01-31 Thread Veeru TOC
Dear All, Can i use pivot table up to data came below Indus ID Alarm on Site Time IN-1008993 DG on Load 12:16:29 Mains Fail 12:14:59 IN-1009598 Mains Fail 19:56:46 19:56:56 Rectifier Fail 19:56:46 But i need Requirement data type: indus id Text IN-1008993 DG on load

Re: $$Excel-Macros$$ Solve problem in excel

2012-01-31 Thread Veeru TOC
).Value rngSource.Offset(, 2).Text , Next rngSource Range(E4).Resize(lngCount + 1, 2).Value = strArray End Sub Regards, Sam Mathai Chacko On Tue, Jan 31, 2012 at 10:42 PM, Veeru TOC veerub...@gmail.com wrote: Dear All, Can i use pivot table up to data came below

Re: $$Excel-Macros$$ Solve problem in excel

2012-01-31 Thread Veeru TOC
be done. Regards, Sam Mathai Chacko On Tue, Jan 31, 2012 at 11:19 PM, Veeru TOC veerub...@gmail.com wrote: dear sir, can i this pivot tabel after use this vba code but use total vba code and get out put what my requirment data in vba codes On Tue, Jan 31, 2012 at 11:13 PM, Sam Mathai