how to open a file

[smayshar]

hello, I have a Continuous Form that has a string fild which the user put in pathes(locations) of files that he wants to open on click
what will be the code to open the file ?

 

[jrbarnett]

The actual code depends on what you want to do with the file when its opened. Do you want to read data from it, write data to it, do both (read/write) data, open the file in its native application (eg load a .doc file into Word) or what?

John

 

[oharab]

As John says, "opening" files when talking VBA has a very specific meaning.
What I think you mean is open a .doc file in word, .xls in excel, etc.
If that is the case, then take a look at faq705-1971 which gives you a function to do just that.

Cheers

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"

NoFX-The Decline
----------------------------------------------

 

[smayshar]

thenks, John,Ben
regardless to the kind of files the user will input, I ansure it will be string of the location of the file,how do i open it the same as the operating system opens it?

 

[smayshar]

BEN the link u sent was perfect
that exactly what I needed
Many thenks