Excel icon not showing for 0LE linked object

JBBooks · Joined: 04 Oct 2007 Posts: 3

I have a VB6 application that has OLE links to several excel spreadsheets.
When I first built the application, several years ago, the links showed the
icon for excel. I've recently made some mods to the application and the
links no longer show the excel icon, however the links do work. I've tried
specifying different icons for the linked object and it seems that any icon
specified with a '.ico' extension will work but non of the microsoft excel
icons work. I've made sure that 'Display as Icon' checkbox is checked.
This app was originally written in VB6 on an NT machine. I am still using
VB6 but my pc is XP pro SP2.

Has anyone experienced this? Any thoughts or suggestions will be helpful.

Thanks
Jim

Archived from group: microsoft>public>vb>ole

JBBooks · Joined: 04 Oct 2007 Posts: 3

Also forgot to mention that I'm now using Microsoft Office Professional
Edition 2003 and the app was originally written using a much earlier version
of office.

Jim K

"JBBooks" wrote in message @ptd.net...
>I have a VB6 application that has OLE links to several excel spreadsheets.
>When I first built the application, several years ago, the links showed the
>icon for excel. I've recently made some mods to the application and the
>links no longer show the excel icon, however the links do work. I've tried
>specifying different icons for the linked object and it seems that any icon
>specified with a '.ico' extension will work but non of the microsoft excel
>icons work. I've made sure that 'Display as Icon' checkbox is checked.
>This app was originally written in VB6 on an NT machine. I am still using
>VB6 but my pc is XP pro SP2.
>
> Has anyone experienced this? Any thoughts or suggestions will be helpful.
>
> Thanks
> Jim
>

JBBooks · Joined: 04 Oct 2007 Posts: 3

More information-

It seems that Microsoft Office Professional 2003 is in error. All earlier
releases of Office will permi the Excel Icon to be displayed on linked
objects.

FWIW - I've used a different icon as a work-around.

Jim K

"JBBooks" wrote in message @ptd.net...
>I have a VB6 application that has OLE links to several excel spreadsheets.
>When I first built the application, several years ago, the links showed the
>icon for excel. I've recently made some mods to the application and the
>links no longer show the excel icon, however the links do work. I've tried
>specifying different icons for the linked object and it seems that any icon
>specified with a '.ico' extension will work but non of the microsoft excel
>icons work. I've made sure that 'Display as Icon' checkbox is checked.
>This app was originally written in VB6 on an NT machine. I am still using
>VB6 but my pc is XP pro SP2.
>
> Has anyone experienced this? Any thoughts or suggestions will be helpful.
>
> Thanks
> Jim
>

Why can't create Excel.Application object using CreateObject Hi, there, I try to create an object using CreateObject function, I got "nothing" from the return variable without any error messages, but It works well on another computer, we have the same environment same references

Method of '~' of Object '~' Failed error for Excel WIth V Hi, I face a specific problem in running a macro from vb.The vb program does this:- open an excel sheet containing macros and the sheet on which i have the run the macro on.On running a macro on a specific sheet i get the error -2147417851 - Method of '

Insert page break into Excel Ole object from vb6 I've got an Excel spreadsheet created and opened as an OLE object; I can load values to it, set the font, the margins, but I just can't find a way to insert a pagebreak. I cut and paste from an Excel macro: and that didn't work; I'm hopi

replace Excel 2000 -> Excel 2003 I am using the following code to edit data cell by cell: What:="", I get a Microsoft error "Microsoft Excel cannot find any data to replace. Check if your search formatting and criteria are defined correctly. I

Excel chart from VB to Excel Hi I've a Chart object in a VB6 form together with some text boxes, my question is can I "copy" the chart object from the form and place it in a Excel chart ?? I know I can create the chart in a Excel my question is can I