Search results for query: *

Hello, I need the help from you! I would like to delete the first two records. I have tried this: DELETE FROM LoggingData WHERE (SELECT TOP 2 * FROM LoggingData ORDER BY DateAndTime) Please help!

Hello, I have created a text file which I would like to save by chhosing in the pop-up save as dialg. How do I get up the save as dialg box ? Regards Per

Hello all, I really ned the help from you! This is what I want to do: 1) Open internet explorer with a html file 2) Print the html file 3) Close the internet explorer Or can I print the html file direct ? I have manage to do set 1 with this code: Dim objExplorer Set objExplorer =...

Hello all, I really need the help from you! I would like to do the following from a VBA script: 1) Create an SQL database with UID=User and PWD=Password 2) Include a table in the database I have serached the forum but I can not find anything Please help! Per

Hello, I have an application there I would like to print the screen. It is possible from VBScript to print the screen ? I have two monitors to my application, can I seléct which monitor I would like to print ? Thanks Per

Hello, is this possible: I would like to get even space between words. Ex: Row1 Text1 Test2 Test3 Row2 NewText1 NewText2 NewText3 I would like the words to line up as abowe, is that possible ? I tried to put in spaces, but with ni luck. Can I use tab instad ...

Hello all, Is it possible by VBA to change the color of title bar on user form with VBA ? I'm using a SCADA system and the user form takes the window settings, and I would like to change the color so it will fit with all the other colors. Please help! Per

I would like to search a directory and all subdirectories and copy all txt files to another directory. How do I do that ? Thanks all people that are helping out!

Hello, I'm new to perl and I would like to extract text between to strings. I would like to print all texts between <source> and </source> in a text file. The <source> and </source> could be on different rows. Ex1 ==== <source>Test</source> => print Text Ex2 ==== <source>Test1 av...

Hello, I have a string of 8 bytes that I would like to convert to a number. I read the bytes from a file and I need to change the order of the bytes before converting the number to a string according to the following. 96 6A 45 43 39 01 00 00 -> 00 00 01 39 43 45 6A 96 How do I do I change...

Hello all, I try to read a binary file with this code: Private Sub CommandButton1_Click() Dim intFileNum%, byteTemp As Byte, intCellRow Dim arg As String intFileNum = FreeFile intCellRow = 0 Open "C:\test" For Binary Access Read As intFileNum Do While Not EOF(intFileNum) intCellRow =...

Hello all, What shoulen de syntax be if I would like to insert a float value in SQL table. I have tried this: SQL_Table = "UPDATE TestTable SET TestElement = "& 10.8 &" WHERE SerialNo = '"& TestTag &"';" What type should TestElement have ? How should the syntax be ? Thanks Olof

Hello all, Does anyknow if it is possible to get up a TCP/IP communication with VBA in excel ? If, example ? Thanks Olof

Hello, Is it possible to copy a range in excel into paint with vba ? Open and save paint with a name choosen in excel. Olof

Hello, I have some problem with the lock sheet function! if I tick the first three when I lock the sheet: Mark lock cells Mark none locked cells Format cells I then have two buttons on my sheet, one unlock the sheet and the other lock the sheet, when I lock the sheet, the format cells box is...

Hello, I would like to remove all manual page break from a sheet .... some help please ... I have the code below, but I got an error if I run the code with no manual page(I have two auto) break here: ActiveSheet.HPageBreaks(2).Type ? Saying error in index ? Number =...

Hello, I wounder if someone could help me .. I have this problem: I have two dates, eg: Start: 15 Sep 2011 Finished: 4 Mar 2012 I would like to spread out 200 h over the period, so I get how many hours per/month 200 will be. quick tricky .... Please Help!

Hello, I would like to sebd an e-mail with help on a VBS script. I tried this: Set objMessage = CreateObject("CDO.Message") objMessage.Subject = "Example CDO Message" objMessage.From = "<my e-mail>" objMessage.To = "<my email>" objMessage.TextBody = "This is some sample message text."...