Thread: Insert obect
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Insert obect

You can open a dailog method like below

dlgAnswer = Application.Dialogs(xlDialogOpen).Show


"Naz" wrote:

Hi

I'm trying to create a button that replicates InsertObject, then from file
as icon.
I've tried recording the action but it either record nothing if i choose no
file, or the test file location but then i can figure out how to make sort of
prompt? Does anyone know who to do this?

All help is appreciated
--

_______________________
Naz,
London