I have the macro working to export the data to excel, I just want to know how to set a switch in the macro to automatically replace the existing file previously exported.
Thanks.
I want the export function in the macro to automatically replace an existing file in that path and name.
Is there a command line switch that can be set?
How do you refresh all of the data on a form when the tables that are the source for dlookup fields on the form are changed by command buttons on the form?
I have a field on a form that is the results of a dlookup to a table.field. I want the value to be updated when I execute a button that is running a macro. How do I do this automatically, and not have to hit the refresh button?