Open a file located on a network

[Sangmond]

I am trying to open a text file that is on a network, the path I am using is "//server/folder/text.txt"

So the code is like this

Open ""//server/folder/text.txt" For Input As testing
Input #testing, testdata
TextBox1.Value = testdata
Close testing

Put I kept on getting a msg say that runtime error 52 bad file name or number

Could anyone tell me how to work around this?

Thanks
Sangmond

 

[jebenson]

use backslashes in the filename, like so:

\\server\folder\text.txt

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

 

[Sangmond]

Sorry I just typed the slashes wrong in the post, put they are right in my program.

I am still getting the same error

 

[johnwm]

How are you assigning the testing variable? Try using the lines:[tt]
Dim testing as Integer
testing = Freefile[/tt]
just before your:
[tt]Open "\\server\folder\text.txt" For Input As testing[/tt]

Also check that you have access and appropriate rights in the folder.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[Sangmond]

Thanks works great now!!

 

[Sangmond]

Great THanks for all of your help

I have got it to work now

Thanks
Sangmond