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

2013-12-05 Thread Ricky Youngblood
Hello Everyone, I am young & dumb Figured i would start trying to look for more help than google.com offers. At first i was .. iffy about posting much but honestly felt retarded after seeing the great reply's i received. I have 2 degrees that I hate and wish i had picked another path in li

$$Excel-Macros$$ Need Help - working code - but basic

2013-12-05 Thread Ricky Youngblood
Could someone write a somewhat dummy down version of looping and integers guide? Been learning Vba on the fly and the this code makes me sick. No need to do all the work. I rather just have the tools to learn and do myself. I have been Googling non-stop and have had no luck on finding something

Re: $$Excel-Macros$$ Please help on FileName = Dir()

2013-12-05 Thread maksood alam
Hi Paul, Thank you very much. It solved my query. [?] Regard, Maksood Alam On Thu, Dec 5, 2013 at 5:59 PM, Paul Schreiner wrote: > In your script, you have a line: > FileName = Dir(CurrDir & "*.*", vbDirectory) > This basically creates a "collection" of information from "CurrDir". > vbDirector

Re: $$Excel-Macros$$ Please help on FileName = Dir()

2013-12-05 Thread Paul Schreiner
In your script, you have a line: FileName = Dir(CurrDir & "*.*", vbDirectory) This basically creates a "collection" of information from "CurrDir". vbDirectory indicates that it is to return "directories or folders in addition to files with no attributes".   the statement itself returns the first e

$$Excel-Macros$$ VBA macro to replace Index and Match formula

2013-12-05 Thread ncliew
Hello, I'm new here and need some help. I need to perform stock analysis regularly, which involves the use of files with data in multiple columns and more than 100K lines of records. To provide a better illustration of the routine tasks I perform, I've attached a file for simulation purpos