I'm using Ken Getz ahtCommonFileOpenSave API in Access VBA.
Is it possible to send in ThisPC as the InitialDir ?
I'm using Ken Getz ahtCommonFileOpenSave API in Access VBA.
Is it possible to send in ThisPC as the InitialDir ?
Why not try? I did. ThisPC doesn't seem to mean anything in VBA.
Try:
fd.InitialFileName = "file:\"
or
fd.InitialFileName = "file:\\"
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
ThisPC would mean something to readers here.
Were those good suggestions? They didn't work here.
AFAIK, ThisPC is a pointer to OneDrive/Documents IF OneDrive pc folder backup option is turned on.
However, when I examine OneDrive properties the location is shown as C:\Users\userNameHere so it seems the answer would be no. I've read that OneDrive is just a namespace junction and to me, ThisPC is also.
Happy to be proved wrong though if that's not the case because there seems to be an API for everything these days.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Thanks @Micron, I couldn't sort it either. Give up time, would have been handy.
Perhaps "ThisPC" is a 'moniker' for something else you can use - (like, but not exactly) %UserName%, or %HOME%, etc.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Well, they didn't error. But on second look, I do see just points to Documents folder.
I do have hard drive backup but not OneDrive.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thanks. Failing anyone with a solution I'll use C:\
Normally the BroweFile routine is given a Path, but this was a catchall if it wasn't present.