G
Guest
When I run the following code, to send a query as an Excel file:
DoCmd.SendObject acSendQuery, "qryFeesRpt", "MicrosoftExcelBiff8(*.xls)",
"DACSS@********", "", "", "Fee Report " & Forms("Assembly Documentation Menu
B").SubjLine, "DO NOT EDIT EMAIL SUBJECT LINE", True, ""
I get the following error message:
The formats that enable you to output data as a Microsoft Excel, rich-text
format, MS-DOS text, or HTML file are missing from the Windows Registry.
This seems to be documented in the KnowledgeBase article
http://support.microsoft.com/kb/226526/en-us
which suggests the fault may be caused by:
“The path that you specify does not exist.â€
My VBA skills are just short of what I’d call “weak.†I don’t understand
where I would use a path statement in this line of code. I have not stored a
file named qryFeeRpt.xls on the system.
Do any of my fellow and sister (but wiser) Access gurus have a suggested
correction to the line of code and would you be so kind as to show what it
looks like?
DoCmd.SendObject acSendQuery, "qryFeesRpt", "MicrosoftExcelBiff8(*.xls)",
"DACSS@********", "", "", "Fee Report " & Forms("Assembly Documentation Menu
B").SubjLine, "DO NOT EDIT EMAIL SUBJECT LINE", True, ""
I get the following error message:
The formats that enable you to output data as a Microsoft Excel, rich-text
format, MS-DOS text, or HTML file are missing from the Windows Registry.
This seems to be documented in the KnowledgeBase article
http://support.microsoft.com/kb/226526/en-us
which suggests the fault may be caused by:
“The path that you specify does not exist.â€
My VBA skills are just short of what I’d call “weak.†I don’t understand
where I would use a path statement in this line of code. I have not stored a
file named qryFeeRpt.xls on the system.
Do any of my fellow and sister (but wiser) Access gurus have a suggested
correction to the line of code and would you be so kind as to show what it
looks like?