I currently have this code:
Private Sub Command21_Click()
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _
"GRAPHING", "C:\Users\Me\Desktop\GRAPHING.XLS", True
End Sub
On this same button after this function, I want to open this file. I know, seems redundant, but I have this exporting so I can see a chart and access isn't letting me create one. I'm just opening to see the chart.