If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
personal.xls doesn't open when excel is opened from Access
I don't think that there's been a change to this behavior -- I'm guessing your
memory is faulty vbg. You can always open your personal.xls manually (via File|Open). Or if you can tweak the Access stuff, maybe you can open it via code??? Bento72 wrote: 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 -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|