Recent content by gregmosu

Nope, bombed out on the same record.. same error message.

According to an online book, a cell can contain 32,000 characters. A single column cant be more than 255 char wide, so you must use word wrap to get around that. The size of the string that's crashing excel is 1258 characters. If I reduce the size, it works just fine. Also, I can paste the...

just ran a test, and it took 1117 characters. are there any characters that would cause excel to crash?

Hi guys, thanks for the replies. I put a LEN() around that field, and it finally produced all 129 records.. and the lenght of the note field causing it to crash is 1274. Also, I can get the field to print out on a Message Box, it only crashes when I write the data to the cell. The cell's format...

Hi Rob, I acutally do include a Where clause. It is built depending on what the user selects from the userform. Unfortunately, I cant really eliminate any tables from the join. This runs perfectly in the query analyzer window in Ent. Manager, and runs through a number of records before bombing...

I posted a while back about my sql query producing empy results. I ended up going in and changing all the TEXT field to VARCHAR field, and it was working, until I came up on this error today... runtime 1004 error Application-defined or object-defined error This was the value from teh...

The columns that were being omitted were the columns of type 'TEXT' in the sql server. Since I cant find a way to get excel to accept these columns, I went into sql server and changed them all to varchars. Thanks for pointing out the problem Skip.

Found two examples on the web, but they dont work... 1) CASE WHEN IsNumeric(n.note) = 1 THEN n.note || ' ' ELSE n.note END 2) Select CAST(n.note AS TEXT) AS exp1 both run, but produce nothing. Am I at least on the right track...?

Ok, I see what you're saying now. ADO is getting hung up over the datatype. So did you use the IsNumeric function to evaluate it, or something else??? Thanks, Greg

Not 100% sure what you mean.. what if I take out the exp# from my select statement and use rs(0)..(7) to pull in the fields? Also, there is a movenext() I had a bunch of error trapping junk below the ifs that I left out when cutting a pasting. The movenext() must have been left out w/that stuff.

I can run this query in sql server's analyzer and it runs just fine, but when the query runs in excel half the fields are blank.. not NULL, just an empty string. SELECT c.candidateName AS exp1, instat.status AS exp2, instat.comment AS exp3, s.state AS exp4, n.note AS exp5, avail.description AS...

Ok, I just ended up calling the macro that changes the text from the vb script, and it seems to work just fine. I just need to know how to edit the header and/or images while recording a macro. Is there some trick that I'm not aware of, cause the images and header seem to get locked....?

I'm trying to put together a console application that will 1) Delete the first image in the word doc and replace it w/another one. 2) Find a text string, and replace it with other text. I had help from other members of this site to get the first part of this done, but the only problem w/it is...

Yeah, you guys are great! I'd have been lost w/out you!

Earthandfire, that worked perfectly! Thanks for your help! I can do pretty much the same for spreadsheets by using the Excel component right? Thanks again, Greg