iamthebestuk
Technical User
Hi,
I've trawled the site to see if I could find an answer to this - but no luck - so here goes ...
I currently have a button on my form that exports the results to excel, letting the user choose the location and name of the file. Code is below.
DoCmd.OutputTo acForm, "frmCriteriaResults", "MicrosoftExcel(*.xls)", "", True, ""
What I need to do is hide (not delete) some of the fields shown on the form when it is displayed/stored in excel .
Remember I don't know what the user will name the file or it's possible location.
Help needed.
Much appreciated.
I've trawled the site to see if I could find an answer to this - but no luck - so here goes ...
I currently have a button on my form that exports the results to excel, letting the user choose the location and name of the file. Code is below.
DoCmd.OutputTo acForm, "frmCriteriaResults", "MicrosoftExcel(*.xls)", "", True, ""
What I need to do is hide (not delete) some of the fields shown on the form when it is displayed/stored in excel .
Remember I don't know what the user will name the file or it's possible location.
Help needed.
Much appreciated.