I got it to work. Not sure BEST solution, but it works x = 1 DO Until xlSheet.Cells(x,1).Value = "" If (xlSheet.Cells(x,1).Value) = "" Then xlSheet.Cells.Value(x,5)= "" Else xlSheet.Cells(x,5).Value = ((xlSheet.Cells(x,3).Value) & " " & (xlSheet.Cells(x,4).Value)) End If x = x + 1 Loop xlSheet.Colum...

Here is the full script so far. Still a work in progress. I need to tak a date in column C and a time in column E and combine them into one column in yyyy-mm-dd hh:mm:ss format. The bold code is my attempt at that so far. I am not getting anywhere fast. I want to take column C + Column D, put it in ...

Can you look at this section of VB that I have to see what is wrong. The rest of my script works fine without this. For every row of an excel sheet I need to set Column E equal to Column C + D x = 1 DO Until xlSheet.Cells(x,1).Value = "" If (ISBLANK(xlSheet.Cells(x,1).Value)) Then xlSheet.Cells(x,5)...

I have an excel file with a date column and a time column. I need to have these two be ONE column in yyyy-mm-dd hh:mm:ss format.

If I concatenate the columns Excel does not want to reformat them as a date because it only treats it as text then.

Any suggestions?

Nique

I need to change certain rows in a column in excel based on the value in another column. Can someone give me some VB script help on doing that.

IE IF A1=1 then B1=2

Thanks
Nique

DSN in my datasources, I do not need the connect string at all? DUH!

Next question related to this script is once I do that, how do I return the SQL data to a CSV file and modify the date formats in the query?

I have written my first script and it works, however it is not what I consider to be the best solution. I want to query an informix database and output the data into a CSV file and change the format of the date fields. In order to do this I wrote a query from MS Query and my script calls the query. ...

Thanks!

I am running a query from an Informix database and dumping into excel. The following is my script so far. It gets as far as running the query, but then I want it to delete the first row and reformat column C. It never gives me an erro, but it also never performs the row delete or the column format? ...