GAVIN YU Posted October 23, 2019 Share Posted October 23, 2019 Sorry about the tag, Ican't seem to find Statistica for some reason. On to my question, I am running amacro that copyscells from a excel sheet in a network drive and paste them into a spreadsheet in my workspace, which is also on a network drive. Even though Statistica have no problem opening and writingto the spreadsheet, everytime it trys to open the excel sheet, Iwill get a access violation error. I tried just plain importing the excel sheet, which also gaveme the access violation error. I am still kinda new to SVB and macro in general, so Iam wondering if there is a way to open the excel file in readonly mode similar to how you would do it in VBA(readonly:=true). Maybe that will fix the problem P.S: I tried the setattr function on the ecxel file, it just gives me a could not open file error. Getattr returns 32.I am even more confused now. Link to comment Share on other sites More sharing options...
Neema Pitchiah Posted December 10, 2019 Share Posted December 10, 2019 What is the version of Statistica being used Our support team can take a look at this with you if you create a case on : https://support.tibco.com/s/ for TIBCO Statistica. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now