Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening workbook in invisible mode?
This code doesn't quite do what I want:
Set wbRemote = Workbooks.Open(temp, , True) First, it opens the workbooks visibly, while I wish it to open in a hidden state. Second (probably due to the first), it changes the ActiveWorkbook. I also tried this Set xlTmp = New Excel.Application xlTmp.Workbooks.Open temp, , True This works, but I it lacks in clarity. I like having a Workbook object to refer to, rather than the Excel.Application object, which I'm less familiar with. Any hints on how to get a Workbook object referring to an open (but invisible) workbook? Gustaf |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
command button invisible upon opening file | Excel Programming | |||
File Invisible on opening | Excel Discussion (Misc queries) | |||
Why is ActiveX invisible in Design mode | Excel Programming | |||
Vb macros to schedule the excel sheet invisible mode | Excel Programming | |||
Set Workbook to invisible? | Excel Programming |