@katies wrote:
When I open the MYLIB library, there are no sheets there.
Could the problem be the filepath I'm specifying? I'm using a UNIX server and accessing a file on my Desktop with the filepath: "C:\Users\username\Desktop\filename.xlsx"
You can only access locations that are mounted on the server, and you have to use the UNIX operating system's syntax for it. Since desktops (by default) offer no shared resources, it is highly improbable that your C: drive is accessible anywhere in the network.
What can you do?
move the file to the server. EG 7 has the "Copy Files" task built in, so you can use that as part of a process flow
store your file in a location that is accessible both from your desktop and the server. Get in touch with your admins to see if such a location exists
Note that the UNIX file system does not have the concept of drives (therefore no drive letters), and uses forward instead of back slashes to separate directories in a pathname.
... View more