Hello fellow coders. I created a pretty slick app the creates an access
database and imports all the excel files in a folder into that database. This
is for a report in excel so I am pulling data from access into excel with a
piviot table. I am using an .ODC file to save the connection as the folder
where the excel files and database are created will change as the app gets
distrubited to different people. Wrote it all up in 2007 and saved in 2003
file format client only has 2003. This code does not work in 2003.
Public Sub AddDataConnection()
Dim workbookconnect As WorkbookConnection
ActiveWorkbook.Connections.AddFromFile (folder_name)

End Sub


anyone know the excel 2003 equivlilant to get this to work?