retrieve excel sheet name

Results 1 to 2 of 2

Thread: retrieve excel sheet name

  1. #1
    Join Date
    Dec 1969

    Default retrieve excel sheet name

    Hi,<BR><BR>Is there any way I can retrieve the excel sheet name?<BR>thanks

  2. #2
    Join Date
    Dec 1969

    Default yes..check out Bill the greats article

    &nbsp;<BR><BR><BR><BR><BR><BR>&#060;%<BR>Set FSO = Server.CreateObject("Scripting.FileSystemObject")< BR>If FSO.FileExists( Server.MapPath( "" ) ) Then<BR> ... file exists ...<BR>Else<BR> ... it does not ...<BR>End If<BR>%&#062;<BR><BR><BR>The argument to the FileExists method must be the FULL PATH to a file somewhere on your local system (or LAN, if applicable). You can either give the path explicitly, as in<BR><BR><BR>If FSO.FileExists( "x:
    astyCommentscrosspostsanswer3.txt" ) Then<BR> <BR><BR><BR>or you can give a path that is relative to the location of the currently executing ASP page via something like<BR><BR><BR>If FSO.FileExists( Server.MapPath( "../images/uglyface.jpg" ) ) Then<BR> <BR><BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts