Copy continual, refreshing records to a new sheet
To: KeepITcool Thanks for your concern and help. As I have no knowledge on VBA and thus after receiving your code, borrowed a book and ran thru it hoping to learn proper place fo substitutions. but still in vain. Q1: You mentioned about the name of the Quesrytable. Is it the name I put at random when setting the Properties ,e.g. sort.cfm "? or the full http:// .... ... where the table come from ? Q2: I have a few pairs of work sheets to do similar task. Do we have to specify the source and target name(s) ? Q3: Does your code allow source range be copied to specified targe range at every interval set ? Await for your comment while I am still doing my book running. Eduard -- EduardoDo ----------------------------------------------------------------------- EduardoDon's Profile: http://www.excelforum.com/member.php...nfo&userid=849 View this thread: http://www.excelforum.com/showthread.php?threadid=26857 |
All times are GMT +1. The time now is 05:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com