Advanced Beginner
Windows 7 64bit 
Access 2007
Hi there,
I am wondering how to use application.commandbars function from access. When exporting to excel I also export the images. The images could be too large for excel.
How to convert the below code from excel to access vba code?
Application.CommandBars.ExecuteMso "PicturesCompress"
Thank you
Jo
VIP
Windows 7 64bit Access 2010 32bit
It is apparently the same command, at least through ExecuteMso. No idea if "PicturesCompress" will work. I tested and it errors in the Immediate window.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
copy OLEUnbound picture on form to excel worksheet
Compress On Exit
Posting Permissions
Reply With Quote