$$Excel-Macros$$ Re: UserForm objects/controls collections?

2009-04-06 Thread Raymond Mills
hi, I have a better way If you have a series of controls that you would like to format the same way...suggest you name the textbox "txtbxname_1" ("_1") becomes our unique identifyer) for each. if right(object.name,4) = "_1" then next next On Sun, Apr 5, 2009 at 8:46 PM, Ashish Ja

$$Excel-Macros$$ Re: Connecting with yahoo finance servers

2009-04-06 Thread Raymond Mills
Hi, I must say I am interested in your project... I worked on this exact task this past weekend. I use a web query function to extract the data (I munipulate the url to adj the data date range and symbol) and if the data comes back in an unusual/unexpected format...i consider it a fail and react a

$$Excel-Macros$$ PDF into excel???

2009-04-04 Thread Raymond Mills
Hello All 1. I need to convert and import some P&L .pdf files into excel 2. I have acrobat professional and have been converting the files into xml or txt (open with vba and do a sanve as) but the results are very inconsistent... 3. I dont want to buy a 3rd party tool 4. I want to do it all u