Is there a way to export an access report into excel and specify the formatting of some of the cells. In this case I would like a particular cell to be formatted as "wrap text" when the report is exported.
Slight tweak to Jim's approach:
Dim xlApp As Object, xlWb As Object, xlWs As Object
Dim rs As DAO.Recordset
Set rs = CurrentDb.OpenRecordset("NameOfQuery")
Set xlApp = CreateObject("Excel.Application")
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results.
Paraphrasing Richard Shockley, author of my favourite finance reference tex…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…