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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: nasar
  • Content: Threads
  • Order by date
  1. nasar

    Understanding ByRef when passing arrays to subroutine

    Hi, I hope you can provide some help with an issue I am having. I have a two-dimensional array which I wish to sort. I have created a subroutine to the sorting as i will be calling this a number of times. The problem is that I (think) I am passing the array as a parameter by reference and expect...
  2. nasar

    Using DBI:CSV to get data from a CSV file

    I am trying to extract data from a CSV file using the code extract below, but it returns only four rows and they are all the same. If you point to what I am doing wrong or missing something that would be appreciated. sample code: #!/usr/bin/perl use strict; use warnings; use DBI; my @row...
  3. nasar

    Excel data extract/report

    I have the following data and would like to identify all instances where there is a "NONE" entry for a month. Month Response Jan 01-Oct Feb NONE Mar NONE Apr 02-Oct May 03-Oct Jun 01-Oct Jul NONE Aug 04-Oct Sep 05-Oct Oct NONE Nov 12-Oct Dec 01-Oct Jan 02-Oct Feb 01-Oct Mar 04-Oct Feb NONE I...
  4. nasar

    Capturing the Paste message

    I have some code which loads a data file using the code below. The size of the file is variable (each day) and on occassions when the size is large, I get the following message: "There is a large amount of information on the Clipboard. Do you want to be able to paste this information into...
  5. nasar

    Extracting MS Word File Data from Excel

    I have written a VBA module within Excel 97, which lists the files in a directory (mainly Word documents). Now, Word 97 has some fields which store the Title, Subject, Author, Category etc.. information (which can be obtained by selecting File-Properties). I would like to extract the data...
  6. nasar

    Date Comparison

    I need return rows from a list which satisfy a criteria based on the date field. My problem is that I cannot specify greater than (>) criteria. My list contains the following fields: Date Item 1-Nov-2002 AAA 2-Nov-2002 BBB 3-Nov-2002 CCC I want to be able to choose Items...
  7. nasar

    Problem with CurrentRegion

    I have the following set of data: A B 20 Day Item 21 1-Nov-02 12 22 1-Dec-02 6 23 2-Dec-03 8 I have named cell A20 rgTransactions. In my code I wish to do various things within the future growing list around A20. This is my code sample...
  8. nasar

    Hyperlink to a document from within customview.html

    I have customview.html file and want to display an icon, which when clicked, will display a document which resides in the another folder. I am currently inserting the full URL of the document but this is far from ideal. What I really want to do is to use relative addressing but none of the...
  9. nasar

    adding workgroup

    i could not a new workgroup in win2000. please help me to do this. and how can i change my domain name.

Part and Inventory Search

Back
Top