Forum Discussion

jgoetz's avatar
jgoetz
Occasional Contributor
9 years ago

Read from and write to the same Excel file using VBScript

I am trying to find a solution to the following issue, but what I have found is not working for me so I am not sure what I am missing.    I have a VBScript that opens and excel spreadsheet that has...
  • jgoetz's avatar
    jgoetz
    9 years ago

    Thanks for the suggestions.  The suggestions about write permissions got me thinking and it turns out that because I am using the same file in a datadriven loop in the keyword script that calls the script above, to pull data from another tab, that was the issue.  I seperated out the tabs and used a different file for the datadriven loop, and now I don't have an issue with read write. 

dmiscannon's avatar
dmiscannon
Frequent Contributor
9 years ago

When you use SaveAs what is the result? You state it is not working, but not what is happening. Is the file saved but not to the projectPath? I use VB script and frequently write results back to Excel without issue using both Save and SaveAs.

 

One other thing to check if your projectPath is on your local hard drive. Where I work, our local computer's hard drive is locked down (unless you are a local admin) where you cannot save any files to the local hard drive. All files are saved to a network drive even if indicating to save it to c:\.... Just one more thing to consider.

  • Colin_McCrae's avatar
    Colin_McCrae
    Community Hero
    9 years ago

    Yep. I'm the same as dmiscannon read and write to Excel all the time no problem.

     

    This sounds more like a permissions issue if it's opening read only in the first place. Do you normally have write access to the drive in question? And does it make any difference if you run TestComplete as Admin?

    • jgoetz's avatar
      jgoetz
      Occasional Contributor
      9 years ago

      Thanks for the suggestions.  The suggestions about write permissions got me thinking and it turns out that because I am using the same file in a datadriven loop in the keyword script that calls the script above, to pull data from another tab, that was the issue.  I seperated out the tabs and used a different file for the datadriven loop, and now I don't have an issue with read write. 

  • Raj27's avatar
    Raj27
    Occasional Contributor
    9 years ago

    Can you share that VB script for writing data into excel sheet