
August 23rd, 2005, 05:48 AM
|
|
Registered User
|
|
Join Date: Dec 2004
Posts: 9
Time spent in forums: 46 m 31 sec
Reputation Power: 0
|
|
VB codes in MS-Excel
Hi,
I m a new user of VB, can anybody help me in writing codes as, I need to
1. create a new excel sheet
2. specify the path
3. name the sheet
every thing I need to perform through MS-Excel marco, so that single click can perform all my predefined actions.
I have created macro by using 'Record Macro' command. But it is not allowing me to psecify the name of path.
|