Excellent Victor, I will let you know, thanks Danny
> On Thursday 26 Aug 2010 16:44:04 Danny Kellett wrote: >> Hi Joe, >> >> Thanks for your email. I wanted to bypass any manual effort. Reason >> being >> is that I have people who are going out to customers collecting data and >> I >> don't want them to be exporting everytime another data collector adds to >> the SIT:Sites form. We are bringing on 2000 customers/companies. >> >> I just wanted the spreadsheet to dynamically data validate behind the >> scenes, thus the need for the function. >> >> Thanks anyway. I have Friday to play and try myself just wanted to know >> if >> anyone else had the vbs so I didn't have to ;) >> >> Cheers Anyway >> Danny >> >> -----Original Message----- >> From: Action Request System discussion list(ARSList) >> [mailto:[email protected]] On Behalf Of Joe D'Souza >> Sent: 26 August 2010 13:58 >> To: [email protected] >> Subject: Re: Site to Excel >> >> Export it from the User tool and instead of saving it as a regular arx >> format, choose .csv.. This would let you open the exported file in >> excel. >> >> Joe >> >> -----Original Message----- >> From: Action Request System discussion list(ARSList) >> [mailto:[email protected]]on Behalf Of Danny Kellett >> Sent: Wednesday, August 25, 2010 7:39 AM >> To: [email protected] >> Subject: SIT:Site to Excel >> >> >> Hi all, >> >> My VBA is not as strong as my C so before I break out the strong coffee, >> headache tables and VBA for Dummies guide, has anyone got a function to >> grab sites using ARODBC into Excel please? >> >> Thanks and kind regards >> Danny >> > Hello Danny, > > Please find included the code (grabbed from some Remedy List) that I > adopted > for my purposes. I'm sure you can easily adapt it also - but if not, fell > free > to contact me. > > HTH > > Victor > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
