opening excel worksheet from vba

dianecandice
04-01-2003, 12:38 AM
hello, i don't know if this thread already exists, anyway i really need to know how to do this, i have a command button in a form, when clicked, must open a new excel worksheet, and then fill it with data. Thanks.

Crassus
04-01-2003, 02:49 AM
Worksheets.Add

erbartle
06-30-2003, 11:58 AM
the search feature on these forums is usually pretty good an can be used to find the answers to most of these simple questions.

even before doing that you should check the VBA office assistant when you are coding macros for office. simple key words typically bring up the help you need.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum