Export Excel File as a Complete Entity

[pianoman]

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

[Nigel]

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

--
Cheers
Nigel



"pianoman" <[email protected]> wrote in
message news:[email protected]...
>
> 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]

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

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

--
Cheers
Nigel



"pianoman" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>