R
Risky Dave
Hi,
I have a fairly large and complex workbook that has started to show some
strange behaviour that I can't explain.
The workbook (let's call it "Source") consists of ten or so separate sheets
each holding different data. Each sheet is hidden until it is used.
Navigation around the workbook is from a single front page that simply has
buttons giving the user a chioce of actions.
One of the options from the Navigation page is to create an extract of all
of the source sheets. The macro that does this simply creates a tremporary
sheet called "Extract" and then cut-and-pastes each of the ten source sheets
into Extract side-by-side. "Extract" is then copied to a new workbook and
which is saved with a specific file name (eg. "<date> Extract") and the
temporary sheet in "Source" is deleted.
Until recently, this all worked perfectly happily and I am not aware of any
changes that I have made to the code (with one possible exception - see
below).
When I first open "Source" everything is fine until I run the extract macro
when I get a couple of system-generated error messages; the first tells me
that the file format is different to the extension name and the second that
the macro cannot be found.
What is happening is that when the Extract is run, the path for ALL the
macros in Source (even the ones that are not used when running "Extract") is
changed so that XL is looking in the Extract library for the code - it will
even attempt to open a closed copy of Extract to find the macros.
The only change that I am aware that I have made to my XL installation
recently was to install an add-in to create some thuings called sparklines (a
type of line graph). I have subsequently uninstlled the add-in again, but
this has not been completly successful as every time I open XL now I get an
error message saying the programme cannot be found!
Can anyone suggest what may be happening here 'cos I am at a complete loss.
TIA
Dave
I have a fairly large and complex workbook that has started to show some
strange behaviour that I can't explain.
The workbook (let's call it "Source") consists of ten or so separate sheets
each holding different data. Each sheet is hidden until it is used.
Navigation around the workbook is from a single front page that simply has
buttons giving the user a chioce of actions.
One of the options from the Navigation page is to create an extract of all
of the source sheets. The macro that does this simply creates a tremporary
sheet called "Extract" and then cut-and-pastes each of the ten source sheets
into Extract side-by-side. "Extract" is then copied to a new workbook and
which is saved with a specific file name (eg. "<date> Extract") and the
temporary sheet in "Source" is deleted.
Until recently, this all worked perfectly happily and I am not aware of any
changes that I have made to the code (with one possible exception - see
below).
When I first open "Source" everything is fine until I run the extract macro
when I get a couple of system-generated error messages; the first tells me
that the file format is different to the extension name and the second that
the macro cannot be found.
What is happening is that when the Extract is run, the path for ALL the
macros in Source (even the ones that are not used when running "Extract") is
changed so that XL is looking in the Extract library for the code - it will
even attempt to open a closed copy of Extract to find the macros.
The only change that I am aware that I have made to my XL installation
recently was to install an add-in to create some thuings called sparklines (a
type of line graph). I have subsequently uninstlled the add-in again, but
this has not been completly successful as every time I open XL now I get an
error message saying the programme cannot be found!
Can anyone suggest what may be happening here 'cos I am at a complete loss.
TIA
Dave