| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
attach file as icon in a worksheet (hope it's not so tricky)
i wish to create a button (from forms) and when click on it, it will pop up
the Insert Object dialog box, and automatically go to Create From File tab with Display As Icon selected. Then it allows the user to select any file to attach to the worksheet. how do i do this with the button and macro? i hope it's not the tricky one and appreciate experts out there can help. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
attach file as icon in a worksheet (hope it's not so tricky)
Not completely reliable, but:
SendKeys "{TAB}{TAB}{TAB}{TAB}{RIGHT}%a%n" Application.Dialogs(xlDialogInsertObject).Show -- Vasant "jacko" wrote in message ... i wish to create a button (from forms) and when click on it, it will pop up the Insert Object dialog box, and automatically go to Create From File tab with Display As Icon selected. Then it allows the user to select any file to attach to the worksheet. how do i do this with the button and macro? i hope it's not the tricky one and appreciate experts out there can help. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
attach file as icon in a worksheet (hope it's not so tricky)
Sub showDialog()
'INSERT.OBJECT?(object_class, file_name, link_logical, ' display_icon_logical, icon_file, icon_number, icon_label) ExecuteExcel4Macro "INSERT.OBJECT?(,""C:\"",False,True,)" End Sub -- Regards, Tom Ogilvy "jacko" wrote in message ... i wish to create a button (from forms) and when click on it, it will pop up the Insert Object dialog box, and automatically go to Create From File tab with Display As Icon selected. Then it allows the user to select any file to attach to the worksheet. how do i do this with the button and macro? i hope it's not the tricky one and appreciate experts out there can help. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
attach file as icon in a worksheet (hope it's not so tricky)
Nice one, Tom!
Regards, Vasant "Tom Ogilvy" wrote in message ... Sub showDialog() 'INSERT.OBJECT?(object_class, file_name, link_logical, ' display_icon_logical, icon_file, icon_number, icon_label) ExecuteExcel4Macro "INSERT.OBJECT?(,""C:\"",False,True,)" End Sub -- Regards, Tom Ogilvy "jacko" wrote in message ... i wish to create a button (from forms) and when click on it, it will pop up the Insert Object dialog box, and automatically go to Create From File tab with Display As Icon selected. Then it allows the user to select any file to attach to the worksheet. how do i do this with the button and macro? i hope it's not the tricky one and appreciate experts out there can help. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
attach file as icon in a worksheet (hope it's not so tricky)
Excellent!!! Billions thanks to Tom!! and Vasant too!
"Tom Ogilvy" wrote: Sub showDialog() 'INSERT.OBJECT?(object_class, file_name, link_logical, ' display_icon_logical, icon_file, icon_number, icon_label) ExecuteExcel4Macro "INSERT.OBJECT?(,""C:\"",False,True,)" End Sub -- Regards, Tom Ogilvy "jacko" wrote in message ... i wish to create a button (from forms) and when click on it, it will pop up the Insert Object dialog box, and automatically go to Create From File tab with Display As Icon selected. Then it allows the user to select any file to attach to the worksheet. how do i do this with the button and macro? i hope it's not the tricky one and appreciate experts out there can help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to attach file | Excel Worksheet Functions | |||
| HOW TO CHANGE THE ICON OF AN EXCEL WORKSHEET FILE? | Excel Discussion (Misc queries) | |||
| How do I copy a file and attach a date to the name of the file | Excel Discussion (Misc queries) | |||
| can i attach an excel icon to a word doc | Excel Discussion (Misc queries) | |||
| Open a workbook listed in a different worksheet (hope this is clearer!) | Excel Programming | |||
Linear Mode
