I'm not sure but I think I need a nested do while loop. My macros are in workbook Personal.xls. In sheet1, starting in cell A6 I have ticker symbols. The...
I am really new at this and in over my head. Could you give me an example of what I need? Thanks, Joe ... increment ... I'm not sure but I think I need a...
Good morning, I was wondering the most efficient way to delete a line from a text file. I know the line number that I need to delete. I am currently opening ...
I would be doing what you are doing. However you don't describe what you are doing after the split ? There may be a more efficient approach than what you are...
Thanks for that Rob, you were correct in physically removing the line. I had never come across the Replace function before, this is good as I know exactly the...
Hi All, I have a project in VS.Net 2003 (VB.Net). The OS is Vista Ultimate. The project runs fine without any problem in Vista Ultimate and XP. I create a...
something similar to this will do what you want....... Public Sub SeekAPerson(ByVal index As Integer) Try FileOpen(1, "c:\people.txt", OpenMode.Random) Dim...
SELCT is mispelled You probably need a wild card (% or * depending on what you are using and where) It is cleaner to do this Dim sSQL as string Dim sFind as...
Dear suresh i think you have to use proper string cancatination operator and you have to use % like rs.open ("SELCT * FROM CUSTOMER WHERE CUSTOMER.NAME LIKE...
hi. i want to send some files in runtime of my program(files are my db), from computer1 to computer2 in other city. and i want to do this through phone...
Thanks so much. I'll work with this awhile and try to get this thing running. Should my 'routine' of what I want done be inside this loop? Thanks, Joe ... am...
Hi Ron, ... You could use the FileLen() command to see if the file already exists, or use a FileSystemObject to evaluate it for additional information (file...
... While this will work, it would be better to use the TextStream object and iterate through x times copying lines from the old file to a replacement file,...
... You can access it from the properties option from the "local area network" connection, or from the quick-notes on the left side in the network neighborhood...
My VB6 projects use Notepad. This includes using different Headings for Printouts. When closing the programs with Exit on the Menu bar, the Notepad defaults...
Hi group. I am using Visual Basic 6 and complied an exe program. I am using INNO which is a free installer program. After the program installs, it works fine....
Very many thanks, but I'm not certain that I am any the wiser! I'm glad that I am not the only one who makes mistakes! Michael ... From: vbhelp@yahoogroups.com...
Hi Michael, ... Maybe. I assume that you're changing the Notepad settings upon application open. If that's the case, you should be able to change the order of...
Hi David, ... Yes, it is. If you're compiling the program to sit beside the VB code, and then use the INNO 'add folder' tool to include the entire folder ...
I have created an application that works fine on my desktop. When I create the executable and place it on our server it does not work. Could anybody point me...
A big problem in program distribution is that the the program works fine on the programmer's machine but fails when the user installs it. One of the causes...
Hi Ron, ... We're going to need more information to work with. It could be any of these (or more than one) or something else entirely: * system execute...
Thanks, Shawn. When the 'calculated' text is displayed in Notepad, the user prints or saves via Notepad's own commands. You are quite right, settings (header,...
Hi friends Can anyone help be out with the logic of adminstration for a MLM project? Five tiers are required. Or how could I google for this? Thanks Ulrike ...
hi, im developing an application that will verify every file that a user will copy on his/her flashdrive or any usb storage device. The significance of this is...