Currently I export a table in Access into Excel and format the spreadsheet via VBA code. I can do everthing needed except adjusting the page breaks for printing. Does anyone know how to do this !
Does anyone know how to use winzip to compress files via vba coding in an efficient manner. Our reports are often too big to handle via email and currently a sendkeys operation acheives the desired result but it occassionly does not compress all the required files.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.