Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel and Query--copy workbook
Hello to All,
I'm using Query to pull a parts list to sheet 2 from sheet 1. Thi works fine until I make a copy of the workbook. When I make a copy o the workbook, the Query still draws from the original. Is there a wa to easily change the query to pull from the copy instead of th original? Thanks for any help Nathan Sargean -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel and Query--copy workbook
Two options:
1) In MSQuery, File menu is option "Table Definition" that allows you to respecify your data source. 2) From VBA code, the QueryTable object has a Connection property that specifies the data source - you could change this via VBA. K Dales -----Original Message----- Hello to All, I'm using Query to pull a parts list to sheet 2 from sheet 1. This works fine until I make a copy of the workbook. When I make a copy of the workbook, the Query still draws from the original. Is there a way to easily change the query to pull from the copy instead of the original? Thanks for any help Nathan Sargeant --- Message posted from http://www.ExcelForum.com/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Copy Workbook Query | Excel Discussion (Misc queries) | |||
Excel-how to link source workbook to copy of destination workbook | Excel Worksheet Functions | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Populating Excel Web Query across workbook | Excel Discussion (Misc queries) |