Search results for query: *

To All, Thanks everyone for your tips. It took some time but I finally got it. I appreciate the fact that you make people figure it out on there own and make them think a little. Sometimes it takes a little hint to get the brain working in the right direction. Best Regards, Dstrat6

Hellow Golom, VBA Excel 2000 doesn't allow me to implement Me.TimerInterval, Is there a certain Reference that has to be checked off. I also see that you you were calling a form. Does this have to be done with a form or can it also be used with a Worksheet? Regards, Dstrat

Hi everyone, I need to be pointed in the right direction on how to configure a label to read the current time(Now) but continuously. I have it working with Selection Change but really would like it to update itself with out doing anything. Any pointers would be great! Regards, Dstrat

Have you tried, Private Sub Worksheet_SelectionChange(ByVal Target As Range) Regards, dstrat

Hi fumei, thanks for the heads up I've never really used Select statements. Maybe it's time I start practicing. Regards, Dstrat

Hi eggyboy in case you haven't figured out your problem on your own. I did some testing myself and I think this is what you were trying to accomplish. EXAMPLE: Option Explicit Private Sub UserForm_Click() 'Clear the list before you add new items ListBox1.Clear 'Add the items you...

Hi everybody, is it possible to run a VBA Application as a Service from WindowsNT 4.0. Regards, dstrat6

Thanks Skip Regards, dstrat6

Hi Tedbrander the trick is to save the chart as a "GIF" FILE then create a image control on your user form that calls the GIF FILE. First step is to create your chart then play with this code. Sub Create_GIF() Dim MyChart On Error GoTo ErrorHandler 'Create Chart as gif file Set...

The problem was my call procedure. I created a button called cmdRead that will print the values into the file and works fine, so I'll just rearrange my code. Thanks for the replies.

Hey Golom, I tried what you suggested but recieve the same result. Strange, I have another array thats pretty much the same that works fine. I'm puzzled.

Hi everyone, I have an array that is supposed to get 34 values but is only getting 33. I've tried everything that I can think of would anyone have any suggestions. For i = 1 to 34 Print #FileNum, Cells(44 + i, 3) Next i

Skip, keep recieving a type mismatch error. Nothing seems to work; only ween I put it into a cell then print the values from the cell into the txtfile. Reguards, dstrat6

Yes, beat him up after you have him re-instal Outlook or try an update. If none of those work just beat him up. Cheers dstrat6

Hi Everybody I'm trying to create an array of variables that I get from an OPC Server and put them directly into a text file without have to read from cells on a worksheet, but so far thats the only way I can get it to work. The array goes something like this. For i = 1 to 5 Cells(7 + i, 3)...

Would anybody have any advice on how too get data from a OPC Server and store it in a SQL Server.

I'm not sure if this will work but I know that the computer reads every button as a number. Figure out what number delete is then omit it in your program. That way when the user tries to delete something the button won't work. If thats what your tring to acomplish. I'd try a google search for...

Hi Everybody, I would like to be able to create a report on a Excel sheet made up of data from a SQL Server. Can anyone point me in the right direction. Thank you in advance. PS. I played around with Pivot's but couldn't get a connection to the local Server. Never worked with before...

You could protect your sheet or create a message box that is tiggered by a certain action made by the user. Hope this helps. Regaurds, dstrat6

No secret here's just this On Error GoTo ErrorHandler ErrorHandler: MsgBox "Could not retrieve values from server.", vbCritical I went ahead and created four command buttons that work and collect the correct data based on the selection of the drop down box. I'll be glad to show code if...