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!

Register Log in
  • 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: legend99
  • Content: Threads
  • Order by date
  1. legend99

    Using Replace when opening Excel from VB OCX

    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"...
  2. legend99

    With xlSheet.Cells REPLACE not working

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

    Copy Data into Excel

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

    Getting Excel to Log into Website

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

Part and Inventory Search

Back
Top