The title pretty much says it all. I have a file on a OS X machine with a macro designed to open another file and read/write from it, but the target file is on a networked windows machine.The only way I have found to be able to do it is to mount the networked folder, and then treat that like a local folder.
This:
doesn't work. Once I mount the folder I can just do:Workbooks.Open Filename:="smb:\\compname\folder\file.xls"
Workbooks.Open Filename:="folder:file.xls"
but I'd really hate to have to mount the folder every time I wanted to run the macro.
Any suggestions? Thanks