forums.silverfrost.com

JohnCampbell · Joined: 16 Feb 2006 Posts: 2554 Location: Sydney

I expect the use_url@ is saying "Open this file with the default process for a .csv file".
The same result would occur if you typed the name in a dos box or double clicked the name in windows explorer.
If, in explorer, you change the default process to open a .csv file, say from excel to notepad, then you would get a different result with the use_url@ call.
You can set up the default response for other file name extensions, including for .f95 to be ftn95.exe, rather than plato.

John

IanLambley · Joined: 17 Dec 2006 Posts: 490 Location: Sunderland

Absolutely spot on John.
And if you specify a file with a .txt extension, then Notpad will open it, .doc for Word and .pdf for acrobat. This is an easy way of providing a help file, simply use Word, print to a pdf and then use_url@ with the pdf name.
It probably opens your default web browser for a .htm or .html etc.

I quite often write a .csv files and then "use_url@" an Excel file with a macro that executes on opening, to load the csv and process the data to new Excel files.

Regards
Ian

colt1954 · Joined: 21 Dec 2010 Posts: 81

The code you supplied if run precisely as you wrote it gives the following:

Runtime error from program:c:\documents and settings\ctroth1\my documents\fortran program\eva\test3.exe
Run-time Error
*** Error 29, Call to missing routine : _USE_URL# at 0x004010e3.

main - in file test3.f95 at line 7 [+00e8] [recur= 1]

LitusSaxonicum · Posted: Thu Jan 20, 2011 4:50 pm Post subject:

You need the interface to the subprogram, which is in Clearwin.ins (or the corresponding module). Other posters have assumed, perhaps, that you would use the line:

IanLambley · Joined: 17 Dec 2006 Posts: 490 Location: Sunderland

You got me again! - insert as the top line:

IanLambley · Joined: 17 Dec 2006 Posts: 490 Location: Sunderland

Thanks Eddie,
You beat me by a minute!
Ian

colt1954 · Joined: 21 Dec 2010 Posts: 81

so I need to do this:

include (windows.ins)
character*256 csvfile
csvfile='mycsv.csv'
open(unit=10,file=csvfile,status='unknown')
write(10,1000)
1000 format('"Hello there",1.0,2.5,3.1415926')
close(unit=10)
call use_url@(csvfile)
end

I do of course need to have my version of mycsv.csv in the directory I take it!!!

If this is correct I ran that it compiled and ran and just brought the dos screen and sat there!

LitusSaxonicum · Posted: Thu Jan 20, 2011 10:46 pm Post subject:

I didn't know about use_url@, but I have used START_PPROCESS@ with some success. This works (for Excel in Office 2007, Office 2003 is in the folder .... Office11 ....):

colt1954 · Joined: 21 Dec 2010 Posts: 81

Apologies Ian your prog does work it does write to the CSV its just that the black screen did not tell me !!! I should realise it wont unless you give some end message...thanks anyway.

But really this is doing no more than opening a file and writing to it in the normal Fortran fashion as I have been doing as I originally wrote is it not...

No what I want to do is write to an Excel worksheet which I did partly manage using SQL but it did seem limited at least using the prog examples supplied via F90SQL webpage EXCELWRITE, EXCELUPDATE examples the first kept moving on down the page and writing fresh data, the other update one seems restricted to only a few records...could not modifiy either to work....