Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I'm using the following code to assist users in inserting files into the Excel worksheet. It works fine, except that: 1. It shows the entire path - I'd like to see just the file name 2. It shows the Excel icon, even if it's a Word file. I know that it's because that is written in the code and know I can specify Word, etc., but can I change that so that the correct icon is displayed Thanks. ActiveSheet.Unprotect 'INSERT.OBJECT?(object_class, file_name, link_logical, ' display_icon_logical, icon_file, icon_number, icon_label) ExecuteExcel4Macro "INSERT.OBJECT?(,""C:\"",False,True,)" ActiveSheet.Protect |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert option icon | Excel Discussion (Misc queries) | |||
Icon Sets - Display icon in one cell depending upon value in anoth | Excel Worksheet Functions | |||
insert an ICON in a cell | Excel Programming | |||
Conditional Formatting icon change type problem | Excel Programming | |||
'Insert Rows Icon' | Excel Discussion (Misc queries) |