Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Personal.xls | Excel Discussion (Misc queries) | |||
cannot open the excel file, the file is already opened | Excel Discussion (Misc queries) | |||
Open an Access table in Excel | Excel Discussion (Misc queries) | |||
Using Access in Excel VB Code | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel |