Recent content by blime

  1. B

    Export Access Query to Excel including Conditional Formatting

    I tried the suggested: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "QueryName","C:\Test.xls",, "MyName" But sadly😭, it did not work.
  2. B

    Export Access Query to Excel including Conditional Formatting

    As I cannot export file with conditional formatting, I would like to use the Do.Cmd button so the user on click can export and open the excel file and the user can then decide also where they would like to save it on their OneDrive. Would you know the VBA for this on the DoCmd please t?
  3. B

    Export Access Query to Excel including Conditional Formatting

    How do I use Excel automation in the Access function?
  4. B

    Export Access Query to Excel including Conditional Formatting

    I am new to Access, so please forgive me if this has been asked before. I have carried out a search on the site but could not find a clear answer. I would like to export a datasheet form to Excel including conditional formatting. - I have a query with several lookup tables. - A form is...
See more
Top Bottom