Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA: sheet in background
All gurus,
until now I open an excel sheet before the macro read from it, or create an excel sheet before the macro write to it as follows: Workbooks.Open FileName:=MyFileName Sheets(MySheet).Select (read from the sheet......) or Workbooks.Add (write to it ......) This way I see each sheet opened or created, a cell is written, ...... (Maybe this causes the macro running very slowly?) Is it possible to read from or write to an excel sheet without displaying it in the excel window? Just as, if we open a text file and do reading or writing, we don't need to open it with notepad. Everything is done in the background. Many thanks in advance! w.wang |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set background on the Excel sheet | Excel Discussion (Misc queries) | |||
Sheet Background does not print | Excel Worksheet Functions | |||
Don't want to tile sheet background | New Users to Excel | |||
Sheet Background | Excel Programming | |||
Sheet Background Color | Excel Discussion (Misc queries) |