Hi
I'm an Access, VBA developer with over 20 years experience.
I've created functions and tools combining Access and Excel over the years. A project I developed a few years ago used a data set from Access and created a graph in Excel. I used this method as Access graphs are limited both visually and functionality.
The end result was a graph that was created in Excel but used in a control in Access. The process was seamless, allowing the user to apply filters, change the graph type and numerous other features without leaving Access.
There's much more to it but it gives you an example of my skills with VBA. Happy to share the project, demonstrate my skills, etc.
Look forward to hearing from you.
Kind Regards.
Darren