Re: $$Excel-Macros$$ Microsoft Excel based application that digitizes data from pictures

2013-08-21 Thread Sam Mathai Chacko
Did you try http://www.ozgrid.com/Services/excel-charts-digitized.htm On Aug 21, 2013 11:04 AM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Respected Mog-Godiva, You can find the digitizer from the following links, http://digitizer.sourceforge.net/

Re: $$Excel-Macros$$ Charts Title Font Size Change via VBA

2013-08-21 Thread xlstime
Try This Sub Chart_Titles() Dim ch As ChartObject For Each ch In ActiveSheet.ChartObjects ch.Activate ch.Chart.ChartTitle.Select Selection.Format.TextFrame2.TextRange.Font.Name = Arial Selection.Format.TextFrame2.TextRange.Font.Size = 14 Next End Sub

Re: $$Excel-Macros$$ Charts Title Font Size Change via VBA

2013-08-21 Thread Prafull Jadhav
Thanks a lot Sir...It working Fine On Wed, Aug 21, 2013 at 1:12 PM, xlstime xlst...@gmail.com wrote: Try This Sub Chart_Titles() Dim ch As ChartObject For Each ch In ActiveSheet.ChartObjects ch.Activate ch.Chart.ChartTitle.Select

Re: $$Excel-Macros$$ How to split Data based on last comm,

2013-08-21 Thread Andrew Mangozho
Another simpler but rather long method to get the same result On Tue, Jul 30, 2013 at 4:31 AM, Waseem Saifi waseemsa...@gmail.com wrote: Dear Rajkumar, Please find attached file with solution. Regards, Waseem Saifi On Tue, Jul 30, 2013 at 3:48 PM, Raj Kumar rajlu...@gmail.com wrote:

Re: $$Excel-Macros$$ Sum between two different data.

2013-08-21 Thread अनिल नारायण गवली
Dear Manok, Find attached herewith . Warm Regards, Gawli Anil. Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Wed, Aug 21, 2013 at 2:30 PM, Manoj Kumar manoj.11...@gmail.com wrote: Please help me. I have a data like details mention below. xxx

Re: $$Excel-Macros$$ How to split Data based on last comm,

2013-08-21 Thread अनिल नारायण गवली
Dear Rajkumar, U can use text to columns option . click on comma checkbox and finish it. Warm Regads, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Wed, Aug 21, 2013 at 2:42 PM, Andrew Mangozho andrew.mango...@gmail.com wrote: Another

Re: $$Excel-Macros$$ How to split Data based on last comm,

2013-08-21 Thread Andrew Mangozho
Yes, thats great and faster. On Wed, Aug 21, 2013 at 2:36 AM, अनिल नारायण गवली gawlianil8...@gmail.comwrote: Dear Rajkumar, U can use text to columns option . click on comma checkbox and finish it. Warm Regads, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer,

Re: $$Excel-Macros$$ Charts Title Font Size Change via VBA

2013-08-21 Thread Prafull Jadhav
Dear Sir, I have querys 1) I have not used Dim Declaration and run below vba it working fine.. is there need to use Dim here? Dim x As ChartObject For Each x In ActiveSheet.ChartObjects x.Activate x.Chart.ChartTitle.Select Selection.Format.TextFrame2.TextRange.Font.Name = Arial

$$Excel-Macros$$ help needed urgent

2013-08-21 Thread thameem
Dear all, file is in server, but no one is using that file, but stil showing file is use.. please help me wat to do... -- 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 page of this forum @

Re: $$Excel-Macros$$ help needed urgent

2013-08-21 Thread vba
See any hidden temp file is created or not. Try revoking shared access for particular folder n re share. Thanks On 21 Aug 2013 17:26, thameem thamee...@gmail.com wrote: Dear all, file is in server, but no one is using that file, but stil showing file is use.. please help me wat to do... --

Re: $$Excel-Macros$$ How to split Data based on last comm,

2013-08-21 Thread De Premor
Another simple and short =TRIM(RIGHT(SUBSTITUTE(A2,,,REPT( ,99)),99)) Pada 21/08/2013 16:12, Andrew Mangozho menulis: Another simpler but rather long method to get the same result On Tue, Jul 30, 2013 at 4:31 AM, Waseem Saifi waseemsa...@gmail.com mailto:waseemsa...@gmail.com wrote:

Re: $$Excel-Macros$$ help needed urgent

2013-08-21 Thread thameem
thanks.. its done On Wed, Aug 21, 2013 at 4:05 PM, vba v...@vabs.in wrote: See any hidden temp file is created or not. Try revoking shared access for particular folder n re share. Thanks On 21 Aug 2013 17:26, thameem thamee...@gmail.com wrote: Dear all, file is in server, but no one is

Re: $$Excel-Macros$$ I need to delete entire rows which contain exact matches from a static list on a seperate sheet

2013-08-21 Thread svenyarl
I sample of the file I receive is as follows: 25727861 GM DLT 1 20130716 17091432 GM NS 8 20121227 12527740 GM NS 8 20121221 10328906 GM NS 0 89018306 GM NS 12 12617309 GM RB 44 12365265 GM NS 10 20121026 12588318 GM RB 18 20120301 16631629 GM NS 11 the comparing file is

Re: $$Excel-Macros$$ Microsoft Excel based application that digitizes data from pictures

2013-08-21 Thread Mog Godiva-Man
Yes Thanks guys. this was very helpful. On Wed, Aug 21, 2013 at 1:49 AM, Sam Mathai Chacko samde...@gmail.comwrote: Did you try http://www.ozgrid.com/Services/excel-charts-digitized.htm On Aug 21, 2013 11:04 AM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Respected Mog-Godiva, You can find

$$Excel-Macros$$ Re: clubbing 200 excel files

2013-08-21 Thread svenyarl
Try the following macro. Sub Macro1() For i = 2 To 200 Sheets(i).Select Range(A1:M99).Select Selection.Copy Sheets(Sheet1).Select Range(A CStr(i * 100)).Select ActiveSheet.Paste Next i End Sub On Saturday, August 17, 2013

Re: $$Excel-Macros$$ Formula or UDF to do Vlookup for values delimited with ]

2013-08-21 Thread prkhan56
Thanks De Premor, Your code works on any sheet. Regards Rashid Khan On Wednesday, August 21, 2013 3:22:48 AM UTC+4, De Premor wrote: try to replace current code with this Function LookForCode(Str As String, Data As Range, Colx As Integer, Optional Delim As String = ]) Dim Kode, Tmp As

Re: $$Excel-Macros$$ Formula or UDF to do Vlookup for values delimited with ]

2013-08-21 Thread prkhan56
Hello Ravinder, I have installed the Add-In as per your instruction but unfortunately it only works on the *Active Sheet* and not on any other sheet. Please see if you could test your Add-in and fix the problem. Thanks for your time and help once again. Rashid Khan On Wednesday, August 21, 2013

$$Excel-Macros$$ Extract Names which are not common

2013-08-21 Thread santosh subudhi
Hi Group, Is it possible to extract the data which are not common between two coloums Attached is sample sheet with problem -- Regards Santosh santoshkumar.subu...@gmail.com -- 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

Re: $$Excel-Macros$$ I need to delete entire rows which contain exact matches from a static list on a seperate sheet

2013-08-21 Thread अनिल नारायण गवली
Dear svenyarl, Pls share a worksheet with us. Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Wed, Aug 21, 2013 at 8:13 PM, sveny...@gmail.com wrote: I sample of the file I receive is as follows: 25727861 GM DLT 1