personal.xls doesn't open when excel is opened from Access
Hi,
My personal.xls spreadsheet containing my macros opens fine when I open
Excel manually, but if I use the function in MS Access ('Analyze It with
Microsoft Office Excel') that exports an Access dataset to Excel for
analysis, my macros aren't available as it appears that the personal.xls
file hasn't opened.
It used to be fine before I switched to Windows XP - is there a setting I
need to change to rectify this problem ?
Thanks for your help.
Bento
|