Recent content by legend99

hang on, I might be onto something.....you can stop Excel i think popping messages using: xlApp.DisplayMessages = false Right now in Ireland its going home time but I will give this a go tomorrow and update you. Thanks for everyones help.

Sorry about that, new here, and busy tearing my hair out over this, as its such a stupid problem. I HATE when MS suddenly change things from one version to another!

I've spent days trying to get my Excel populated from ASP in an OCX and now it seems to turn out that Excel 2003 throws an error when using Replace if it is trying to Replace data that does not exist. So I have this in for every report: With xlSheet.Cells .Replace What:="vbCRLF"...

yea, tried it out. Excel itself is the one throwing the message box so looks like I can't stop it. I have realised that it is the same message box that you get from Excel 2003 when using Contol-H(find and replace) if the date you ask to replace does not exist. The message you get in Excel 2000...

I thought of that alright...wasn't going to go with it because I'm not sure that VB will see it as an error? it is Excel that is generating the error no?

For Gods sake......spent days trying to get my Excel populated from ASP in an OCX and now it seems to turn out that Excel 2003 throws an error when using Replace if it is trying to Replace data that does not exist. So I have this in for every report: With xlSheet.Cells .Replace...

So i would have to insert all the data into the first column and then get it split? 2 things, first off, does this method allow you to get onto new lines. Second, I think I might have a bigger problem in any case because these reports could have say 30,000 rows with say 6 columns, and when i do...

Hmmm, I can imagine the reaction from the Client of me askign them to hack the registry! I have found 90% of the solution now. I am instead using: Set xlApp = CreateObject("Excel.Application") Set oXMLHTTP = CreateObject("Microsoft.XMLHTTP") to retrieve the data. This works because it...

Hi, When I am copying data from ASP to Excel via an OCX, I am including & CHR(9) to tab the data and & CHR(10) to line feed the data. When I take in the input string like this, copy it to the clipboard and then paste it into CellA1 it correctly tabs the data into B1, C1, D1 before hitting the...

Hi, Tearing my hair out with this. Our site is secured with Siteminder, but I am trying to build in an OCX that starts up Excel on the Client and populates the spreadsheet with data. We are doing this with a:Set oQueryTable = xlSheet.QueryTables.Add("URL; where the URL is a page that outputs...