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. 

Colin_McCrae's avatar
Colin_McCrae
Community Hero

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.