Computer Geek Posted February 5, 2011 Share Posted February 5, 2011 I am trying to save an Excel form I have written to onto my desktop. I keep getting an error using Desktop file path. It is trying to save it to the temp path and then the desktop path. The error message is:"Could not create parent directory for file 'C:\Users\BCS\AppData\Local\Temp\c:\test\xlsx'" The only way I can save the document is by using the ScribeDocSaveFile("") which saves to my Temp location. Typing the full Temp location as it is also gives me an error. Is there anything I am missing? I have tried path:- "file:" & Get ( DesktopPath ) with or without the Excel file name, new filename or original file all return an error. Link to comment Share on other sites More sharing options...
Vaughan Posted February 5, 2011 Share Posted February 5, 2011 Are you using a plug-in for this or using one of FMP's built-in commands like Save as Excel? Note that it is possible that you don't have write permissions for the desktop... Link to comment Share on other sites More sharing options...
Computer Geek Posted February 5, 2011 Author Share Posted February 5, 2011 Vaughan ... I am using the plug in from 360Works. I have full administrative rights to my machine. Also, I tried other folders and it has the same result. I am using Windows 7 Ultimate, FileMaker Pro Advanced 11. Link to comment Share on other sites More sharing options...
Vaughan Posted February 5, 2011 Share Posted February 5, 2011 IIRC, the file path format the plug-in uses is different from that FMP uses (I could be wrong though). The error you quoted earlier had the path 'C:\Users\BCS\AppData\Local\Temp\c:\test\xlsx'. This looks to me as though the file name is just "xlsx" thich looks like the extension -- what happened to the name. The path also repeats "c:\test" which is obviously incorrect. At a guess I say that the process for specifying the file name hasn't worked, and in the process for moving the file from the test folder to the desktop the path has been included. You may need to parse the file name out of the path. Link to comment Share on other sites More sharing options...
Smef Posted February 7, 2011 Share Posted February 7, 2011 If you want to save to the desktop you should use the format: ScribeDocSaveFile(Get(DesktopPath) & "test.xlsx") Link to comment Share on other sites More sharing options...
Stephen Hill Posted February 28, 2011 Share Posted February 28, 2011 I am trying to save an Excel form I have written to onto my desktop. I keep getting an error using Desktop file path. It is trying to save it to the temp path and then the desktop path. The error message is:"Could not create parent directory for file 'C:\Users\BCS\AppData\Local\Temp\c:\test\xlsx'" The only way I can save the document is by using the ScribeDocSaveFile("") which saves to my Temp location. Typing the full Temp location as it is also gives me an error. Is there anything I am missing? I have tried path:- "file:" & Get ( DesktopPath ) with or without the Excel file name, new filename or original file all return an error. The Get( ...Path ) Filemaker functions return "/C:/dir1/dir2/dir3/" If you do not remove the leading "/" before C:/... the ScribeDocSaveFile prepends the temp directory (thus the weird double path you're getting.) The "file:" should not be necessary for this function call. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4799 days old. Please don't post here. Open a new topic instead.
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