I have tried this but it still doesn't work. I am working with Office 97. Within Access when I code for excel to go into print preview mode it locks up. At the moment I will just do this manually.
Reports are usually produced via Access and emailed to recipients or via intranet applications however this report has been requested in a spreadsheet format. I have been able to adjust all printing settings except for where the pagebreaks occur.
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.