SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 2 of 2
  1. #1
    Member
    Join Date
    Jul 2003
    Location
    US
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    excel.sbl "File \'excel\' not found?!

    Hi,

    I am trying to use the excel library from the Rational Users group, but get this funny error. All read write failed with the same error. Here is the simple code:

    I am on Robot 2002.05.00 and XP sp1.

    Jirong


    -----
    '$Include "Excel.sbh"
    Sub Main
    Dim Result As Integer

    'Initially Recorded: 10/3/2003 9:48:25 AM
    'Script Name: Create_Excel_Sheet

    'EXAMPLES:
    Dim sWorksheets() as String
    Dim iWorksheetCount as Integer
    iWorksheetCount = GetWorksheets("c:\temp\test.xls", sWorksheets())

    Dim Data As String
    'Data = ReadExcelDataSingle(sFile, sCell)
    'Dim TestData as Variant
    'TestData = 1
    'Result = WriteExcelDataSingle(sFile, sCell, TestData)

    MsgBox iWorksheetCount

    End Sub

  2. #2
    Senior Member
    Join Date
    Jul 2001
    Location
    Montreal, QC, Canada
    Posts
    366
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: excel.sbl "File \'excel\' not found?!

    At which point do you get the error, on which line.

    Is the excel.sbh in the appropriate location along with excel.sbl? You can check by doing a File->Open SQA Basic File and see whether it's going to the place you put the excel.sbh file.

    Did you open the excel.sbl file and compile it?

    Max

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 11.54%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 08:33 AM.

Copyright BetaSoft Inc.