Hi Strad, > I think I said in my first post this is to connect a > program called wealth-lab www.wealth-lab.com, that's > written in Deplhi code to Excel via an activex script.
You said it needed to connect to www.wealth-lab.com - I was under the impression you were 'scraping' content from a website. > Wealth lab is a Backtesting software progam for stocks with > its own language ( wealth script) you program a file it > executes the instructions. What are the capabilities of 'wealth script'? Is it primarily intended simply to shell out to an exe with certain parameters? Is it a full featured scripting language with objects, events and activex support? Without knowing exactly what you intend to do it's hard to provide a more exact method to solve the problem, but I personally would never use Excel automation on an 'every five minutes' basis. That's just asking for a bug in your code to shut down the computer with out of memory errors at 2pm, right in the middle of the processing each day. I would still recommend ADO, in fact, with this new understanding of your needs I'd go as far as saying you're better off stuffing the data into an MS Access database via ADO and then having the excel spreadsheets yank the data out of Access when the spreadsheets are opened on the client side. This would provide several benefits: @ single storehouse of 'live' data for more than one client system @ ongoing records, not limited by date @ (assuming you need to create graphs) graphs are not limited to one day or even one week - but can be mapped to the whole scope of your collected data @ ADO connection pooling/caching would alleviate object issues @ using an excel spreadsheet for the front-end lets you 'prettify' the actual display of collected data on open, making it possible to generate a very nice layout for screen and print, and generate graphs in real time @ assuming you were interested, the ADO data for specific stocks could be used in pattern analysis to see what their likely range is and when their peaks and valleys would make them most worthy of exchange Regards, Shawn K. Hall http://12PointDesign.com/ http://ReliableAnswers.com/ '// ======================================================== "I've had my share of dirty underwear on the floor." -- Martha Stewart '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [email protected] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
