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: 1
Default Excel causing

I'm using VB to open and read/write to an Excel
spreadsheet. The spreadsheet is currently 2.9 meg. The
syntax I use is:
Public Const spdsheet
= "\\servername\mainfolder\subfolder\request_log.xls "

Set wkbook = GetObject(spdsheet)
Set wksheet = wkbook.Worksheets(1)
wkbook.NewWindow

I close the workbook using the syntax:
Set wkbook = Nothing
Set wksheet = Nothing

I can do this only a few times before getting a white
screen that says: "Excel out of memory". After
acknowleging this screen I usually get the Windows blue
screen and have to reboot my PC.

I would appreciate any suggestions:

Thanks,
Berny

 
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
Excel Add-In and Dual Monitor Causing Read-Only childofthe1980s Excel Discussion (Misc queries) 1 June 3rd 10 08:49 PM
Formula causing run-time error in Excel Programming cherman Excel Worksheet Functions 2 March 15th 10 10:59 PM
Conditional formatting causing Excel to crash No Name Excel Discussion (Misc queries) 3 October 10th 08 03:35 PM
Excel bogs down when running my macros, what is causing it? Rakmup Excel Discussion (Misc queries) 2 March 19th 07 09:03 PM
Is Excel causing me system problems? Sandra Excel Discussion (Misc queries) 1 April 7th 05 09:04 PM


All times are GMT +1. The time now is 12:33 PM.

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"