Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Export chart to GIF no longer works after installing Excel 2007b2
I've used the following Visual Basic code in Excel 2000 to export a chart to
GIF. However, after installing Excel 2007b2 I now get errors (method of export failed) when using the same old code in Excel 2000 and cannot export. Does anybody know if something has changed? ActiveSheet.ChartObjects(1).Activate ActiveChart.Export Filename:="C:\Documents and Settings\user\My Documents\mychart.gif", filtername:="gif" |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Export chart to GIF no longer works after installing Excel 2007b2
In article ,
says... I've used the following Visual Basic code in Excel 2000 to export a chart to GIF. However, after installing Excel 2007b2 I now get errors (method of export failed) when using the same old code in Excel 2000 and cannot export. Does anybody know if something has changed? ActiveSheet.ChartObjects(1).Activate ActiveChart.Export Filename:="C:\Documents and Settings\user\My Documents\mychart.gif", filtername:="gif" Maybe, installing 2007 Beta2 removed the filter needed to export as a GIF? -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Export chart to GIF no longer works after installing Excel 200
Tushar, thank you for your response.
If the GIF filter was somehow removed by the install of Excel 2007b2, do you think reinstalling Excel 2000 would be a reasonable fix? BTW - I believe you helped me with a charting issue many years ago and I'd just like to thank you for taking the time to help me and the Excel community. "Tushar Mehta" wrote: In article , says... I've used the following Visual Basic code in Excel 2000 to export a chart to GIF. However, after installing Excel 2007b2 I now get errors (method of export failed) when using the same old code in Excel 2000 and cannot export. Does anybody know if something has changed? ActiveSheet.ChartObjects(1).Activate ActiveChart.Export Filename:="C:\Documents and Settings\user\My Documents\mychart.gif", filtername:="gif" Maybe, installing 2007 Beta2 removed the filter needed to export as a GIF? -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Export chart to GIF no longer works after installing Excel 200
I noticed this problem on one of my computers. The filters in the Microsoft
Shared folder are all newer than Office 2003, dated in 2006. Except for the TIFF filter, which is still dated 2000, and the export to TIFF still works. I tried to reinstall Office 2003's filters, but apparently it checks the file date stamp prior to overwriting, and the files didn't change. I didn't yet try deleting the filters then reinstalling. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "ExcelFan" wrote in message ... Tushar, thank you for your response. If the GIF filter was somehow removed by the install of Excel 2007b2, do you think reinstalling Excel 2000 would be a reasonable fix? BTW - I believe you helped me with a charting issue many years ago and I'd just like to thank you for taking the time to help me and the Excel community. "Tushar Mehta" wrote: In article , says... I've used the following Visual Basic code in Excel 2000 to export a chart to GIF. However, after installing Excel 2007b2 I now get errors (method of export failed) when using the same old code in Excel 2000 and cannot export. Does anybody know if something has changed? ActiveSheet.ChartObjects(1).Activate ActiveChart.Export Filename:="C:\Documents and Settings\user\My Documents\mychart.gif", filtername:="gif" Maybe, installing 2007 Beta2 removed the filter needed to export as a GIF? -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Export chart to GIF no longer works after installing Excel 200
Jon,
Thank you very much for your insight. It sounds like you're onto something and I would very much want to give a try at reverting back to the old GIF filter. However, I must confess, I don't know the location of the shared folder, nor the name of the gif filter. Can you help? -- Regards, Pete "Jon Peltier" wrote: I noticed this problem on one of my computers. The filters in the Microsoft Shared folder are all newer than Office 2003, dated in 2006. Except for the TIFF filter, which is still dated 2000, and the export to TIFF still works. I tried to reinstall Office 2003's filters, but apparently it checks the file date stamp prior to overwriting, and the files didn't change. I didn't yet try deleting the filters then reinstalling. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "ExcelFan" wrote in message ... Tushar, thank you for your response. If the GIF filter was somehow removed by the install of Excel 2007b2, do you think reinstalling Excel 2000 would be a reasonable fix? BTW - I believe you helped me with a charting issue many years ago and I'd just like to thank you for taking the time to help me and the Excel community. "Tushar Mehta" wrote: In article , says... I've used the following Visual Basic code in Excel 2000 to export a chart to GIF. However, after installing Excel 2007b2 I now get errors (method of export failed) when using the same old code in Excel 2000 and cannot export. Does anybody know if something has changed? ActiveSheet.ChartObjects(1).Activate ActiveChart.Export Filename:="C:\Documents and Settings\user\My Documents\mychart.gif", filtername:="gif" Maybe, installing 2007 Beta2 removed the filter needed to export as a GIF? -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
Export chart to GIF no longer works after installing Excel 200
Jon,
I did some further digging and was able to find a solution. I'll include my solution just in case it might help someone in the community... Microsoft shared files are located here... C:\Program Files\Common Files\Microsoft Shared\Grphflt I simply took an Excel 2000 version of the gif filter (GIFIMP32.FLT) from another computer and copied it to the above-mentioned directory, thereby replacing what was an Excel 2007 version of the gif filter. Now exporting gif's in Excel 2000 is as it has always been, flawless. I thank you for your help. I couldn't have done it without you. -- Regards, Pete "Jon Peltier" wrote: I noticed this problem on one of my computers. The filters in the Microsoft Shared folder are all newer than Office 2003, dated in 2006. Except for the TIFF filter, which is still dated 2000, and the export to TIFF still works. I tried to reinstall Office 2003's filters, but apparently it checks the file date stamp prior to overwriting, and the files didn't change. I didn't yet try deleting the filters then reinstalling. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "ExcelFan" wrote in message ... Tushar, thank you for your response. If the GIF filter was somehow removed by the install of Excel 2007b2, do you think reinstalling Excel 2000 would be a reasonable fix? BTW - I believe you helped me with a charting issue many years ago and I'd just like to thank you for taking the time to help me and the Excel community. "Tushar Mehta" wrote: In article , says... I've used the following Visual Basic code in Excel 2000 to export a chart to GIF. However, after installing Excel 2007b2 I now get errors (method of export failed) when using the same old code in Excel 2000 and cannot export. Does anybody know if something has changed? ActiveSheet.ChartObjects(1).Activate ActiveChart.Export Filename:="C:\Documents and Settings\user\My Documents\mychart.gif", filtername:="gif" Maybe, installing 2007 Beta2 removed the filter needed to export as a GIF? -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
Export chart to GIF no longer works after installing Excel 200
Pete -
Thanks for following up and sharing your experiences. Have you noticed any ill effects on 2007? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "ExcelFan" wrote in message ... Jon, I did some further digging and was able to find a solution. I'll include my solution just in case it might help someone in the community... Microsoft shared files are located here... C:\Program Files\Common Files\Microsoft Shared\Grphflt I simply took an Excel 2000 version of the gif filter (GIFIMP32.FLT) from another computer and copied it to the above-mentioned directory, thereby replacing what was an Excel 2007 version of the gif filter. Now exporting gif's in Excel 2000 is as it has always been, flawless. I thank you for your help. I couldn't have done it without you. -- Regards, Pete "Jon Peltier" wrote: I noticed this problem on one of my computers. The filters in the Microsoft Shared folder are all newer than Office 2003, dated in 2006. Except for the TIFF filter, which is still dated 2000, and the export to TIFF still works. I tried to reinstall Office 2003's filters, but apparently it checks the file date stamp prior to overwriting, and the files didn't change. I didn't yet try deleting the filters then reinstalling. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "ExcelFan" wrote in message ... Tushar, thank you for your response. If the GIF filter was somehow removed by the install of Excel 2007b2, do you think reinstalling Excel 2000 would be a reasonable fix? BTW - I believe you helped me with a charting issue many years ago and I'd just like to thank you for taking the time to help me and the Excel community. "Tushar Mehta" wrote: In article , says... I've used the following Visual Basic code in Excel 2000 to export a chart to GIF. However, after installing Excel 2007b2 I now get errors (method of export failed) when using the same old code in Excel 2000 and cannot export. Does anybody know if something has changed? ActiveSheet.ChartObjects(1).Activate ActiveChart.Export Filename:="C:\Documents and Settings\user\My Documents\mychart.gif", filtername:="gif" Maybe, installing 2007 Beta2 removed the filter needed to export as a GIF? -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
Export chart to GIF no longer works after installing Excel 200
"Jon Peltier" wrote: Pete - Thanks for following up and sharing your experiences. Have you noticed any ill effects on 2007? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "ExcelFan" wrote in message ... Jon, I did some further digging and was able to find a solution. I'll include my solution just in case it might help someone in the community... Microsoft shared files are located here... C:\Program Files\Common Files\Microsoft Shared\Grphflt I simply took an Excel 2000 version of the gif filter (GIFIMP32.FLT) from another computer and copied it to the above-mentioned directory, thereby replacing what was an Excel 2007 version of the gif filter. Now exporting gif's in Excel 2000 is as it has always been, flawless. I thank you for your help. I couldn't have done it without you. -- Regards, Pete "Jon Peltier" wrote: I noticed this problem on one of my computers. The filters in the Microsoft Shared folder are all newer than Office 2003, dated in 2006. Except for the TIFF filter, which is still dated 2000, and the export to TIFF still works. I tried to reinstall Office 2003's filters, but apparently it checks the file date stamp prior to overwriting, and the files didn't change. I didn't yet try deleting the filters then reinstalling. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "ExcelFan" wrote in message ... Tushar, thank you for your response. If the GIF filter was somehow removed by the install of Excel 2007b2, do you think reinstalling Excel 2000 would be a reasonable fix? BTW - I believe you helped me with a charting issue many years ago and I'd just like to thank you for taking the time to help me and the Excel community. "Tushar Mehta" wrote: In article , says... I've used the following Visual Basic code in Excel 2000 to export a chart to GIF. However, after installing Excel 2007b2 I now get errors (method of export failed) when using the same old code in Excel 2000 and cannot export. Does anybody know if something has changed? ActiveSheet.ChartObjects(1).Activate ActiveChart.Export Filename:="C:\Documents and Settings\user\My Documents\mychart.gif", filtername:="gif" Maybe, installing 2007 Beta2 removed the filter needed to export as a GIF? -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
#10
Posted to microsoft.public.excel.charting
|
|||
|
|||
Export chart to GIF no longer works after installing Excel 200
That has not removed the problem for me, any further thoughts?
"Jon Peltier" wrote: Pete - Thanks for following up and sharing your experiences. Have you noticed any ill effects on 2007? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "ExcelFan" wrote in message ... Jon, I did some further digging and was able to find a solution. I'll include my solution just in case it might help someone in the community... Microsoft shared files are located here... C:\Program Files\Common Files\Microsoft Shared\Grphflt I simply took an Excel 2000 version of the gif filter (GIFIMP32.FLT) from another computer and copied it to the above-mentioned directory, thereby replacing what was an Excel 2007 version of the gif filter. Now exporting gif's in Excel 2000 is as it has always been, flawless. I thank you for your help. I couldn't have done it without you. -- Regards, Pete "Jon Peltier" wrote: I noticed this problem on one of my computers. The filters in the Microsoft Shared folder are all newer than Office 2003, dated in 2006. Except for the TIFF filter, which is still dated 2000, and the export to TIFF still works. I tried to reinstall Office 2003's filters, but apparently it checks the file date stamp prior to overwriting, and the files didn't change. I didn't yet try deleting the filters then reinstalling. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "ExcelFan" wrote in message ... Tushar, thank you for your response. If the GIF filter was somehow removed by the install of Excel 2007b2, do you think reinstalling Excel 2000 would be a reasonable fix? BTW - I believe you helped me with a charting issue many years ago and I'd just like to thank you for taking the time to help me and the Excel community. "Tushar Mehta" wrote: In article , says... I've used the following Visual Basic code in Excel 2000 to export a chart to GIF. However, after installing Excel 2007b2 I now get errors (method of export failed) when using the same old code in Excel 2000 and cannot export. Does anybody know if something has changed? ActiveSheet.ChartObjects(1).Activate ActiveChart.Export Filename:="C:\Documents and Settings\user\My Documents\mychart.gif", filtername:="gif" Maybe, installing 2007 Beta2 removed the filter needed to export as a GIF? -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
#11
Posted to microsoft.public.excel.charting
|
|||
|
|||
Export chart to GIF no longer works after installing Excel 200
Anybody find a real solution to this problem?
"XianGW" wrote: That has not removed the problem for me, any further thoughts? "Jon Peltier" wrote: Pete - Thanks for following up and sharing your experiences. Have you noticed any ill effects on 2007? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "ExcelFan" wrote in message ... Jon, I did some further digging and was able to find a solution. I'll include my solution just in case it might help someone in the community... Microsoft shared files are located here... C:\Program Files\Common Files\Microsoft Shared\Grphflt I simply took an Excel 2000 version of the gif filter (GIFIMP32.FLT) from another computer and copied it to the above-mentioned directory, thereby replacing what was an Excel 2007 version of the gif filter. Now exporting gif's in Excel 2000 is as it has always been, flawless. I thank you for your help. I couldn't have done it without you. -- Regards, Pete "Jon Peltier" wrote: I noticed this problem on one of my computers. The filters in the Microsoft Shared folder are all newer than Office 2003, dated in 2006. Except for the TIFF filter, which is still dated 2000, and the export to TIFF still works. I tried to reinstall Office 2003's filters, but apparently it checks the file date stamp prior to overwriting, and the files didn't change. I didn't yet try deleting the filters then reinstalling. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "ExcelFan" wrote in message ... Tushar, thank you for your response. If the GIF filter was somehow removed by the install of Excel 2007b2, do you think reinstalling Excel 2000 would be a reasonable fix? BTW - I believe you helped me with a charting issue many years ago and I'd just like to thank you for taking the time to help me and the Excel community. "Tushar Mehta" wrote: In article , says... I've used the following Visual Basic code in Excel 2000 to export a chart to GIF. However, after installing Excel 2007b2 I now get errors (method of export failed) when using the same old code in Excel 2000 and cannot export. Does anybody know if something has changed? ActiveSheet.ChartObjects(1).Activate ActiveChart.Export Filename:="C:\Documents and Settings\user\My Documents\mychart.gif", filtername:="gif" Maybe, installing 2007 Beta2 removed the filter needed to export as a GIF? -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
#12
Posted to microsoft.public.excel.charting
|
|||
|
|||
Export chart to GIF no longer works after installing Excel 200
Which version(s) of Excel are installed, and in which order were they
installed (and uninstalled if you removed them)? I had issues with some of the filters after uninstalling 2007 (which I'd installed in parallel with 2003). I ended up copying some registry stuff and some filters from a computer which had not been despoiled by 2007, and transferred these to the computer with problems, and all is back to normal. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "rufus" wrote in message ... Anybody find a real solution to this problem? "XianGW" wrote: That has not removed the problem for me, any further thoughts? "Jon Peltier" wrote: Pete - Thanks for following up and sharing your experiences. Have you noticed any ill effects on 2007? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "ExcelFan" wrote in message ... Jon, I did some further digging and was able to find a solution. I'll include my solution just in case it might help someone in the community... Microsoft shared files are located here... C:\Program Files\Common Files\Microsoft Shared\Grphflt I simply took an Excel 2000 version of the gif filter (GIFIMP32.FLT) from another computer and copied it to the above-mentioned directory, thereby replacing what was an Excel 2007 version of the gif filter. Now exporting gif's in Excel 2000 is as it has always been, flawless. I thank you for your help. I couldn't have done it without you. -- Regards, Pete "Jon Peltier" wrote: I noticed this problem on one of my computers. The filters in the Microsoft Shared folder are all newer than Office 2003, dated in 2006. Except for the TIFF filter, which is still dated 2000, and the export to TIFF still works. I tried to reinstall Office 2003's filters, but apparently it checks the file date stamp prior to overwriting, and the files didn't change. I didn't yet try deleting the filters then reinstalling. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "ExcelFan" wrote in message ... Tushar, thank you for your response. If the GIF filter was somehow removed by the install of Excel 2007b2, do you think reinstalling Excel 2000 would be a reasonable fix? BTW - I believe you helped me with a charting issue many years ago and I'd just like to thank you for taking the time to help me and the Excel community. "Tushar Mehta" wrote: In article , says... I've used the following Visual Basic code in Excel 2000 to export a chart to GIF. However, after installing Excel 2007b2 I now get errors (method of export failed) when using the same old code in Excel 2000 and cannot export. Does anybody know if something has changed? ActiveSheet.ChartObjects(1).Activate ActiveChart.Export Filename:="C:\Documents and Settings\user\My Documents\mychart.gif", filtername:="gif" Maybe, installing 2007 Beta2 removed the filter needed to export as a GIF? -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
#13
Posted to microsoft.public.excel.charting
|
|||
|
|||
Export chart to GIF no longer works after installing Excel 200
Office 2003 and OWC both 10 and 11. Worked just fine untill IE7 was installed.
Which filters registry stuff should I look for and where? Rufus "Jon Peltier" wrote: Which version(s) of Excel are installed, and in which order were they installed (and uninstalled if you removed them)? I had issues with some of the filters after uninstalling 2007 (which I'd installed in parallel with 2003). I ended up copying some registry stuff and some filters from a computer which had not been despoiled by 2007, and transferred these to the computer with problems, and all is back to normal. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "rufus" wrote in message ... Anybody find a real solution to this problem? "XianGW" wrote: That has not removed the problem for me, any further thoughts? "Jon Peltier" wrote: Pete - Thanks for following up and sharing your experiences. Have you noticed any ill effects on 2007? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "ExcelFan" wrote in message ... Jon, I did some further digging and was able to find a solution. I'll include my solution just in case it might help someone in the community... Microsoft shared files are located here... C:\Program Files\Common Files\Microsoft Shared\Grphflt I simply took an Excel 2000 version of the gif filter (GIFIMP32.FLT) from another computer and copied it to the above-mentioned directory, thereby replacing what was an Excel 2007 version of the gif filter. Now exporting gif's in Excel 2000 is as it has always been, flawless. I thank you for your help. I couldn't have done it without you. -- Regards, Pete "Jon Peltier" wrote: I noticed this problem on one of my computers. The filters in the Microsoft Shared folder are all newer than Office 2003, dated in 2006. Except for the TIFF filter, which is still dated 2000, and the export to TIFF still works. I tried to reinstall Office 2003's filters, but apparently it checks the file date stamp prior to overwriting, and the files didn't change. I didn't yet try deleting the filters then reinstalling. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "ExcelFan" wrote in message ... Tushar, thank you for your response. If the GIF filter was somehow removed by the install of Excel 2007b2, do you think reinstalling Excel 2000 would be a reasonable fix? BTW - I believe you helped me with a charting issue many years ago and I'd just like to thank you for taking the time to help me and the Excel community. "Tushar Mehta" wrote: In article , says... I've used the following Visual Basic code in Excel 2000 to export a chart to GIF. However, after installing Excel 2007b2 I now get errors (method of export failed) when using the same old code in Excel 2000 and cannot export. Does anybody know if something has changed? ActiveSheet.ChartObjects(1).Activate ActiveChart.Export Filename:="C:\Documents and Settings\user\My Documents\mychart.gif", filtername:="gif" Maybe, installing 2007 Beta2 removed the filter needed to export as a GIF? -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
#14
Posted to microsoft.public.excel.charting
|
|||
|
|||
Export chart to GIF no longer works after installing Excel 200
First, check the filters in
C:\Program Files\Common Files\Microsoft Shared\GRPHFLT I ultimately copied a filter from another computer into this directory, but I'll warn you to copy the filters already there in case the swap didn't help. Below are the registry changes I followed to re-enable TIFF exports (for some reason exporting didn't work until I'd also included the import keys). These matched settings in another computer which didn't exist in the target PC. All the normal caveats apply about backing up the registry first and being careful about which parts you hack at with a flint axe. ======== HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Graphics Filters\Export Modify string "Image API Enabled Filters", new value to include "TIFF" with others in space-delimited list Add key "TIFF" Add string "Extensions", value "tif" Add string "Name", value "Tag Image File Format" Add string "Path", value {path using short file name to the filter} e.g., "C:\PROGRA~1\COMMON~1\MICROS~1\GRPHFLT\TIFFIM32.FL T" HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Graphics Filters\Import Modify string "Image API Enabled Filters", new value to include "TIFF" with others in space-delimited list Add key "TIFF" Add string "Extensions", value "tif" Add string "ExtensionsEx", value "tif tiff" Add string "Name", value "Tag Image File Format" Add string "Path", value {path using short file name to the filter} e.g., "C:\PROGRA~1\COMMON~1\MICROS~1\GRPHFLT\TIFFIM32.FL T" ======== - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "rufus" wrote in message ... Office 2003 and OWC both 10 and 11. Worked just fine untill IE7 was installed. Which filters registry stuff should I look for and where? Rufus "Jon Peltier" wrote: Which version(s) of Excel are installed, and in which order were they installed (and uninstalled if you removed them)? I had issues with some of the filters after uninstalling 2007 (which I'd installed in parallel with 2003). I ended up copying some registry stuff and some filters from a computer which had not been despoiled by 2007, and transferred these to the computer with problems, and all is back to normal. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "rufus" wrote in message ... Anybody find a real solution to this problem? "XianGW" wrote: That has not removed the problem for me, any further thoughts? "Jon Peltier" wrote: Pete - Thanks for following up and sharing your experiences. Have you noticed any ill effects on 2007? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "ExcelFan" wrote in message ... Jon, I did some further digging and was able to find a solution. I'll include my solution just in case it might help someone in the community... Microsoft shared files are located here... C:\Program Files\Common Files\Microsoft Shared\Grphflt I simply took an Excel 2000 version of the gif filter (GIFIMP32.FLT) from another computer and copied it to the above-mentioned directory, thereby replacing what was an Excel 2007 version of the gif filter. Now exporting gif's in Excel 2000 is as it has always been, flawless. I thank you for your help. I couldn't have done it without you. -- Regards, Pete "Jon Peltier" wrote: I noticed this problem on one of my computers. The filters in the Microsoft Shared folder are all newer than Office 2003, dated in 2006. Except for the TIFF filter, which is still dated 2000, and the export to TIFF still works. I tried to reinstall Office 2003's filters, but apparently it checks the file date stamp prior to overwriting, and the files didn't change. I didn't yet try deleting the filters then reinstalling. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "ExcelFan" wrote in message ... Tushar, thank you for your response. If the GIF filter was somehow removed by the install of Excel 2007b2, do you think reinstalling Excel 2000 would be a reasonable fix? BTW - I believe you helped me with a charting issue many years ago and I'd just like to thank you for taking the time to help me and the Excel community. "Tushar Mehta" wrote: In article , says... I've used the following Visual Basic code in Excel 2000 to export a chart to GIF. However, after installing Excel 2007b2 I now get errors (method of export failed) when using the same old code in Excel 2000 and cannot export. Does anybody know if something has changed? ActiveSheet.ChartObjects(1).Activate ActiveChart.Export Filename:="C:\Documents and Settings\user\My Documents\mychart.gif", filtername:="gif" Maybe, installing 2007 Beta2 removed the filter needed to export as a GIF? -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
#15
Posted to microsoft.public.excel.charting
|
|||
|
|||
Export chart to GIF no longer works after installing Excel 200
Jon,
I did what you suggested but still no game. Strange though : when I use the command : graph.ExportPicture filename, "GIF" the IE7 error message states: "The specified protocol is unknown" when I use the command : graph.ExportPicture filename, "xxx" the IE7 error message states: "unkown type graphic filter" The first message is in english and I assume this is because I have the english OS installed. The second message is in dutch which I assume is due to the fact that my office version is in dutch. What can we conclude from this strange result? thanks for your efforts and time BTW ;) "Jon Peltier" wrote: First, check the filters in C:\Program Files\Common Files\Microsoft Shared\GRPHFLT I ultimately copied a filter from another computer into this directory, but I'll warn you to copy the filters already there in case the swap didn't help. Below are the registry changes I followed to re-enable TIFF exports (for some reason exporting didn't work until I'd also included the import keys). These matched settings in another computer which didn't exist in the target PC. All the normal caveats apply about backing up the registry first and being careful about which parts you hack at with a flint axe. ======== HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Graphics Filters\Export Modify string "Image API Enabled Filters", new value to include "TIFF" with others in space-delimited list Add key "TIFF" Add string "Extensions", value "tif" Add string "Name", value "Tag Image File Format" Add string "Path", value {path using short file name to the filter} e.g., "C:\PROGRA~1\COMMON~1\MICROS~1\GRPHFLT\TIFFIM32.FL T" HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Graphics Filters\Import Modify string "Image API Enabled Filters", new value to include "TIFF" with others in space-delimited list Add key "TIFF" Add string "Extensions", value "tif" Add string "ExtensionsEx", value "tif tiff" Add string "Name", value "Tag Image File Format" Add string "Path", value {path using short file name to the filter} e.g., "C:\PROGRA~1\COMMON~1\MICROS~1\GRPHFLT\TIFFIM32.FL T" ======== - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "rufus" wrote in message ... Office 2003 and OWC both 10 and 11. Worked just fine untill IE7 was installed. Which filters registry stuff should I look for and where? Rufus "Jon Peltier" wrote: Which version(s) of Excel are installed, and in which order were they installed (and uninstalled if you removed them)? I had issues with some of the filters after uninstalling 2007 (which I'd installed in parallel with 2003). I ended up copying some registry stuff and some filters from a computer which had not been despoiled by 2007, and transferred these to the computer with problems, and all is back to normal. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "rufus" wrote in message ... Anybody find a real solution to this problem? "XianGW" wrote: That has not removed the problem for me, any further thoughts? "Jon Peltier" wrote: Pete - Thanks for following up and sharing your experiences. Have you noticed any ill effects on 2007? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "ExcelFan" wrote in message ... Jon, I did some further digging and was able to find a solution. I'll include my solution just in case it might help someone in the community... Microsoft shared files are located here... C:\Program Files\Common Files\Microsoft Shared\Grphflt I simply took an Excel 2000 version of the gif filter (GIFIMP32.FLT) from another computer and copied it to the above-mentioned directory, thereby replacing what was an Excel 2007 version of the gif filter. Now exporting gif's in Excel 2000 is as it has always been, flawless. I thank you for your help. I couldn't have done it without you. -- Regards, Pete "Jon Peltier" wrote: I noticed this problem on one of my computers. The filters in the Microsoft Shared folder are all newer than Office 2003, dated in 2006. Except for the TIFF filter, which is still dated 2000, and the export to TIFF still works. I tried to reinstall Office 2003's filters, but apparently it checks the file date stamp prior to overwriting, and the files didn't change. I didn't yet try deleting the filters then reinstalling. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "ExcelFan" wrote in message ... Tushar, thank you for your response. If the GIF filter was somehow removed by the install of Excel 2007b2, do you think reinstalling Excel 2000 would be a reasonable fix? BTW - I believe you helped me with a charting issue many years ago and I'd just like to thank you for taking the time to help me and the Excel community. "Tushar Mehta" wrote: In article , says... I've used the following Visual Basic code in Excel 2000 to export a chart to GIF. However, after installing Excel 2007b2 I now get errors (method of export failed) when using the same old code in Excel 2000 and cannot export. Does anybody know if something has changed? ActiveSheet.ChartObjects(1).Activate ActiveChart.Export Filename:="C:\Documents and Settings\user\My Documents\mychart.gif", filtername:="gif" Maybe, installing 2007 Beta2 removed the filter needed to export as a GIF? -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
#16
Posted to microsoft.public.excel.charting
|
|||
|
|||
Export chart to GIF no longer works after installing Excel 200
In my case, PNG and GIF were working but TIF was not. I followed the
protocol and was able to make TIF work, but I was unsuccessful following the same for BMP. Once localization issues come into play I am not competent to comment further. I have a set of utilities that work great on English machines but behave erratically in various foreign versions. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "rufus" wrote in message ... Jon, I did what you suggested but still no game. Strange though : when I use the command : graph.ExportPicture filename, "GIF" the IE7 error message states: "The specified protocol is unknown" when I use the command : graph.ExportPicture filename, "xxx" the IE7 error message states: "unkown type graphic filter" The first message is in english and I assume this is because I have the english OS installed. The second message is in dutch which I assume is due to the fact that my office version is in dutch. What can we conclude from this strange result? thanks for your efforts and time BTW ;) "Jon Peltier" wrote: First, check the filters in C:\Program Files\Common Files\Microsoft Shared\GRPHFLT I ultimately copied a filter from another computer into this directory, but I'll warn you to copy the filters already there in case the swap didn't help. Below are the registry changes I followed to re-enable TIFF exports (for some reason exporting didn't work until I'd also included the import keys). These matched settings in another computer which didn't exist in the target PC. All the normal caveats apply about backing up the registry first and being careful about which parts you hack at with a flint axe. ======== HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Graphics Filters\Export Modify string "Image API Enabled Filters", new value to include "TIFF" with others in space-delimited list Add key "TIFF" Add string "Extensions", value "tif" Add string "Name", value "Tag Image File Format" Add string "Path", value {path using short file name to the filter} e.g., "C:\PROGRA~1\COMMON~1\MICROS~1\GRPHFLT\TIFFIM32.FL T" HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Graphics Filters\Import Modify string "Image API Enabled Filters", new value to include "TIFF" with others in space-delimited list Add key "TIFF" Add string "Extensions", value "tif" Add string "ExtensionsEx", value "tif tiff" Add string "Name", value "Tag Image File Format" Add string "Path", value {path using short file name to the filter} e.g., "C:\PROGRA~1\COMMON~1\MICROS~1\GRPHFLT\TIFFIM32.FL T" ======== - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "rufus" wrote in message ... Office 2003 and OWC both 10 and 11. Worked just fine untill IE7 was installed. Which filters registry stuff should I look for and where? Rufus "Jon Peltier" wrote: Which version(s) of Excel are installed, and in which order were they installed (and uninstalled if you removed them)? I had issues with some of the filters after uninstalling 2007 (which I'd installed in parallel with 2003). I ended up copying some registry stuff and some filters from a computer which had not been despoiled by 2007, and transferred these to the computer with problems, and all is back to normal. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "rufus" wrote in message ... Anybody find a real solution to this problem? "XianGW" wrote: That has not removed the problem for me, any further thoughts? "Jon Peltier" wrote: Pete - Thanks for following up and sharing your experiences. Have you noticed any ill effects on 2007? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "ExcelFan" wrote in message ... Jon, I did some further digging and was able to find a solution. I'll include my solution just in case it might help someone in the community... Microsoft shared files are located here... C:\Program Files\Common Files\Microsoft Shared\Grphflt I simply took an Excel 2000 version of the gif filter (GIFIMP32.FLT) from another computer and copied it to the above-mentioned directory, thereby replacing what was an Excel 2007 version of the gif filter. Now exporting gif's in Excel 2000 is as it has always been, flawless. I thank you for your help. I couldn't have done it without you. -- Regards, Pete "Jon Peltier" wrote: I noticed this problem on one of my computers. The filters in the Microsoft Shared folder are all newer than Office 2003, dated in 2006. Except for the TIFF filter, which is still dated 2000, and the export to TIFF still works. I tried to reinstall Office 2003's filters, but apparently it checks the file date stamp prior to overwriting, and the files didn't change. I didn't yet try deleting the filters then reinstalling. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "ExcelFan" wrote in message ... Tushar, thank you for your response. If the GIF filter was somehow removed by the install of Excel 2007b2, do you think reinstalling Excel 2000 would be a reasonable fix? BTW - I believe you helped me with a charting issue many years ago and I'd just like to thank you for taking the time to help me and the Excel community. "Tushar Mehta" wrote: In article , says... I've used the following Visual Basic code in Excel 2000 to export a chart to GIF. However, after installing Excel 2007b2 I now get errors (method of export failed) when using the same old code in Excel 2000 and cannot export. Does anybody know if something has changed? ActiveSheet.ChartObjects(1).Activate ActiveChart.Export Filename:="C:\Documents and Settings\user\My Documents\mychart.gif", filtername:="gif" Maybe, installing 2007 Beta2 removed the filter needed to export as a GIF? -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there any way to export your Chart from Excel to Word | Excel Worksheet Functions | |||
Chart Titles not showing in excel chart Window | Excel Discussion (Misc queries) | |||
works document trying to read in excel | New Users to Excel | |||
Copy and paste Excel chart in Word -- font compresses | Charts and Charting in Excel | |||
Pasting excel chart into powerpoint | Charts and Charting in Excel |