Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to put Variable Value in a List Name?
I need to create several lists inside a loop. The loop index should be in the names of the lists. blx="blx" j=1 while j <= 100: blx+j = [1,2,3,...] j=j+1 The result I need is 100 lists: blx1 blx2 blx3 . . . blx100 Anyone have an idea about how to put a variable name in the list... -
Field Separator Help
Thanks, The substr is working and is much better than what I originally asked for. -
Field Separator Help
Is there a way to use FS=??? in the BEGIN part of an awk script so that every character becomes a field separator? I would like to use $1, $2 ... $n to specify the nth character on a line, regardless of what separates the characters. So, for example on the line: abcd e f g hi $13 would be the... -
VB Excel App Object - OLE Server Busy
Hello, My problem is with the OLE server timing out and giving a Server Busy message box during execution of a VB Excel macro. The Server Busy message box requires user input, and the purpose of the macro is to eliminate user input until other calculations, etc. are done. There is a way to...- rswarich
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel Macro + VBScript Error Help
Hello, We are writing a VB macro in Excel that needs to open a file in another application and do some processing there. Having problems getting the other application to open reliably. Two approaches were tried, each had problems: 1. The preferred method has the following code placed directly... -
How to run a VBscript from within VB
I have a VBscript file that needs to be executed from within a larger VB (Excel) macro. In the past, have used something like: Shell ("D:\CALROT1\shutdown.bat") to run batch programs. This approach does not work with a .vbs script. What is the easiest way to execute a .vbs script... -
Match fields from different files
Have two files, each with the following format: Example data in File1: 176, 488, 14, 475, 167, 497, 482, 617, 491, 168, 483 215, 106, 14, 276, 488, 105, 298, 299, 498, 497, 714 . . . Example data in File2: 216, 475, 276, 14, 488, 601, 298, 482, 617, 714, 497 25, 488, 475, 476, 167, 617...
