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")
Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications. You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data.
Rather than update each graph to point to a different set within a static set of data, t…