find a file with Browser

[DanNorris2000]

I want to be able to import a lotus worksheet to a free table. I want to be able to use a windows explorer type dialog box to locate the file I want to import click on the file so that the import can do its stuff. Any thoughts or examples would be appreciated. Using VFP 8

 

[EzLogic]

cFile = GetFile()


Ali Koumaiha
TeknoSoft Inc
Farmington Hills, Michigan

 

[rgbean]

You can use the IMPORT FROM or the APPEND FROM command assuming the version of the file is "old" enough. Check the help file for the details.

Rick

 

[DanNorris2000]

Is it possible to set a default path?

 

[craigsboyd]

Yes, with GetFile() you can specify a default directory but it takes an extra step...

SET DEFAULT TO "C:\"
?GETFILE()


Slighthaze = NULL
[sub]craig1442@mchsi.com[/sub][sup]

"Whom computers would destroy, they must first drive mad." - Anon​

[/sup]

 

[ChrisRChamberlain]

DanNorris2000

'Is it possible to set a default path?'

An alternative to GETFILE() with that facility is the Windows Common Dialog.

See faq184-3106 How can I select multiple files from Windows

FAQ184-2483 - answering getting answered.​

Chris

http://www.pdfcommander.com

http://www.pdfcommander.co.uk

 

[DanNorris2000]

lcOldDefault = SYS(5) + SYS(2003)
SET DEFAULT TO "k:\acct\rlw"
cfile=GETFILE()
SET DEFAULT TO(lcOldDefault)
IMPORT FROM cfile TYPE WK1

the above allows me to locate the .wk1 file that I want to import but returns file not found when import part is run

from debug cfile="k:\acct\rlw\aswp44.wk1"

 

[craigsboyd]

try enclosing the cFile in paranthesis such as...

IMPORT FROM (cfile) TYPE WK1

Slighthaze = NULL
[sub]craig1442@mchsi.com[/sub][sup]

"Whom computers would destroy, they must first drive mad." - Anon​

[/sup]