Possibly, if there's some general way to execute VBA from outside
Access. From an MSSQL stored proc, you could use xp_xmdshell to execute
a batch file, or the sp_OA% procs to manipulate COM objects. But both
of these options are restricted to sysadmin users by default, since
they may open up big security holes.
You might want to post in an Access group, to see if there's a
'standard' way to execute VBA from outside Access, then consider how
you could (or should) use that mechanism from MSSQL.
Simon