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 danielledunham on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by pigpig504

  1. pigpig504

    attachEvent Problem

    Dear all, I would like to attach a onclick event to a table row as follows: oRow[row_index].attachEvent("onclick", doSelect); however, for the function doSelect, I would like to pass 2 arguments when attaching. How can I do that?? any alternative method?? Thx a lot!
  2. pigpig504

    Why the saved attachment get from xp_readmail is renamed as xxx.TMP?

    anyone can help pls??? >.<
  3. pigpig504

    Why the saved attachment get from xp_readmail is renamed as xxx.TMP?

    Dear all, I'm using xp_readmail to get the attachment information. I do can get the path, but I wonder why the saved attachment is renamed into xxx.TMP sometimes?? As I would like to check if it's MS Excel file just by its file name without opening it. How can I solve this? Thx a lot!
  4. pigpig504

    How to disable macro from running?

    Dear all, I am writing a VB program to open the EXCEL file and get the data. But some of the files contain macro, which would make my program pending as there is a prompt msg. I've tried to alter the security level to have a try, but also fail to cure the problem. Does anyone how to disable...
  5. pigpig504

    How to get the first sheet at EXCEL??

    Thx all... But for some reasons.. I am not able to open the Excel file (workbook)....that's why I changed to use recordset method to open it. e.g. There're some broken link (failed to update) in the workbook.. program would be idled and prompt me whether to edit the link or continue....(I've...
  6. pigpig504

    How to get the first sheet at EXCEL??

    Dear all, I'm using ADODB.recordset to get the data of EXCEL as follows: RS1.Open &quot;SELECT * FROM [Sheet1$A1:J4]&quot; But if the sheetname is renamed, I failed to get it. Thus,I would like if I can get the 'absolute first sheet' name or how can I get the data at the first sheet without...
  7. pigpig504

    Reading Excel Issue using ADO method

    Dear all, I've encounter reading Excel data problem. When I read through the Excel document, NULL' is return somtimes(but there should be data at those particular cells, yet, I do can get some of the data at some other cells) My code is as follows: ConnectionString =...
  8. pigpig504

    Reading Data From Excel

    Swi, Yes, the program DOES work fine on a PC WITH Office, but error occurs when I run it on another PC WITHOUT Office =( It said cannot find the object [Sheet1$].
  9. pigpig504

    Reading Data From Excel

    It's ok to run at the PC install with Office, but failed to find the object [Sheet1$] if I run it at the PC WITHOUT Office. Any idea to reslove it?? Thousand thanks!!
  10. pigpig504

    Format Excel Layout

    anyone can help??? Using this approach, I don't know how to use HTML coding to set border, NumberFormat to the data, etc. Thx a lot!!
  11. pigpig504

    Format Excel Layout

    Dear all, I use the following sentence to show excel in asp: <% Response.ContentType = &quot;application/vnd.ms-excel&quot;%> But I dunno how to format the data (like NumberFormat, border,etc) using this method. Anyone can help? thx a lot!!
See more

Part and Inventory Search

Back
Top