Recent content by CookieMonster

This is a built in problem with Xl, it does seem to get less annoying in Xl 2000, but still. The reason is that for every chart Xl opens a thread to MS Chart. It doesn't seem to remember that it already is using MS Chart. It's simply your stack going nuts. Besides this when you've found a way...

Depends on the application your using it in. In the hidden members of Excel you will also find something which is called .hasroutingslip could be very interesting if you automatically want to forward a workbook ie after each update. In Access what you could do is create a macro using the...

DCOM is the distributed version of COM. On itself it's only a model used in (distributed) application design, it allows for multiple languages components either on a client machine or distributed over a network to cooperate. The error your describing can likely be solved by typing in your run...

Another proper and fast way of doing this is simply looping through each added day, while testing if we are dealing with a weekday, if so, add a day to compensate. This function is preferred to using the weekday function, because the weekday function is an Xl reference that not all Excel users...

Reading and writing text from and to txt files is easy, the following code will do so: Function Infile_ReadText() as String Dim strFile as string Dim strText as string Dim strOutPut as string strFile="C:\Temp\Textfilename.txt" open strFile for Input as #1 While not EOf(1)...

Have you tried using sendkeys in combination with the vbKeyCodeConstants? ie 1 would be vbKey1, or a long value of 49 (&H31), in other words the Char code. Use the objectbrowser for a list of all constants. Have Fun, CookieMonster.

Hello phly9, There's a number of solutions possible to your query. Assuming that you are using ADO (ActiveX Data Objects) for your data control, one of the solutions would be to add another data control to your form which will control only the listbox, a more neater solution would be to create...