Command Button Open Network Path (file)

[Neondog82]

Hello all. I have been searching for a while trying to find a way to have a command button clicked and to open a txt file from a network share. I seem to understand half the concepts for the VBA code but I am just missing a certain piece. Can someone please help me write the code to open a txt file from a network path? Thank you so much for your time.

 

[dhookom]

You should be able to use a line of code like:

FollowHyperlink strFileName

Duane
Hook'D on Access
MS Access MVP

 

[Neondog82]

Dhookom, thank you so much. Is it possible to put a variable in the string?

Here is my psuedo code for what I am doing:

FName As String
FName = "Bob"
FilePath As String
FilePath = "\\NETWORKPATH\FName.txt"

trying to open bob.txt

 

[dhookom]

The code I provided did open a file name stored in a string variable.

  Dim FName As String
  FName = "Bob"
  Dim FilePath As String
  FilePath = "\\NETWORKPATH\" & FName & ".txt"
  FollowHyperlink FilePath

Duane
Hook'D on Access
MS Access MVP

 

[Andrzejek]

Another way you may try is to open text file in Notepad:

Dim lngRetVal As Long
strFile = "\\NETWORKPATH\FName.txt"[blue]
lngRetVal = Shell("NOTEPAD.EXE " & strFile, 1)[/blue]

Have fun.

---- Andy

 

[Neondog82]

Again, thank you so much. I really appreciate it.