Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify Insert Object Macro
I need to modify the following macro so that it will pop up the Insert Object dialog box, but not have Link to File or Display as icon preselected. 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify Insert Object Macro
When I tried to change the tab from "Create New" to "Create from File" with
your code my XL 2003 crashed. Maybe you can adapt the arguments in the following to your needs - Sub test() Dim bOkCancel As Boolean 'args: object_class, file_name, link_logical, display_icon_logical, _ icon_file, icon_number, icon_label bOkCancel = Application.Dialogs(xlDialogInsertObject).Show(, "c:\") debug.? bOkCancel End Sub Regards, Peter T "mflowers" wrote in message ... I need to modify the following macro so that it will pop up the Insert Object dialog box, but not have Link to File or Display as icon preselected. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i prepare a macro to insert drawing object on specific cell | Excel Discussion (Misc queries) | |||
Macro to insert an object in a specific cell 2007` | Excel Discussion (Misc queries) | |||
Macro to Insert Object with browsing ability | Excel Programming | |||
Macro to insert a object in excel | Excel Discussion (Misc queries) | |||
Macro to insert object into spreadsheet ?? | Excel Programming |