Working with Excel from Word

[jille]

Hi,

I have a fairly complex Word macro that creates an Excel file from an
existing template for use within the macro. During a session the user may
need to create multiple Excel files.

I'm using the following code to open Excel and create the new file:

Public xlbookbulk As Object

then, as a separate procedure:

With Excel.Application
Workbooks.Open vPath & "\EnBulk Information.xlt"
..Application.Visible = True
Set xlbookbulk = .ActiveWorkbook
vBulkFileName = .ActiveWorkbook.Name
End With

Everything works wonderfully until the user closes the current/first Excel
file and attempts to construct a new one. The file is constructed but it
doesn't view...you can see the Excel toolbars and the formula and status bars
but the area in the centre (where the cells would normally appear) is void,
ie the screen behind is showing through.

Now if you don't close the Excel file, you can create a new one
successfully. I'm wondering if the problem might have something to do with
Excel's status in Word...it thinks it's still open but it's not?????????

Any ideas?

Thanks,
Jille