Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
export re-order input fields to export file [csv] | Excel Worksheet Functions | |||
Export excel file to txt | Excel Discussion (Misc queries) | |||
Update complete excel file online | Excel Discussion (Misc queries) | |||
Export excel file to semicolon delimited text file | Excel Discussion (Misc queries) | |||
Excel should export its file as exe | Excel Programming |