InstructionWhich7142
Registered User.
- Local time
- Today, 23:38
- Joined
- Feb 24, 2010
- Messages
- 199
As part of a deployment tool I want to rename autoexec1 to Autoexec to "enable" a database for deployment,
In VBA I've got a "Save and Publish as ACCDE" working and "compact and repair", I just need to rename this macro and I'm sorted,
except you can't replace DoCmd like that and all the examples online are for tables and use tabledefs
In VBA I've got a "Save and Publish as ACCDE" working and "compact and repair", I just need to rename this macro and I'm sorted,
Code:
Set db2e = OpenDatabase(CurrentProject.Path & "\DB2.accde")
db2e.Rename "autoexec", acMacro, "autoexec1"
except you can't replace DoCmd like that and all the examples online are for tables and use tabledefs