JoshuaAnthony
Registered User.
- Local time
- Today, 02:02
- Joined
- Dec 18, 2003
- Messages
- 68
Hi,
I create an Excel file using "DoCmd.OutputTo". I use that file to create a graph in Excel and display it in a form using an unbound Microsoft Excel Chart object.
I have 2 questions in regard to this:
1. I can't seem to open the file properly outside of Access. The menu/toolbars for Excel all show up and the computer doesn't stall (I still can shut down Excel properly if need be) but no worksheets or charts appear. Is this normal for files created using DoCmd.OutputTo? Is there a better way to create or open the file to ensure that it is accessible outside of Microsoft Access?
2. I would prefer to just record an excel Macro to create my charts rather than doing it manually with VB in Access. How do I simply call my excel Macro from VBA?
Thanks,
Joshua
I create an Excel file using "DoCmd.OutputTo". I use that file to create a graph in Excel and display it in a form using an unbound Microsoft Excel Chart object.
I have 2 questions in regard to this:
1. I can't seem to open the file properly outside of Access. The menu/toolbars for Excel all show up and the computer doesn't stall (I still can shut down Excel properly if need be) but no worksheets or charts appear. Is this normal for files created using DoCmd.OutputTo? Is there a better way to create or open the file to ensure that it is accessible outside of Microsoft Access?
2. I would prefer to just record an excel Macro to create my charts rather than doing it manually with VB in Access. How do I simply call my excel Macro from VBA?
Thanks,
Joshua
