Workbook is hidden after being saved by VB6 (??)

[IgnaceD]

Hi all,

I am loading a simple Excel workbook and immediately saving it without any changes in Visual Basic 6 Pro.
See code:

'Reference to Microsoft Excel Object Library 8.0 (PC with Windows 2000, Office 97)

Dim Booklet As Workbook
Set Booklet = GetObject("C:\test.xls") 'load
Booklet.Save 'save
set Booklet = nothing
(end of code)

This is all very simple, but loaded in Excel, the test.xls is now hidden. Before is was not hidden. I have to unhide it with menu Window, Unhide.
What do I have to do in the VB6 code to prevent test.xls from being hidden?

Thanks in advance.

 

[Slarti]

Try here for a basic example

http://www.freevbcode.com/ShowCode.Asp?ID=329

good luck.