You'll be able to ask any tech support questions, or chat with the community and help others.

If you are sharing a database over a network, other users could be changing data while you are viewing the same data in a datasheet or form.

' -------------------------------------------------------------------------------- ' You are free to use this code within your own applications, add-ins, ' documents etc but you are expressly forbidden from selling or ' otherwise distributing this source code without prior consent.

access screenupdating-73

Raise Number:=vb Object Error ERR_WINDOW_LOCK_FAIL, _ Description:="Unable to set a Power Point window lock" Exit Property End If Else ' Unlock the Window to refresh Lock Window Update (0&) Update Window (hwnd) hwnd = 0 End If End Property 'Sample Usage: Sub Long Processing Sub() ' Lock screen redraw Screen Updating=False ' --- Long time consuming code ' Redraw screen again Screen Updating=True ' Also see below article for another example of usage of the code End Sub It's fairly simple to open a Power Point file (*.ppt) for editing using VBA code however opening a Power Point Show (*.pps) file for editing is altogether another matter. Open method and it defaults to open the file in Slide Show mode. The routine below illustrates a manner of woring around the default behaviour and opening the file for editing.

This page lists some suggestions and strategies for optimizing your Visual Basic For Applications (VBA) code, so that it will run faster.

and you thought excel was just for adding up numbers.

Excel & Word have the Screen Updating method thru which a developer can lock the main window from unnecessarily redrawing itself whilst the macro is being executed. If left alone, redrawing is not only ugly on the eyes it also takes more time for the macro to reach completion.

Hence I created this generic wrapper to lock the window updates.

' -------------------------------------------------------------------------------- ' Copyright 1999-2015, Shyam Pillai, All Rights Reserved.BTW I'd be happy to show you the results of my attempts so far, but i don't see any possibility to mail / attach the file from here. cewl, dont know if this is any help but a few other excel games here know there is a thread somewhere on this forum where someone posted a few more, but for the life of me cant find it. I can point you to a download location or mail the (120 KB) to you. Regards, Gijs Hi all, A sample of what i am making can be found at Please don't run it inside Internet Explorer (It won't work), but save it locally first and then run it from within a real Excel client. Also there is a very weird person out there who does spreadsheet art! This is much much faster than drawing directly to the window DC. Using system wide API calls also doesn't pass any beauty contests. More of my own inventions (or better: re-creations) can be found at: More games (but as I recently discovered, other people did the same and better) Some Bitmap To ASCII Draw And a Bitmap Viewer/ About this last one i have a question. Some of this is covered in Steve Brown's book "Visual Basic Developer's Guide to the Win32 API". The reason that i am doing this: I want to make games that can be played in a corporate environment without being detected. It takes quite some time to get the image onscreen, because it seems to be impossible to copy an array containing the pixel colors into the . For example, if you have three worksheets ("Sheet1", "Sheet2", and "Sheet3") in a workbook ("My Workbook"), you can reference "Sheet2" with either Whenever you can, declare values as constants, rather than variables.