Creating New Excel from VB - Xtreme Visual Basic Talk

12-16-2003, 11:13 AM

jcmahal

Newcomer

Join Date: Jul 2003

Location: California

Posts: 6

Creating New Excel from VB

Is there a method to create a new Excel file (if one doesn't exsist) to be written on. I've have the method of writting to the database but is having trouble find a way to create a new Excel file to write on.

12-16-2003, 12:11 PM

Mike Rosenblum Mike Rosenblum is offline

Microsoft Excel MVP

Forum Leader
* Guru *

Join Date: Jul 2003

Location: New York, NY, USA

Posts: 7,848

From Excel VBA:

Code:

Dim WB as Workbook
Set WB = Application.Workbooks.Add()

From VB 6.0:

Code:

Dim xlWB as Excel.Workbook
Set xlWB = objExcel.Workbooks.Add()

,
Mike

12-16-2003, 01:28 PM

jcmahal

Newcomer

Join Date: Jul 2003

Location: California

Posts: 6

thanks for the help, much appreciated

12-16-2003, 06:16 PM

Shibboleth Shibboleth is offline

Newcomer

Join Date: Dec 2003

Posts: 14

Additionally, you might like to use;

Code:

Application.SheetsInNewWorkbook = 1 
    Workbooks.Add

Which, as you can guess, defines how many sheets are in the new workbook. However, this change is permanent, so you might want to do something like;

Code:

CurrentNumberOfSheets = Application.SheetsInNewWorkbook
Application.SheetsInNewWorkbook = 1 
Workbooks.Add
Application.SheetsInNewWorkbook = CurrentNumberOfSheets

So that you can restore that person's 'default sheets' setting.

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Forum Rules

Forum Jump

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating a VB application but lots of Excel linking	shmail786	Excel	6	11-12-2003 03:17 AM
Creating Charts in Excel using VB	Durbz	Excel	2	09-23-2003 06:11 PM
Problems Creating Pivot tables in Excel with vb	aine	Word, PowerPoint, Outlook, and Other Office Products	0	04-15-2003 05:43 AM
QB to VB Conversion - By AIO	BillSoo	Tutors' Corner	0	08-06-2002 11:37 AM
Creating graphs in Excel from VB	u2pb	Word, PowerPoint, Outlook, and Other Office Products	30	04-11-2002 08:32 PM