Export Excel File as a Complete Entity
 

Hi Everyone,
I need to find a way of exporting everything 'custom' related to my
file, so that I can allow other users to run reports from the file
without coming across run time errors due to custom_types not being
available on others' PCs.

eg. Run time error '1004.. Method 'apply custom type' of object
'_chart' failed.

I know how to find my custom charts and copy them across manually, but
that is going to way too much work to do that for eveyone's pc. Plus, I
don't know what custom charts they have already, so it would mean
searching for sheet numbers and all sorts... there must be a better
way!

I was hoping there was something that would compare to the methods of
saving a web page, where you can choose, 'wep page complete' and you
get all the images and links and everything in a linked folder, so that
it can run stand-alone.

If nothing like that exists, could I do this with some code to search
out everything local and export into a folder or something...

I'm looking for inspiration, as well as code!!??!!

Many thanks as usual guys,

Regards,

Gareth


--
pianoman
------------------------------------------------------------------------
pianoman's Profile: http://www.excelforum.com/member.php...o&userid=33712
View this thread: http://www.excelforum.com/showthread...hreadid=545804

Export Excel File as a Complete Entity
 

Please do not send multiple posts. I have now read your request three
times!!

--
Cheers
Nigel



"pianoman" wrote in
message ...

Hi Everyone,
I need to find a way of exporting everything 'custom' related to my
file, so that I can allow other users to run reports from the file
without coming across run time errors due to custom_types not being
available on others' PCs.

eg. Run time error '1004.. Method 'apply custom type' of object
'_chart' failed.

I know how to find my custom charts and copy them across manually, but
that is going to way too much work to do that for eveyone's pc. Plus, I
don't know what custom charts they have already, so it would mean
searching for sheet numbers and all sorts... there must be a better
way!

I was hoping there was something that would compare to the methods of
saving a web page, where you can choose, 'wep page complete' and you
get all the images and links and everything in a linked folder, so that
it can run stand-alone.

If nothing like that exists, could I do this with some code to search
out everything local and export into a folder or something...

I'm looking for inspiration, as well as code!!??!!

Many thanks as usual guys,

Regards,

Gareth


--
pianoman
------------------------------------------------------------------------
pianoman's Profile:
http://www.excelforum.com/member.php...o&userid=33712
View this thread: http://www.excelforum.com/showthread...hreadid=545804

Export Excel File as a Complete Entity
 

Sorry Nigel, I was only trying to change the Title...

Nigel Wrote:
Please do not send multiple posts. I have now read your request three
times!!

--
Cheers
Nigel



"pianoman"
wrote in
message ...

Hi Everyone,
I need to find a way of exporting everything 'custom' related to my
file, so that I can allow other users to run reports from the file
without coming across run time errors due to custom_types not being
available on others' PCs.

eg. Run time error '1004.. Method 'apply custom type' of object
'_chart' failed.

I know how to find my custom charts and copy them across manually,
but
that is going to way too much work to do that for eveyone's pc. Plus,
I
don't know what custom charts they have already, so it would mean
searching for sheet numbers and all sorts... there must be a better
way!

I was hoping there was something that would compare to the methods
of
saving a web page, where you can choose, 'wep page complete' and you
get all the images and links and everything in a linked folder, so
that
it can run stand-alone.

If nothing like that exists, could I do this with some code to
search
out everything local and export into a folder or something...

I'm looking for inspiration, as well as code!!??!!

Many thanks as usual guys,

Regards,

Gareth


--
pianoman

------------------------------------------------------------------------
pianoman's Profile:
http://www.excelforum.com/member.php...o&userid=33712
View this thread:
http://www.excelforum.com/showthread...hreadid=545804



--
pianoman
------------------------------------------------------------------------
pianoman's Profile: http://www.excelforum.com/member.php...o&userid=33712
View this thread: http://www.excelforum.com/showthread...hreadid=545804