Recent content by itpmguy

Hi, Is there any way I can copy data from all the sheets of a spredsheet and put it into a Microsoft Word document in a table format? It should name the Word doc table name as the name of the corresponding sheet in spreadsheet. If there is already a script for this, then please send me the...

Thanks. It works and some cleanup may be needed. Here's another question - Is there any way I can copy columns "A" through "E" from all the sheets and put it into a Microsoft Word document in a table format. It should name the Word doc table name as the name of the corresponding sheet in...

Hello, I have a spreadsheet with more than 600 sheets. I want to delete all columns starting from column "G". The last column is column "R". How do I do this in VBscript? Any suggestions are greatly appreciated. Thanks Cheap Computer Part Supply Buying Tips...

Thanks. Both solutions are great! From mrn's solution, I wonder if there is way to put a comma after value as follows: Milwaukee, Chicago, Dallas, New York, Cheap Computer Part Supply Buying Tips http://www.cheap-computer-part-supply.com VOIP Phone Service Guide...

Hi, I have a text file that has values listed one below the other. Ex.: Milwaukee Chicago Dallas New York There are about 1500 values. I want the values to appear as: Milwaukee, Chicago, Dallas, New York I want 10 values per line and next 10 on the next line. Thanks Cheap Computer Part...

Thanks p5wizard. I have not tried this yet but I wanted to inform you briefly about what the program does. This program assigns the values to variables from the input text file and then loads it into a database table. The problem I was having is that in the very first line of the file...

Thanks. Actually, I was using firstname=`get_pos $line 0 7` in korn shell and I was getting error :) The firstname=$(get_pos $line 0 7) worked good in Korn shell. Here's a question about reading files. I am reading a text file well in unix and getting all the fields based on length specified...

I have written sub routines in unix. How can we get the return value of UNix sub routines. The return function gives the exit status only. here's the command position=`expr substr $longline 1 5` can i write a function as follows and assign the value get_pos () { string=$1 $pos1=$2 pos2=$3...

Thanks! That was super! Cheap Computer Part Supply Buying Tips http://www.cheap-computer-part-supply.com VOIP Phone Service Guide http://www.ez-voip-phone-service.com

Thanks. This worked. This will be used multiple times so I am trying to create a function to populate array and I am getting the following error: populatearray[9]: newarray[174]=XXXX YYYYY X -4.000000: not found populatearray[9]: newarray[175]=ZZZZ XXYYY A -17.000000: not...

This is a Korn shell question. I want to put the results of a grep into an array. So, I did the following: set -A newarray `grep XYXYXY testfile.txt` But this puts each word into an array index instead putting each line into an array index. For ex. if the grep matches the following lines: My...

Hello, I just wanted to add this info here about Vundo. This typically will show pop-ups for the websites sysprotect.com, amaena.com and few others. The pop-up will show task bar that is supposedly scanning your computer and then will recommend that you download sysprotect to remove spyware from...

I doing forms after a long time.... so I have this question now. I have an LOV where I am selecting 3 columns a, b, c and they are returned to 3 text items - a_text, b_text, c_text. In the LOV, I want to display only 1 column i.e column - a. How do I do this? suggestions... thanks Multiple...

The download link for the source code as pointed by sitepoint.com does not work and here's is the link: sitepoint.com/examples/phpxml/sitepointcover.php.txt Does anyone have the correct download link for the source code?? Thanks Lokesh Multiple Sources of Internet Income - Articles and...

THanks. I have a programming background but I don't know PHP. I can edit PHP easily - that's why I asked for PHP. I will look at the link that u gave. THanks Lokesh Multiple Sources of Internet Income - Articles and ideas. http://www.internetandmoney.com What is the top selling item on eBay...