Set Default Database window

[socomfort]

Hello,

Does anybody know if there is a way to programmatically set the Default Database window in MS Access? I am using OfficeLinks to output my data to an excel spreadsheet.

Or is the only option to consistently send data to Excel(to a specific and known folder) to use DoCmd.OutputTo?

thanks ahead of your reply,

Ben

 

[PHV]

You may also consider the DoCmd.TransferSpreadsheet method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886