How to pass parameter in "open" function

  • Thread starter Thread starter Vinay
  • Start date Start date
V

Vinay

Hi,
I am launching Excel application using open function in my VBA macro.I want
to pass one parameter to newly launched Excel.Plz suggest me how to do it?

regds
vinay
 
Hi
what are you exactly trying to do. do you want to insert a
value in a cell of this new workbook?
 
Dear Sir,
Thanks for your reply.
No I don't want that.I have written on VBA macro and which I load in
Excel.This macro creates one toolbar button.On clicking of this button one
browser dialog box comes from which user can select file name and once user
say ok after selecting file name NEW excel is getting launhced up and
original Excel is getting closed..Now in this New excel I want to get the
name of file what user has selected from browser window.Since new excel will
be a new object and so I don't know how to get <FileName value> from
original Execl object.

Regds
vinay
 
Back
Top