Excel Automation question

Topic

New Reply

I’m sure this is a straightforward one, but here goes anyway. I’m using A97 to update an Excel 97 spreadsheet. I want the sheet to be hidden while the updating is done, and then saved. When the user opens the sheet I want the workbook to be visible…but it isn’t. I have to Windows/Unhide… to make it visible. Any idea why this code does not work :

Set objXLApp = New Excel.Application
Set objXLBook = objXLApp.Workbooks.Open(“k:crewharareoffice.xls”)
…
The updating bit of code
…
objXLSheet.Visible = True
objXLBook.Application.Visible = True
objXLBook.Save
objXLBook.Application.Quit

Thanks for your help

Nick

Reply | Quote

Replies

you might could try this i’m using access 2000
but it might work in 97 i don’t really know but i thought it might help
Set objXLBook = objXLApp.Workbooks.Open(“k:crewharareoffice.xls”, vbMaximizedFocus)
HTH

Reply | Quote