Hi All

How can i open new excel file with specific name through macros?
I mean like whenever we open new excel file it opens up with default name
and i would like to change this default name to some other name.
Does anyone has idea abt this?

Thanks in advance
avnish

Hi,

  Using macros, we can trap the Open() event. In that event, give a
different name to
to your excel file so that the new file which opens by default will have a
different name.
If you want I can send you some sample codes.

Cheers,
HegdeS

Thanks HegdeS 
If you could send code then it would be really helpful.

Thanks again
avnish

-----Original Message-----
From: Subraya Hegde [mailto:subrayah@i...]
Sent: Monday, May 13, 2002 7:58 AM
To: ASP+
Subject: [aspx] RE: Change default name of excel


Hi,

  Using macros, we can trap the Open() event. In that event, give a
different name to
to your excel file so that the new file which opens by default will have a
different name.
If you want I can send you some sample codes.

Cheers,
HegdeS