Solved

Open a textfile into notepad

Posted on 2006-11-10
6
1,128 Views
Last Modified: 2008-01-09
Hi: Can any one please tell me how do i open a textfile into notepad thru VBA.

Thanks.
0
Comment
Question by:mustish1
6 Comments
 
LVL 119

Assisted Solution

by:Rey Obrero
Rey Obrero earned 200 total points
ID: 17919707
try this

FollowHyperlink "C:\TextFile.txt"

if Notepad is your default text editor, it will open the file in notepad
0
 

Author Comment

by:mustish1
ID: 17919711
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
 
LVL 119

Assisted Solution

by:Rey Obrero
Rey Obrero earned 200 total points
ID: 17919740

you can use the shell

    Dim stAppName As String

    stAppName = "C:\Windows\system32\notepad.exe C:\TextFile.txt"
     Call Shell(stAppName, 1)
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 65

Assisted Solution

by:rockiroads
rockiroads earned 200 total points
ID: 17920165
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
 
LVL 65

Accepted Solution

by:
rockiroads earned 200 total points
ID: 17920166
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
 
LVL 44

Assisted Solution

by:Leigh Purvis
Leigh Purvis earned 100 total points
ID: 17920367
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

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now