$$Excel-Macros$$ Intrinsic value calculator

2020-09-10 Thread Frank
Hi - Does anyone know if there is a intrinsic value calculator (DCF) out there that extracts all parameters automatically from Yahoo finance? -- 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://

Re: $$Excel-Macros$$ Re: how i convert pdf file to Excel using macro.

2016-09-07 Thread Frank Friedland
What's going on here Frank Friedland CEO DiningEdge www.diningedge.com 561-901-2324 > On Sep 7, 2016, at 5:39 AM, Pravin Lal wrote: > > Dear All, > > I have an urgent requirement to extract ONLY the tabluar data in a PDF into > excel. How can this be done??? Any tho

Re: $$Excel-Macros$$ Re: how i convert pdf file to Excel using macro.

2016-09-07 Thread Frank Friedland
Who are u Frank Friedland CEO DiningEdge www.diningedge.com 561-901-2324 > On Sep 7, 2016, at 5:39 AM, Pravin Lal wrote: > > Dear All, > > I have an urgent requirement to extract ONLY the tabluar data in a PDF into > excel. How can this be done??? Any thoughts? > >

$$Excel-Macros$$ sort on 3 columns

2016-01-26 Thread Frank V
Hi, automatic Sort with the macro recorder or normal sort with three levels do not give me the expected results. Sorting descending, between the same values in one column the other column is not sorting any more, until the value changed again. is there a routine already in VBA ? PS there is no

Re: $$Excel-Macros$$ Here is a Great Challenge - Retrieve data in from a multiple urls in one step

2014-05-15 Thread Frank Zolf
> Next > > ' For j = Range("a1048576").End(xlUp).Row To 1 Step -1 > ' If Range("a" & j).Value = "" Then Range("a" & j).EntireRow.Delete > ' Next > Application.ScreenUpdating = True > End Sub > > > On

$$Excel-Macros$$ Here is a Great Challenge - Retrieve data in from a multiple urls in one step

2014-05-13 Thread Frank Zolf
Hi Guys! Everyone is welcome. Here's the website for a Personal Weather Station in London: http://www.wunderground.com/personal-weather-station/dashboard?ID=IBUCKSIV1#history/data/s20100101/e20140513/mcustom It features a option to produce CSV data of any single day, in intervals of 5 minutes.

Re: $$Excel-Macros$$ Introduce Yourself !!

2014-05-13 Thread Frank Zolf
> > Hi All! > I am Franklin Zolf, data science phd, working on excel as a bridge to legacy in distributed systems. All my work is in data migration onto platforms for analysis and get-stun. I lasted worked with Excel in 2014 and am now getting back into it. We can help each other! I hope to

$$Excel-Macros$$ Re: how i convert pdf file to Excel using macro.

2014-01-25 Thread Frank Friedland
Hi I need someone to write macros for me, please email me. Best Frank On Saturday, February 19, 2011 2:17:51 AM UTC-5, rashid memon wrote: > Dear Experts, > > i want to convert PDF file to Excel so plz provide me macro > > file is attached... > > > Looking forward to rec

$$Excel-Macros$$ Hot Positions

2013-06-10 Thread Frank Innocent
ducts using J2EE and middleware technologies (IBM ESB MB/WTX) 5. Should be familiar with tools for SCM, defect tracking and deployment 6. Experience of working in onshore-offshore model preferred Frank Accentiqa group, Inc.(formerly, Affuel Systems Group Inc.,) 2475 Northwinds Pkwy Suit

$$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

2011-10-02 Thread Frank Linden
Thank you Noorain for working so hard to help all of us who need it. It is very much appreciated -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exce

Re: $$Excel-Macros$$ Need help on excel sheet

2010-12-01 Thread Frank Linden
the remaining sheet and that needs to be seperated in different individual sheet in my desktop or in a different file.   Thanks Manjunath On Tue, Nov 30, 2010 at 4:40 PM, Frank Linden wrote: Hello,   Do you mean that you want to collect the data on all 5 sheets and add it to a 6th sheet

Re: $$Excel-Macros$$ Need help on excel sheet

2010-11-30 Thread Frank Linden
Hello,   Do you mean that you want to collect the data on all 5 sheets and add it to a 6th sheet and then save the workbook with all 6 sheets? Or do you need to take the data from the 5 sheets and put it on one sheet, then saving a new workbook with only one sheet?       --- On Tue, 11/30/10, Man

Re: $$Excel-Macros$$ Parsing a range to an array

2010-10-30 Thread frank
Hello, You can also loop through the various selected areas and process the cells as needed. dim rngCell as Range For Each rngCell In Selection.Areas varXRange() = rngCell Next On Oct 28, 4:30 am, Dave Bonallack wrote: > Hi, > You can test for a non-contiguous selection with the followi

$$Excel-Macros$$ VBA Controls are missing for some users

2010-10-30 Thread frank
Hello, I added some controls to a worksheet and they work fine on some computers, but on other computers the controls are not visible. The controls are 2 Calendar 11 controls I inserted using the Insert - Object menu. There is also a combobox, a command button, and two checkboxes that were added

$$Excel-Macros$$ LookAt:=xlWhole back to LookAt:=xlPart

2009-11-02 Thread Frank V
LookAt:=xlWhole back to LookAt:=xlPart When running my macro what doing it job, preparing the copy area the "LookAt:=xlWhole" stays in place. When I do a find with ctrl+f and try a quick search with a part of a word, I must not forget to deactivate manually the identical option. Question how to