Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Open a textfile into notepad

Posted on 2006-11-10
6
Medium Priority
?
1,146 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 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 800 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 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 800 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
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
LVL 65

Assisted Solution

by:rockiroads
rockiroads earned 800 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 800 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 400 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

971 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