View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Sandy[_3_] Sandy[_3_] is offline
external usenet poster
 
Posts: 43
Default 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



.