LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default workbooks.open and appliciation.screenupdating

Thanks to everyone who takes the time to post their problems
and solutions. I can usually find what I need from older
messages, but this time I've been unsuccessful, so here goes...

I'm trying to use

Application.ScreenUpdating = False
Workbooks.Open Filename:= "blah.xls"

to keep the user from seeing "blah.xls" when it is opened.
I also tried

Workbooks.Open Filename:= "blah.xls"
Windows("blah.xls").Visible = False

However, I can still "see" blah.xls on the initial open.
Perhaps I'm just too picky? :)

I've also seen something like:

ThisWorkbook.IsAddin = True on the open event of the called workbook

but I can't just stick a private sub in "blah.xls" because the whole
file is overwritten daily.

I know this can be avoided if I use an XLM macro
(example at http://www.j-walk.com/ss/excel/tips/tip82.htm)
to read data from a closed excel file, but I was wondering if there
was any other way if I use workbooks.open or if I'm using
application.screenupdating improperly. Otherwise, XLM macro it is.
Actually, if I do use an XLM macro, will there be any problems with
portability?

Thank you very much.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
about screenupdating baha Excel Discussion (Misc queries) 0 March 25th 10 06:16 AM
when i open an Excell file 3 workbooks open.Why? Iain40 Excel Discussion (Misc queries) 2 February 3rd 09 05:04 PM
When I open Excel, workbooks open automatically. How can I stop t Rhealbird Excel Discussion (Misc queries) 2 February 23rd 06 10:08 AM
Workbooks.Open closes other workbooks S. Daum Excel Programming 1 August 21st 03 07:47 PM
Workbooks.Open / .Open Text - How do you stop the .xls addition? Dave[_20_] Excel Programming 2 July 31st 03 04:03 AM


All times are GMT +1. The time now is 07:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"