Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1153
  • Last Modified:

Open a textfile into notepad

Hi: Can any one please tell me how do i open a textfile into notepad thru VBA.

Thanks.
0
mustish1
Asked:
mustish1
5 Solutions
 
Rey Obrero (Capricorn1)Commented:
try this

FollowHyperlink "C:\TextFile.txt"

if Notepad is your default text editor, it will open the file in notepad
0
 
mustish1Author Commented:
Yes it works. But is it possible if notepad is not my default editor i can still open the file into notepad only.

Thanks.
0
 
Rey Obrero (Capricorn1)Commented:

you can use the shell

    Dim stAppName As String

    stAppName = "C:\Windows\system32\notepad.exe C:\TextFile.txt"
     Call Shell(stAppName, 1)
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
rockiroadsCommented:
Cap's last post should do it, but u may want to use a envrionment variable or api to get the windows directory as if u run on windows 2000, default install is c:\winnt therefore code will fail if win2k installed there or your windows install directory is something altogether different.

1) Environment variable way
sFile = "c:\ppv.txt"
sRun = Environ$(SystemRoot) & "\notepad.exe " & sFile
Shell sRun,vbMaximizedFocus



0
 
rockiroadsCommented:
2) otherwise, u can do the api way - the one I prefer

add this to a module

Private Declare Function GetWindowsDirectory Lib "kernel32" Alias "GetWindowsDirectoryA" (ByVal lpBuffer As String, ByVal nSize As Long) As Long

Public Function GetWinDir() As String
    Dim sTemp As String * 256
    Dim x As Integer
    x = GetWindowsDirectory(sTemp, Len(sTemp))
    GetWinDir = left$(sTemp, x)
End Function



Now in your code, u can do this

sFile = "c:\ppv.txt"
sRun = GetWinDir & "\notepad.exe " & sFile
Shell sRun,vbMaximizedFocus
0
 
Leigh PurvisDatabase DeveloperCommented:
For convenience... once you've added ShellExecute (fHandleFile) to a standard module
http://www.mvps.org/access/api/api0018.htm
it's hard to ever even think about application launching.  You just do it - pass the file name as you would Followhyperlink.
Of course, it textfiles weren't associated with Notepad (they almost always are) then it'd open in whatever.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now