Re: Having problems Storing and Retrieving an Excel file in a Custom Property

2011-04-25 Thread Mark Schonewille
Martin, Using 'binfile' is the right answer. -- Kind regards, Mark Schonewille Economy-x-Talk Http://economy-x-talk.com Share the clipboard of your computer over a local network with Clipboard Link http://clipboardlink.economy-x-talk.com Op 25 apr. 2011 om 18:12 heeft Ian McKnight het vol

Re: Having problems Storing and Retrieving an Excel file in a Custom Property

2011-04-25 Thread Ian McKnight
Thanks Klaus that did the trick. BINFILE IN AND out makes absolute sense now that its been pointed out! On 25 April 2011 17:09, Klaus on-rev wrote: > Hi Ian, > > > Hi All > > ... > > Here is my import and export code > > import: > > answer file "choose" > > if it is empty or the result is "

Re: Having problems Storing and Retrieving an Excel file in a Custom Property

2011-04-25 Thread Ian McKnight
Hi I'm doing this from a stack within the IDE and have my stack in a sub folder of my documents folder. The template file is in the same folder. When I double click the original template, which is also stored there, it lauches Excel and displays correctly. The problem occurs when it is 'process

Re: Having problems Storing and Retrieving an Excel file in a Custom Property

2011-04-25 Thread Klaus on-rev
Hi Ian, > Hi All > ... > Here is my import and export code > import: > answer file "choose" > if it is empty or the result is "Cancel" then exit to top ## You need BINFILE! > put "BINFILE:"&it into fname > set the cpExcelMaster of this stack to URL fname ## With "file" it will be tr

Re: Having problems Storing and Retrieving an Excel file in a Custom Property

2011-04-25 Thread Martin Blackman
I dont have any problems doing this in an app of mine, I am using "binfile:" though, also are you exporting the file to your program folder which shouldn't be writeable. On 25 April 2011 23:01, Ian McKnight wrote: > Sorry pressed send to soon! > > here is the export code: > > put the cpExcelMa

Re: Having problems Storing and Retrieving an Excel file in a Custom Property

2011-04-25 Thread Ian McKnight
Sorry pressed send to soon! here is the export code: put the cpExcelMaster of this stack into tFileToExport ask file "" if it is empty or the result is "Cancel" then exit to top put "file:"&it &".xlt" into fname put tFileToExport into URL fname -- Regards Ian McKnight iangmck

Having problems Storing and Retrieving an Excel file in a Custom Property

2011-04-25 Thread Ian McKnight
Hi All I have an excel file that I want to include in a standalone. I created an excel template and copied it from its default location to the same folder as my stack. I imported it into a custom property. The problem is that when I export the custom property contents back to disk I can't access t