View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joyce Joyce is offline
external usenet poster
 
Posts: 106
Default Hlp - Display only file name when Insert Object As Icon

Hi,

I'm wondering how I would insert *only* the file name (not the path) when
using the following:

ExecuteExcel4Macro "INSERT.OBJECT?(,""C:\"",False,True,)"

I tried adding:
IconLabel:=Mid(strFile, InStrRev(strFile, "\") + 1)

As helped in another macro, but it didn't work.
Thanks.