Access VBA and Excel Add-in

[purceld2]

I have a VBA module which calls a Excel macro which formats the exported spreadsheet. Its currently working fine on my PC referring to the macro in my personal.xls spreadsheet.

I now need to distribute the database out to other users and plan to create a add-in spreadsheet to distribute with the database. My questions is do i need to amend the reference in the VBA which calls the macro which will now be in the Add-in spreadsheet and not personal.xls or will it find it automatically.

Thanks in advance for you.

 

[DCrake]

The personal.xls is what it suggests personal to the pc using excel. I would put your macro in the spreadsheet you are distributing. Otherwise can you run the VBA from within Access using an open session of Excel? Using AppActive.