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...
Hello,
I have checked out several programs that will display an atom feed (XML) format on a website. THere is always some bug in it. Currently, I am displaying it using a javascript. I prefer PHP programs rather than Javascript.
If there is any program in this forum, please let me know.
Any...
That's right... Actually, Steve gave me that link when I asked a question about copying dataprovider from one report to another (http://www.tek-tips.com/viewthread.cfm?qid=984874&page=1).
I agree as far BO is concerned, that forum more active. But I participate in Oracle and Unix forums here...
Thanks for the info.
Yes, I have tried alerts as well. But I finally did the correct way. I put the filters at the Global level rather than the table level.
i got this info from another forum. tek-tips.com is a great forum but you can also visit forumtopics.com/busobj/, if you are just need...
Thanks for the response.
I think this work partially. The border is still there. I want the border of the colunm header if there is data. Can you remove border programmatically?
I was just curious about the "Hide Section" feature under Format Section (Right Click on the section -> Format...
Hello,
I have a BO report. I add a filter to one of the columns and then I get a different result set. Now if I group by a particular column. All the old result set (before adding the filter) show up although there are no values since I added the filter. I just see column headers for which...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.