$$Excel-Macros$$ Files / Folders Sharing Query - reg.

2013-07-10 Thread Pravin Gunjal
Dear Premor, I could able to learn something about VBA-Macros after joining this group only.. and before that even I didn't think that it that excel could do such a nice work for users. As I do not know in deep about VBA, I would request you to please do me a favor in this regard. Thank you, Re

Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg.

2013-07-10 Thread De Premor
Why didn't you write your own code, i was send enoughsample code for create that, i think this is the time for you to find your own fish. Rgds, [dp] Pada 11/07/2013 12:08, Pravin Gunjal menulis: Dear Premor, Before save code is working fine and creating a backup, if you arrange the same code

Re: $$Excel-Macros$$ Copy value from Object

2013-07-10 Thread Santy
Dear Ashish/Basole, Thanks for quick response; I really appreciate your efforts, I think how to copy web page to excel ( I tried via “Get External data from web” excel option but unable to fetch ActiveX control) Basically I want go to web page then select all value (using ctrl +a) then pa

Re: $$Excel-Macros$$ Simple formula required

2013-07-10 Thread ashish koul
=TRIM(RIGHT(D3,LEN(D3)-FIND(")",D3))) Regards Ashish Koul On Wed, Jul 10, 2013 at 4:20 PM, Prafull Jadhav wrote: > Dear Amar, > > find the same with easy...by using mid function. > Regards > Prafull > > > On Wed, Jul 10, 2013 at 3:51 PM, Anil Kumar wrote: > >> >>

Re: $$Excel-Macros$$ Copy value from Object

2013-07-10 Thread ashish koul
try this Sub Loopobjects() Dim OleObj As OLEObject Dim sel_d, val_s Dim Arr Dim ArrMatch Dim lngSelected As Long For Each OleObj In Sheet1.OLEObjects If OleObj.progID = "Forms.HTML:Text.1" Then Sheets(1).Cells(OleObj.TopLeftCell.Row, 12) = OleObj.Object.

Re: $$Excel-Macros$$ Copy value from Object

2013-07-10 Thread Basole
See if that is what needs: http://www.homeandlearn.co.uk/excel2007/excel2007s8p4.html Em quarta-feira, 10 de julho de 2013 09h51min06s UTC-3, Santy escreveu: > > Hi, > > I need help urgently > > how to copy value from an object (i have copy objects from web page) > > > > > Thanks in advance >

$$Excel-Macros$$ Copy value from Object

2013-07-10 Thread Sant Ram
Hi, I need help urgently how to copy value from an object (i have copy objects from web page) Thanks in advance -- Regards, Santy -- 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 @ https://www

$$Excel-Macros$$ Re: Repost: Excel initiating export from Crystal report

2013-07-10 Thread sandeep shivpujan singh
Probably its too latestillI was searching for some code related to Crystal Report and found your post. :) This code might help ( you need to set reference to Crystal Reports ActiveX designer Design and Runtime Library 11.0 or above) Sub CrystalRPTtoXLS() On Error GoTo ERRMSG Dim Appl

Re: $$Excel-Macros$$ Vlookup function using with match & columns

2013-07-10 Thread Prafull Jadhav
Dear Murli, You can just give ref of column,,, for example if you want B column then put (B:B). =VLOOKUP($L24,$A$3:$D$6,COLUMN(B:B),0) On Wed, Jul 10, 2013 at 4:43 PM, Muralidhar E wrote: > Hi, > Dear friends, > > Thank u > > With the same i want to know using column & columns > > *2.Thi

Re: $$Excel-Macros$$ Vlookup function using with match & columns

2013-07-10 Thread Muralidhar E
Hi, Dear friends, Thank u With the same i want to know using column & columns *2.This is using columns or column function* =vlookup(lookup_value, Table array,*columns or column(array)*,range lookup). I want to know how can we use both these functions. 1. Shall we can get the left side result

Re: $$Excel-Macros$$ Error in output

2013-07-10 Thread sandeep shivpujan singh
Hi, The empty value is because you have not given any criteria when the match is not found. For Example : Use this : =IF(ISERROR(MATCH(C1,$E$1:$E$99,0)),"Not Found",C1) Currently none of the values which you have in Column "C" are present in Column "E" Regards, Sandeep On Wednesday, 10 Ju

Re: $$Excel-Macros$$ Vlookup function using with match & columns

2013-07-10 Thread Prafull Jadhav
Dear Murli, Find the same Regards, Prafull Jadhav. On Wed, Jul 10, 2013 at 3:59 PM, Muralidhar E wrote: > Dear friends, > > Good afternoon, > > I need a help and I want to know how to use vlookup function by using > match and columns function. How it is works? > Plz, share with me. > > *1.This

Re: $$Excel-Macros$$ Simple formula required

2013-07-10 Thread Prafull Jadhav
Dear Amar, find the same with easy...by using mid function. Regards Prafull On Wed, Jul 10, 2013 at 3:51 PM, Anil Kumar wrote: > > -- > *From:* amar takale > *To:* excel-macros@googlegroups.com > *Sent:* Tuesday, 4 September 2012 2:01 PM > *Subject:* $$Excel-Macr

Fwd: $$Excel-Macros$$ Vlookup function using with match & columns

2013-07-10 Thread Muralidhar E
Dear friends, Good afternoon, I need a help and I want to know how to use vlookup function by using match and columns function. How it is works? Plz, share with me. *1.This is using match function* =vlookup(lookup_value,Table array*,match(lookup_value,lookup_array,match type),*range lookup). *2

Re: $$Excel-Macros$$ Simple formula required

2013-07-10 Thread Anil Kumar
From: amar takale To: excel-macros@googlegroups.com Sent: Tuesday, 4 September 2012 2:01 PM Subject: $$Excel-Macros$$ Simple formula required -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel   FORUM RULES (1120+ memb

$$Excel-Macros$$ Vlookup function using with match & columns

2013-07-10 Thread Muralidhar E
Dear friends, Good afternoon, I need a help and I want to know how to use vlookup function by using match and columns function. How it is works? Plz, share with me. *1.This is using match function* =vlookup(lookup_value,Table array*,match(lookup_value,lookup_array,match type),*range lookup). *2