|
-
February 21st, 2000, 01:00 PM
#1
Excel VBA
I am calling Excel(2000/97)objects in my VB application. After importing data into my workbook, saving it under a new file name and quiting Excel, I would get only the frames of an Excel application without Excel contents in the client area if I attempt to display another Excel file in my application. If I exit my VB application, then I can display the Excel window properly. I tried refreshing the window without success. I tried to close all of my workbooks by using:
Workbooks.Close
It did not work either.
I used the codes like the following to define my workbook:
Dim Wkb As Workbook
Set Wkb = Workbooks.Add
What did I do wrong?
Thanks in advance.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|