Microsoft Access - Advanced Excel Automation

[@lorenzogaruglieri7046]

hi Daniel, this is really a great video. Thank you.

[@DanielPineault]

Glad you liked it!

[@TheRealWillM]

Very cool, definitely can see use cases for this, for my project (s)

[@DanielPineault]

Thank you for the feedback and glad you find it useful.

[@lorenzogaruglieri7046]

sorry Daniel, but the code you posted is from the video?

[@DanielPineault]

Not 100% sure, I was about to write an article and found I had already done so years ago which included routines like: LaunchExcel, AddExcelWrkBk, ... which if not identical to the video perform the same processes.

[@lorenzogaruglieri7046]

@@DanielPineault many thx.

[@bumpersmith]

Is this database available for download?

[@DanielPineault]

Not currently, but I will be putting together an article and sample in the near future.

[@bumpersmith]

@@DanielPineault Great, I could really utilize what you presented here to export all or some tables of several of my databases to Excel with one click.

[@DanielPineault]

Actually, after reviewing my blog, I already posted the code. www.devhut.net/vba-automating-excel/