Save excel as a complete package
 

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

Save excel as a complete package
 

hi,
from experience, i have found it unwise in a team enviroment to load a file
with a lot of custom features. it tends to create the problems that you are
talking about.
custom features apply to the customized pc only and not the file. that is
why they call it customizing.
You can add code in the on open event to apply some custom features to other
machines like custom tool bars ect ( i did that once) but without knowing
what custom features you have, i would not know what code to suggest.
if you do add code to apply these custom features, it would be polite to
remove any customizing you did to someone elses machine on file close.

regards
FSt1

"pianoman" wrote:


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

Save excel as a complete package
 

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