Re: $$Excel-Macros$$ Re: how to crack Excel VBA password

2014-02-28 Thread nitin kumar
Dear Elis, below software is not working not showing the password can u find the the password of attached file password. please... Regards, Nitin Kumar +91 9784363535 Pfa, Regards, Nitin Kumar On Fri, Feb 21, 2014 at 6:08 PM, elis smith elissmit...@gmail.com wrote: * You can use Excel

$$Excel-Macros$$ Hyperlink formula for horizontal Search

2014-02-28 Thread amar takale
Dear All Experts I required Hyperlink formula for horizontal Search.If I show my criteria click then search that specific name in column means go to direct that specific Column Regards Amar -- 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) !

RE: $$Excel-Macros$$ Hyperlink formula for horizontal Search

2014-02-28 Thread Ravinder
PFA... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Friday, February 28, 2014 3:18 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Hyperlink formula for horizontal Search Dear All Experts I required Hyperlink

Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search

2014-02-28 Thread Prafull Jadhav
Great Ravinder Sir.. Regards, Prafull Jadhav 9920553518 On 28 February 2014 15:33, Ravinder ravinderexcelgr...@gmail.com wrote: PFA. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *amar takale *Sent:* Friday, February 28, 2014 3:18 PM

Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search

2014-02-28 Thread Ashish Kumar
Hi Ravinder Sir, OWSOME..!!! On 28 February 2014 15:33, Ravinder ravinderexcelgr...@gmail.com wrote: PFA. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *amar takale *Sent:* Friday, February 28, 2014 3:18 PM *To:*

RE: $$Excel-Macros$$ Hyperlink formula for horizontal Search

2014-02-28 Thread Ravinder
Thanks dear.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prafull Jadhav Sent: Friday, February 28, 2014 3:44 PM To: excel-macros@googlegroups.com Cc: Soum Subject: Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search Great Ravinder Sir..

Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search

2014-02-28 Thread priti verma
you can also try this without vba please see attach file. On Fri, Feb 28, 2014 at 2:25 AM, Ravinder ravindervbacli...@gmail.comwrote: Thanks dear *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Prafull Jadhav *Sent:* Friday, February 28,

Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search

2014-02-28 Thread amar takale
Dear Raviderji Priti Thank very much for nice solution. Priti madam,can you explain me Define name formula.in which why we get 1,if change it then formula destroy link? And how to link this to button.Pls explain me Regards Amar On Fri, Feb 28, 2014 at 4:38 PM, priti verma

Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search

2014-02-28 Thread Prafull Jadhav
Dear Madam, I also trying the same but not able to understand the same. It will be better if you explain the same... Thanks in Advance ...Madam Regards, Prafull Jadhav 9920553518 On 28 February 2014 17:09, amar takale amartak...@gmail.com wrote: Dear Raviderji Priti Thank very much

Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search

2014-02-28 Thread priti verma
Hi Amar, it is simple index match formula and 1 indicates row number. please go over this for more clarification. https://sites.google.com/site/e90e50fx/home/Excel-Hyperlink-to-a-dynamic-range -- 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) !

Re: $$Excel-Macros$$ Run macro when file is opened by another excel file?

2014-02-28 Thread Paul Schreiner
Where did you place the Private Sub Workbook_Open macro?   (It belongs in the Thisworkbook module) also, instead of having the user enter the version number, why not have the macro READ the number? (that is, unless the name of the original file (File A) changes) also: what I have done is

$$Excel-Macros$$ Array from range

2014-02-28 Thread Gerrit Grundling
Greetings, all What am I doing wrong here? I am trying to create an array from a range, but keep getting the Run-time error '9': Subscript out of range warning. TIP = Application.WorksheetFunction.CountA(ActiveSheet.Range(D19:D1048576 )) 'Counts the number of active rows below the first

$$Excel-Macros$$ Want to Embed flash game in Excel

2014-02-28 Thread Waseem Saifi
Hi Friends, I want to embed flash games in Excel 2007. I have a flash game. It is to be noted that game's extension is exe, not swf. If it possible, please help me. Thanx in advance, Regards, Waseem Saifi -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's

$$Excel-Macros$$ Re: Long if-then function? HELP

2014-02-28 Thread Sara C
Ha, Paul found a typo in my code that solved my problem... phew! On Tuesday, February 25, 2014 3:45:33 PM UTC-5, Sara C wrote: Hi, I'm using a VBA macro for an invoice for a service, where the price per hour of the service depends on 4 variables: location, type of worker, time of service,

Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search

2014-02-28 Thread Prafull Jadhav
Dear Priti Madam, Very good morning, Since morning i am trying to understand the hyperlink Goto name but i don't understand . Please explain me how you have hyperlink the same . i got below points 1) what does the index and match formula in this sheets that is goto 2)Name - is used for data

Re: $$Excel-Macros$$ Database Query Macro- Password Prompt - Excel

2014-02-28 Thread ashish koul
try ths http://www.mrexcel.com/forum/excel-questions/548342-embed-password-visual-basic-applications-odbc-connection.html On Wed, Feb 26, 2014 at 7:59 PM, pranav patil patilprana...@gmail.comwrote: I have created an Excel sheet that retrieves data from a ODBC source. I have created a macro

Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search

2014-02-28 Thread priti verma
Hi Prafull, we can create a hyperlink with a particular range or a static name range. if you have a dynamic name range it does not show in hyperlink dialogue box . if you want to create a dynamic hyperlink follow these steps 1- create a name range which refers any cell like (a1 or a2 ...)--it is