On Fri, Dec 4, 2009 at 8:21 AM, Peter Hart <[email protected]> wrote: > Hi all
> My Daughter has started working at a large company in London. Although > she got a first class honours in financials she was never taught how to > use excel in anything more than a superficial way. > > Her manager is expecting more from her than she is capable of. The girl > is worrying too much about this. > > The Company uses SAP and a particular application called Business > Objects. She has managed to do a query and produce a report in Business > Objects then use (Paste Special) to get the data into Excel. However > the manager want her to write a macro so that when he opens up the sheet > it shows the new query. She seems to have to do a new query then paste > special each time to get it into excel. ------------------------- BO = Crystal Reports or one of another set of reporting tools. You could put the query in Excel data | External Data | Import External Databse Query. -- Stephen Russell Sr. Production Systems Programmer SQL Server DBA Web and Winform Development Independent Contractor Memphis TN 901.246-0159 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
