IS it possible to run an Excel macro from Access? I am trying to export data from Access to a spreadsheet, reformat it and save it using a different extension type (either .dat or .prn, both of which will save the formatting needed). I have an Excel macro that does the formatting, but have no way to start the macro without opening the spreadsheet and I'd rather keep the users out of the file for security reasons. Thanks in advance.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.