>
>
>
>
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>
>
> *From:* Veeru TOC
>
> *Sent:* Thursday, February 16, 2012 6:38 AM
>
> *To:* excel-macros@googlegroups.com
>
&
-- Dear group ,
Anybody have mererial for imacros .
*Thanks&Regards*
* *
* **Veerendra.Vanam*
*TOC TEAM*
* * *Bhagyanagar Electrical & Contractors**
****H.No-5-9-286/65,Plot No-65
Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukat
Dear All,
One folder of images export in Excel with Image name and
Hyperlink,,--
*Thanks&Regards*
* *
* **Veerendra.Vanam*
*TOC TEAM*
* * *Bhagyanagar Electrical & Contractors**
****H.No-5-9-286/65,Plot No-65
Rajiv Gandhi Nagar,Near
wrote:
>
>> 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.
>>
>
eeru, 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 wrote
Congrats Noorain Sir,,
On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain 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
> expertise. He has been co
Dear Group
how to compress images
--
*Thanks&Regards*
* *
* **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,
Congrats Every one sucessed
On Thu, Mar 22, 2012 at 11:25 PM, xlstime wrote:
> Congratulation Dear Ayush and all group members
>
> On Thu, Mar 22, 2012 at 4:25 AM, Ayush Jain wrote:
>
>> Dear members,**
>>
>>
>>
>> I am proud to announce that the forum has completed 5 year
Venue,,, Plz,,,
On Thu, Apr 5, 2012 at 12:30 PM, LAKSHMAN PRASAD wrote:
> me tooo
>
> *From:* Lokesh Loki
> *To:* excel-macros@googlegroups.com
> *Sent:* Wednesday, April 4, 2012 7:27 PM
> *Subject:* Fwd: $$Excel-Macros$$ VBA Classes
>
> Hi Experts,
>
> May i know that is there any Excel &
where ,
On Thu, Apr 5, 2012 at 3:08 PM, LAKSHMAN PRASAD wrote:
> Delhi NCR
>
>
> *From:* Veeru TOC
> *To:* excel-macros@googlegroups.com
> *Sent:* Thursday, April 5, 2012 12:57 PM
> *Subject:* Re: Fwd: $$Excel-Macros$$ VBA Classes
>
> Venue,,, Plz,,,
--
Dear Excel Group
How to extract data after space ,Plz find
attachment,,,
*Thanks&Regards*
* *
* **Veerendra.Vanam*
*TOC TEAM*
* * *Bhagyanagar Electrical & Contractors**
****H.No-5-9-286/65,Plot No-65
Rajiv Gandhi Nagar,N
On Fri, Apr 6, 2012 at 4:26 PM, NOORAIN ANSARI wrote:
> Dear Veeru,
>
> Please send attachement.
>
>
> On Fri, Apr 6, 2012 at 4:23 PM, Veeru TOC wrote:
>
>>
>>
>> --
>> Dear Excel Group
>>
>>
>>
t;,A2,1)-1)
>
>
> --
> 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 wrote:
>
>>
>>
>> On Fri, A
> Dear Team
>
>
> I attached Excel file Sheet1 -Names,Sheet-2 form , when
> i click command button Create Particular Name with form
> --
>
>
>
>
>
> *Thanks&Regards*
>
> * *
>
> * **Veerendra.Vanam*
>
> *TOC TEAM*
> * * *Bhagyanagar Electrical & Contractors**
> **
Dear Nooran sir,
thanks for Replay Ineed VBA Code for Thsi Particular
sheet,,
On Wed, Jun 13, 2012 at 12:24 PM, NOORAIN ANSARI
wrote:
> Dear Veeru,
>
> See attachment, Hope it will help to you.
>
>
> On Wed, Jun 13, 2012 at 12:02 PM, Veeru TOC wrote:
&
eru,
>
> 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 wrote:
>
>> Dear Nooran sir,
>>
&
; Next cell
> End Sub
> *
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
> On Wed, Jun 13, 2012 at 12:41 PM, Veeru TOC wrote:
>
>> Dear Sir
>>
>>Sheet 1 have particular names in sheet
Dear sir,
how to convert pdf file to text file...
On Tue, Jan 31, 2012 at 6:33 PM, Rajan_Verma wrote:
> Try this:
>
> ** **
>
> Sub CreatePDF()
>
> ** **
>
> Dim wksSheet As Worksheet
>
> For Each wksSheet In ThisWorkbook.Worksheets
>
> wksSheet
Dear group,
Plz help me ...
On Tue, Jan 31, 2012 at 8:32 PM, Veeru TOC 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 L
Thank you..
On Tue, Jan 31, 2012 at 8:01 PM, NOORAIN ANSARI wrote:
> 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
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
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 12:16,Mains
strArray(lngCount, 0) = rngSource.Value
> End If
> strArray(lngCount, 1) = strArray(lngCount, 1) & rngSource.Offset(,
> 1).Value & " " & rngSource.Offset(, 2).Text & ","
> Next rngSource
> Range("E4").Resize(lngC
> Regards,
>
> Sam Mathai Chacko
>
>
> On Tue, Jan 31, 2012 at 11:19 PM, Veeru TOC 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
>>
>>
Congrats..
*Thanks&Regards*
* *
* **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,
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
*Thanks&Regards*
* *
file 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
> *Sent:* Thursday, February 02, 2012 5:11 AM
> *To:* excel-mac
>
>
>> 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
>>
>
>
>
>>
>>
>>> 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
>
>> Dear Group
>>>
>>>
>>>
>>>
>> one folder of excel files copy to 1 excel file -plz need help
>
>>>
>>> *Thanks&Regards*
>>>
>>> **
>>>
>>> ***Veerendra.Vanam*
>>>
>>> *TOC TEAM*
>>> ***Bhagyanagar Electrical & Contractors**
>>> H.No-5-9-286/65,Plot No-65
>>> Rajiv Gandhi Nagar,Near Andhra
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
--
*Thanks&Regards*
* *
* **Veerendra.Vanam*
*TOC TEAM*
* * *Bhagyanagar Electrical & Contractors**
**
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
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
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
*Thanks&Regards*
* *
* **Veerendr
umn 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 wrote:
>
>>
>> Dear Group
>>
>>
>> How to find Highest no with colour How its possible ,any
>> formula..
>&g
-- Dear Team
In my excel sheet i have below type of data i need Highest no with
Colour , pls send VBA Code
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
$3)
>
> See attached sheet.
>
> On Fri, Feb 10, 2012 at 5:07 PM, Veeru TOC 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 .
>>
&
Dear Group
Below type of Error Code Display always what can i
do
** **
--
*Thanks&Regards*
* *
* **Veerendra.Vanam*
*TOC TEAM*
* * *Bhagyanagar Electrical & Contractors**
****H.No-5-9-286/65,Plot No-65
Rajiv Gandhi Nagar
38 matches
Mail list logo
