this all seems great what if I simply use
DoCmd.OutputTo acOutputForm, "frmResults", acFormatXLS
and then somehow call it to make changes to the data adding condition statements
ok, know we are getting some were TY theDBGuy love the image btw so he found this code below and yes so it exports the data as I have selected it to step 1 know I guess i need to add in condition statements for what I want?
Public Sub cmdExport_Click()
Call...
Hi,
I have found the motherload of a question and I cannot find how to do it. I want to output the results of my form after the person has filtered it so some VBA like this
DoCmd.OutputTo acOutputForm, "Report 13", acFormatXLS, "C:\DATABASE\BLQ-10\ExportedResults.xls"
Know-how in the world can...
Hi, I am reaching out to you because of your Export to Excel with Conditional Formatting post. I am having a hard time tracking it all but I see that you got it working i have been searching for this answer for a while can I see your finishing code I cannot seem to figure this one out please help!