Help with XLT file

[Dave Navarro]

A co-worker who has left the company created an XLT file to pull data
from an SQL database into a spreadsheet for our accounting department.

They need updates to the XLT file, but I have no idea how to get at the
code in it. I can see the data that it pulls, but not the code that
pulls it.

Can someone point me to a resource for working on XLT files?

Thanks!

 

[Ron de Bruin]

Hi Dave

Open the template
save it as a normal Excel file
Alt F11
Go to the modules with the code in this project and edit the code
Save the file as a xlt again when you are done

 

[Gord Dibben]

Dave

To open the actual *.xlt file, not a workbook based on the template, open
Windows Explorer and find the file.

Right-click and Open.

Alt + F11 to open the VB Editor.

CTRL + r to open the Project Explorer.

Select your workbook/project and expand it.

Dependiing upon which type of code you would look into modules(macros, sheet,
thisworkbook)

Double-click to open modules for editing.


Gord Dibben MS Excel MVP