Recent content by nasar

Thanks strongm I thought it might be something straightforward and your explanation is very helpful in aiding understanding.

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...

Thanks Steven, That's worked a treat. I have also amended the SQL to: ("SELECT * FROM test1.csv ORDER BY col1, col2"); I have to append a header row to my data file with column headings (I used "col1", "col2", "col3", "col4"). This allows me to sort my data file on two fields.

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...

Thanks Skip, Geoff, Works a treat Regards Nasar

Thanks for your prompt reply Skip. I will give both your suggestions a try but I cannot at this stage see how I will only display the data for months Feb, Mar, Jul and Oct - I don't want to have months that do not have any NONE entries. Will post back with my findings.

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...

Give this is a go (I have made the "What" italic). With ActiveSheet .Range("A4").WrapText = True .Range("A4") = "Topic" & Chr(10) & "What" With .Range("A4").Characters(Start:=1, Length:=5).Font .Name = "Arial" .FontStyle = "Bold" .Size = 10 End With...

Rob, In which database is the stored procedure? (SQLServer, Oracle etc...) Calling stored procedures is fairly standard and requires setting up an ODBC connection, connecting to the database and packaging SQL in the correct format to call the stored procedure. As to getting data back, I would...

If all you are doing is concatenating the selected txt files you could do the equivalent of the DOS COPY command: COPY file1.txt + file2.txt + filen.txt compress.txt Just package this inside a SHELL function and you achieve your result. Regards, N

Dawber, This is how I would do this: Sub test_mkdir() Dim ref As Variant Dim project As Variant Dim site As Variant With ActiveSheet ref = .Cells(2, 3) project = .Cells(2, 2) site = .Cells(2, 1) MkDir "C:\Water" ChDir "C:\Water" MkDir site & " - " & project & " - " &...

Thanks PH. Unfortunately the warning message is still displayed. It also has the (inexplicable) side effect of rendering the data in RAW in its original form, ie. with the delimiters still in place and the data in a column A.

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...

You need to use InputBox to get user response.

Thanks for that VBAjedi, it worked a treat.