Opening files with File Open common dialog

[cole.petersburg@gmail.com]

Your program is extremely cool, but there's something extra-cool I would like it to do. I'm downloading what I believe to be MS database files (in disguise) from a server and then loading parts of that database into Excel using an Excel macro. I can see the files in my Swish folder, and I can double-click them from Windows Explorer, but unfortunately that doesn't get the data into Excel. I can even see the Swish folder (including the subfolder I'm interested in, plus subfolders of that) through the Excel macro's dialog boxes. Unfortunately, the macro cannot see a single file in the subfolder. I tried to force the issue by copying and pasting the file name into the dialog box, but that got translated into ::{20D04...}::\{B816A... and it won't actually load the data.

Will the next update allow the level of access I'm looking for? I imagine the file would have to be cached before it's loaded since it's on a different machine, but it would be "nothing but net" from a user's perspective.

[anonymous]

Screenshot of Excel macro

[alamaison]

This is an interesting scenario you've described.

I would like Swish to be able to do something like this but it doesn't look likely in the near future. Swish is an Explorer namespace extension which means its view of files and folders only exist in Explorer's 'mind'. Excel is expecting a real path to a filename which means it needs a true SFTP filesystem driver. Something like Dokan SSHFS might do what you are after.

As for Swish, I hope to have double-click opening of files working in the couple of releases time. This still isn't quite what you are after. It will just copy the remote file to a local temporary directory and then open that. I've heard that there might be a way to trick the File Open dialogues into using the local temporary path but that is a challenge for the future.

[alamaison]

* Ticket #211 marked duplicate of this one *