Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting Images in Excel 2007
I have created for a client a Reporting Services report that includes images.
When I export the report from Reporting Services into Excel 2003 and then sort, the images sort along with the data. However, in Excel 2007, the images do not sort. I have created some instructions for the client on what to do in order to get the images to sort, but the client is not happy. What is different from 2007 to 2003? Does anyone have any suggestions that can allow the exported Reporting Services report to sort images in Excel 2007 right out of the box? Here is what I have to do now to get them to sort. 9 steps is a bit daunting to the client: 1. Click on any one of the images. 2. Hit Ctrl-Shift-Spacebar on your keyboard. This will select all of the images. 3. Right-click on one of the images and choose €śSize and Properties€ť 4. Click on the Properties Tab 5. Choose €śMove but Dont Size With Cells€ť 6. Click on the Size Tab 7. Under €śSize and Rotate€ť, change Height from 0.7€ť to 0.6€ť. You can do this by clicking once on the down arrow next to the size. 8. Click the close button 9. Click into the Mark Column 10. On the toolbar, choose Data 11. You can now sort and the images will sort with the data. Thanks in advance for any help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting Images in Excel 2007
This code will do the same as your manual steps
Sub FixPicture() ' ' Macro1 Macro ' Macro recorded 8/7/2009 by Joel ' For Each shp In ActiveSheet.Shapes shp.Placement = xlMove shp.Height = 0.6 Next shp End Sub "Lis" wrote: I have created for a client a Reporting Services report that includes images. When I export the report from Reporting Services into Excel 2003 and then sort, the images sort along with the data. However, in Excel 2007, the images do not sort. I have created some instructions for the client on what to do in order to get the images to sort, but the client is not happy. What is different from 2007 to 2003? Does anyone have any suggestions that can allow the exported Reporting Services report to sort images in Excel 2007 right out of the box? Here is what I have to do now to get them to sort. 9 steps is a bit daunting to the client: 1. Click on any one of the images. 2. Hit Ctrl-Shift-Spacebar on your keyboard. This will select all of the images. 3. Right-click on one of the images and choose €śSize and Properties€ť 4. Click on the Properties Tab 5. Choose €śMove but Dont Size With Cells€ť 6. Click on the Size Tab 7. Under €śSize and Rotate€ť, change Height from 0.7€ť to 0.6€ť. You can do this by clicking once on the down arrow next to the size. 8. Click the close button 9. Click into the Mark Column 10. On the toolbar, choose Data 11. You can now sort and the images will sort with the data. Thanks in advance for any help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting Images in Excel 2007
Thanks. That is a bit better than giving them all those steps, but I still
have the issue that the people using the report are all over the place. I don't have access to their machines, and I don't know how to build a macro into the excel sheet that Reporting Services spits out. Is there something I can have them do in Excel 2007 that will make it behave like Excel 2003? "Joel" wrote: This code will do the same as your manual steps Sub FixPicture() ' ' Macro1 Macro ' Macro recorded 8/7/2009 by Joel ' For Each shp In ActiveSheet.Shapes shp.Placement = xlMove shp.Height = 0.6 Next shp End Sub "Lis" wrote: I have created for a client a Reporting Services report that includes images. When I export the report from Reporting Services into Excel 2003 and then sort, the images sort along with the data. However, in Excel 2007, the images do not sort. I have created some instructions for the client on what to do in order to get the images to sort, but the client is not happy. What is different from 2007 to 2003? Does anyone have any suggestions that can allow the exported Reporting Services report to sort images in Excel 2007 right out of the box? Here is what I have to do now to get them to sort. 9 steps is a bit daunting to the client: 1. Click on any one of the images. 2. Hit Ctrl-Shift-Spacebar on your keyboard. This will select all of the images. 3. Right-click on one of the images and choose €śSize and Properties€ť 4. Click on the Properties Tab 5. Choose €śMove but Dont Size With Cells€ť 6. Click on the Size Tab 7. Under €śSize and Rotate€ť, change Height from 0.7€ť to 0.6€ť. You can do this by clicking once on the down arrow next to the size. 8. Click the close button 9. Click into the Mark Column 10. On the toolbar, choose Data 11. You can now sort and the images will sort with the data. Thanks in advance for any help. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting Images in Excel 2007
I'm not an expert on registry but the may be a setting that will do this.
Maybe the better solution is to distrute the file as 2007 (xlsx) and make the 2003 users download the microsoft to that allows them to use xlsx files. Or distribute the fil as both 2003 and 2007. "Lis" wrote: Thanks. That is a bit better than giving them all those steps, but I still have the issue that the people using the report are all over the place. I don't have access to their machines, and I don't know how to build a macro into the excel sheet that Reporting Services spits out. Is there something I can have them do in Excel 2007 that will make it behave like Excel 2003? "Joel" wrote: This code will do the same as your manual steps Sub FixPicture() ' ' Macro1 Macro ' Macro recorded 8/7/2009 by Joel ' For Each shp In ActiveSheet.Shapes shp.Placement = xlMove shp.Height = 0.6 Next shp End Sub "Lis" wrote: I have created for a client a Reporting Services report that includes images. When I export the report from Reporting Services into Excel 2003 and then sort, the images sort along with the data. However, in Excel 2007, the images do not sort. I have created some instructions for the client on what to do in order to get the images to sort, but the client is not happy. What is different from 2007 to 2003? Does anyone have any suggestions that can allow the exported Reporting Services report to sort images in Excel 2007 right out of the box? Here is what I have to do now to get them to sort. 9 steps is a bit daunting to the client: 1. Click on any one of the images. 2. Hit Ctrl-Shift-Spacebar on your keyboard. This will select all of the images. 3. Right-click on one of the images and choose €śSize and Properties€ť 4. Click on the Properties Tab 5. Choose €śMove but Dont Size With Cells€ť 6. Click on the Size Tab 7. Under €śSize and Rotate€ť, change Height from 0.7€ť to 0.6€ť. You can do this by clicking once on the down arrow next to the size. 8. Click the close button 9. Click into the Mark Column 10. On the toolbar, choose Data 11. You can now sort and the images will sort with the data. Thanks in advance for any help. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting Images in Excel 2007
Thanks, Joel.
"Joel" wrote: I'm not an expert on registry but the may be a setting that will do this. Maybe the better solution is to distrute the file as 2007 (xlsx) and make the 2003 users download the microsoft to that allows them to use xlsx files. Or distribute the fil as both 2003 and 2007. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 and inserted images | Excel Programming | |||
Creating Images in Excel 2007 | Excel Discussion (Misc queries) | |||
imported images in Excel 2007 | Excel Discussion (Misc queries) | |||
How do you print images in excel 2007 | Excel Discussion (Misc queries) | |||
print images in excel 2007 | Excel Discussion (Misc queries) |