Thank you Victor -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Victor Sent: Tuesday, August 31, 2010 1:49 PM To: [email protected] Subject: Re: Site to Excel
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" ********************************* This message and any attachments (the "message") are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. Messages are susceptible to alteration. France Telecom Group shall not be liable for the message if altered, changed or falsified. If you are not the intended addressee of this message, please cancel it immediately and inform the sender. ******************************** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
