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=545795