Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code for existing links
Can anyone tell me where the VBA for existing links is
located in an Excel spreadsheet linked to an Access DB? Sandy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code for existing links
There is no VBA associated with links between Excel and Access. All VBA
code will be found either in a general module or class module associated with the workbook - and there is no VBA code with links established to Data=Get External data or using the Pivot table wizard. Regards, Tom Ogilvy "Sandy" wrote in message ... Can anyone tell me where the VBA for existing links is located in an Excel spreadsheet linked to an Access DB? Sandy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code for existing links
Dear Tom:
Thanks for your reply. Do you know if there is a way I can get a list of links in Excel? I need to know which columns in Excel map to which columns in the Access database. Sandy -----Original Message----- There is no VBA associated with links between Excel and Access. All VBA code will be found either in a general module or class module associated with the workbook - and there is no VBA code with links established to Data=Get External data or using the Pivot table wizard. Regards, Tom Ogilvy "Sandy" wrote in message ... Can anyone tell me where the VBA for existing links is located in an Excel spreadsheet linked to an Access DB? Sandy . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code for existing links
Dim qtbl as QueryTable
for each sh in ThisWorkbook.Worksheets for each qtbl in sh.QueryTables msgbox qtbl.sql Next Next should show you the select statement. To the best of my knowledge, the order in the select tables is assigned to the columns sequentially from the first column. Regards, Tom Ogilvy "Sandy" wrote in message ... Dear Tom: Thanks for your reply. Do you know if there is a way I can get a list of links in Excel? I need to know which columns in Excel map to which columns in the Access database. Sandy -----Original Message----- There is no VBA associated with links between Excel and Access. All VBA code will be found either in a general module or class module associated with the workbook - and there is no VBA code with links established to Data=Get External data or using the Pivot table wizard. Regards, Tom Ogilvy "Sandy" wrote in message ... Can anyone tell me where the VBA for existing links is located in an Excel spreadsheet linked to an Access DB? Sandy . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Really need help with existing code. | Excel Discussion (Misc queries) | |||
Help with existing code | Excel Discussion (Misc queries) | |||
Preserve existing data whilw using external links | Excel Worksheet Functions | |||
VBA Code for Links to Excel workbooks | Excel Programming | |||
Code for Links from Excel to Access | Excel Programming |