Re: How to copy a range from closed workbook

Email lists > MS Excel Questions and Answers

Thread: Re: How to copy a range from closed workbook

Search this list only Search all lists
Re: How to copy a range from closed workbook
	2007-04-12 09:01:48
Here is the problem: I need to grab data from different file based on whatever the user wants. So, he/she may want 04_01_2007 data or 04_06_2007 data. I don't think there is an easy way to do an automatic refresh. Please be more specific. Thanks. -----Original Message----- From: MS Excel General Q & A List [mailto:EXCEL-GPEACH.EASE.LSOFT.COM] On Behalf Of Longworth, Damon Sent: Wednesday, April 11, 2007 4:30 PM To: EXCEL-GPEACH.EASE.LSOFT.COM Subject: Re: How to copy a range from closed workbook Update the link? The queries have an automatic refresh. Damon Longworth - Microsoft Excel MVP Lake Regional Medical Management Central Business Office dlongworthATlakeregional.com Tel 573-302-2840 Ext. 25 Fax 573-302-2841 -----Original Message----- From: MS Excel General Q & A List [mailto:EXCEL-GPEACH.EASE.LSOFT.COM] On Behalf Of Zong, David B Sent: Wednesday, April 11, 2007 3:58 PM To: EXCEL-GPEACH.EASE.LSOFT.COM Subject: Re: How to copy a range from closed workbook The problem with that is: I need to update the link and I hate to do that. -----Original Message----- From: MS Excel General Q & A List [mailto:EXCEL-GPEACH.EASE.LSOFT.COM] On Behalf Of Longworth, Damon Sent: Wednesday, April 11, 2007 3:56 PM To: EXCEL-GPEACH.EASE.LSOFT.COM Subject: Re: How to copy a range from closed workbook Name the range and then it is easy to use Data - Import External Data. Damon Longworth - Microsoft Excel MVP Lake Regional Medical Management Central Business Office dlongworthATlakeregional.com Tel 573-302-2840 Ext. 25 Fax 573-302-2841 -----Original Message----- From: MS Excel General Q & A List [mailto:EXCEL-GPEACH.EASE.LSOFT.COM] On Behalf Of Zong, David B Sent: Wednesday, April 11, 2007 3:53 PM To: EXCEL-GPEACH.EASE.LSOFT.COM Subject: How to copy a range from closed workbook Hi,all: I need to copy a range from a closed workbook into the Active Workbook. I'm thinking of using ADO GetData method. Does anyone know how to do that? Thanks. David Zong Sr. Risk Management Specialist Work: 314-554-4956 Cell: 217-721-3225 -----Original Message----- From: MS Excel General Q & A List [mailto:EXCEL-GPEACH.EASE.LSOFT.COM] On Behalf Of James Button Sent: Wednesday, April 11, 2007 3:40 PM To: EXCEL-GPEACH.EASE.LSOFT.COM Subject: Re: Learn PIVOT TABLES Search archives - this subject has been covered. also look at Google and microsoft mskb - Office documentation# and - there's books, online, and from a public library (if you are near enough to one) Also - look at C Pearson & J Walkenbach sites and places like MrExcel.com It's also worth looking up the VBA code to create, recreate, rebuild and manage a Pivot table JimB ----- Original Message ----- From: "K Ebrahim" <khalidebrahimGMAIL.COM> To: <EXCEL-GPEACH.EASE.LSOFT.COM> Sent: Wednesday, April 11, 2007 9:33 PM Subject: Learn PIVOT TABLES > Hello Group > > I need to do a quick self learning crash course on Pivot tables on Excel > 2003. I am fairly ok as a beginer / intermediate level with look up / > financial formulas but never got to use Pivot tables. > > Any easy n quick links would be appreciated a lot. > > Thanks in advance! > Ebrahim > > ------------------------------------------------------------ ------------ -- > The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft > international's LISTSERV(R) software. For subscription/signoff info > and archives, see htt p://peach.ease.lsoft.com/archives/excel-g.html . > COPYRIGHT INFO: > http://peach.ease.lsoft.com/scripts/wa .exe?SHOWTPL=COPYRIGHT&L=EXCEL-G > > ------------------------------------------------------------ ------------ -- The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft international's LISTSERV(R) software. For subscription/signoff info and archives, see htt p://peach.ease.lsoft.com/archives/excel-g.html . COPYRIGHT INFO: http://peach.ease.lsoft.com/scripts/wa .exe?SHOWTPL=COPYRIGHT&L=EXCEL-G ***************************** The information contained in this message may be privileged and/or confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. Note that any views or opinions presented in this message are solely those of the author and do not necessarily represent those of Ameren. All emails are subject to monitoring and archival. Finally, the recipient should check this message and any attachments for the presence of viruses. Ameren accepts no liability for any damage caused by any virus transmitted by this email. If you have received this in error, please notify the sender immediately by replying to the message and deleting the material from any computer. Ameren Corporation *************************** ------------------------------------------------------------ ------------ -- The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft international's LISTSERV(R) software. For subscription/signoff info and archives, see htt p://peach.ease.lsoft.com/archives/excel-g.html . COPYRIGHT INFO: http://peach.ease.lsoft.com/scripts/wa .exe?SHOWTPL=COPYRIGHT&L=EXCEL-G ------------------------------------------------------------ ------------ -- The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft international's LISTSERV(R) software. For subscription/signoff info and archives, see htt p://peach.ease.lsoft.com/archives/excel-g.html . COPYRIGHT INFO: http://peach.ease.lsoft.com/scripts/wa .exe?SHOWTPL=COPYRIGHT&L=EXCEL-G *************************** The information contained in this message may be privileged and/or confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. Note that any views or opinions presented in this message are solely those of the author and do not necessarily represent those of Ameren. All emails are subject to monitoring and archival. Finally, the recipient should check this message and any attachments for the presence of viruses. Ameren accepts no liability for any damage caused by any virus transmitted by this email. If you have received this in error, please notify the sender immediately by replying to the message and deleting the material from any computer. Ameren Corporation *************************** ------------------------------------------------------------ ------------ -- The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft international's LISTSERV(R) software. For subscription/signoff info and archives, see htt p://peach.ease.lsoft.com/archives/excel-g.html . COPYRIGHT INFO: http://peach.ease.lsoft.com/scripts/wa .exe?SHOWTPL=COPYRIGHT&L=EXCEL-G ------------------------------------------------------------ ------------ -- The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft international's LISTSERV(R) software. For subscription/signoff info and archives, see htt p://peach.ease.lsoft.com/archives/excel-g.html . COPYRIGHT INFO: http://peach.ease.lsoft.com/scripts/wa .exe?SHOWTPL=COPYRIGHT&L=EXCEL-G *************************** The information contained in this message may be privileged and/or confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. Note that any views or opinions presented in this message are solely those of the author and do not necessarily represent those of Ameren. All emails are subject to monitoring and archival. Finally, the recipient should check this message and any attachments for the presence of viruses. Ameren accepts no liability for any damage caused by any virus transmitted by this email. If you have received this in error, please notify the sender immediately by replying to the message and deleting the material from any computer. Ameren Corporation ***************************** ------------------------------------------------------------ -------------- The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft international's LISTSERV(R) software. For subscription/signoff info and archives, see htt p://peach.ease.lsoft.com/archives/excel-g.html . COPYRIGHT INFO: http://peach.ease.lsoft.com/scripts/wa .exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

[1]

about | contact Other archives ( Real Estate discussion Medical topics )

Mailing lists