Search results for query: *

Can't you use a String type instead of Memo?

It might be that your connection provider doesn't allow using the .AbsolutePage attribute (

Simple algorithm: 1. Locate all spaces (except the ones between "quotes") 2. Break up the string, using the locations from (1) 3. Check the firsy character of each piece. 4. Build your Index Server syntax, using (2) and (3)

try IsEmpty instead of IsNull...

How do you want it? Possible scenario: initially: 10 posts, 0 comments. --- 10 items on page clicking post 3, containing 3 comments: 3 posts 3 comments (from the 3rd post) 4 posts --- 10 items on page something like that? You might resolve that by creating an intermediate view that displays...

Hi there, Seeing the output, i count 9 items. I see only 5 sets of data. The loop you use to insert records, uses 9 cycles (the # of items in the form), and after 5 valid inserts, the 6th - 9th insert statement will look as follows: Insert into answers...

It's NOT fast (minutes) but: Sub EmptySheet() For r = 1 To 65355 For c = 1 To 256 If Worksheets(1).Cells(r, c) <> "" Then e = e + 1 Next c Next r If e > 0 Then MsgBox ("Not Empty") Else MsgBox ("Empty sheet!!") End Sub

Hi, Building a Bitmap Editor in Excel (which uses a colored cell for every pixel), i can now import 24-bit bitmaps into an Excel sheet. The VBA script does this: 1 read the pixels of the bitmap and put them in an array 2 stretch or shrink the array to 256 cols and enough rows to keep the...

Hi All, Thanks for your tips! I liked most of the games you pointed me to. 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) home.1asphost.com/gijsterbeek/SnakeXL.xls...

Hi all, A sample of what i am making can be found at http://home.1asphost.com/gijsterbeek/shootemXL.xls 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. Everything at your own risk. Regards, Gijs.

I'm into VBA only for half a year or so, so I've not yet figured out how to call / use DirectX from it. Suggestions are welcome!

Well, I've made some improvement with this combination: LockWindowUpdate (FindWindow("XLMAIN", vbNullString)) Call SendMessage(FindWindow("XLMAIN", vbNullString), _ WM_SETREDRAW, 0&, ByVal 0&) UpdateObjects Call SendMessage(FindWindow("XLMAIN", vbNullString), _...

Hi, I'm building a 3D first person shooter in Excel at the moment, using autoshapes to draw the environment background (ground, air) and objects (buildings, bad guys, shadows). To get the framerate smooth, i have tried several options, with poor results: Application.ScreenUpdating Gives me...