Thanks but the issue as I described it is that the modified workbooks even
though the icons display do not display when opened. When I attempt to open
them, the Excel application opens but not the workbooks themselves. And the
task manager then shows just the Excel app but again not the workbooks open.
The workbooks open fine before they are modified by the VB6 code but not
afterwards-and I can't see anything in the code that would create a problem.
I'm using Office 2003 and VB6-I am wondering if some of the code syntax in
Excel VBA changed from Office 2000 when went to Office 2003-some of my
automation code in VB6 for modifying the workbooks dates back to Office 2000.
Thanks again,
Van

"Ralph" wrote:

Sounds like the Excel application is not closing. Check Task Manager to see
if Excel is still running after you close it.

"VanS" wrote:

Hello,
I was testing VB code to modify the interface of VBA-programmed Excel
workbooks. Afterwards the two workbooks were shown in their folder and the
interface of one of the worksheets was displayed to the side, but when I
attempt to open either of the two books, Excel app opens but not the specific
workbooks themselves. It just shows the Excel workbook bar at top but empty
of contents. I can open the properties for either of the workbooks and it
shows the Hidden feature is unchecked.
Also if I try to rename the folder the two Workbooks are in, it gives an
error now saying that Access is Denied and can't do so.
Any idea of what happened, and/or how I can get the workbooks to display and
open?
Thanks, God bless
.