[AccessD] How to Open Notepad (Maximized) to view a CSV file

Hi Brad, there are parameters to the Shell that you can use for max/min/focus/nofocus.  Here's the syntax for maximized with focus:

shell("C:\Windows\Notepad.Exe C:\Temp\Foo.Txt",vbMaximizedFocus)


HTH,

John
-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Friday, February 27, 2015 8:25 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] How to Open Notepad (Maximized) to view a CSV file

All,

I have an Access 2007 application that needs to open a CSV file with notepad (Maximized) instead of Excel.

I have done some experimenting with both Shell and Application.FollowHyperlink with commands like this.


Shell "notepad.exe C:\Test.csv"


Application.FollowHyperlink "C:\Test.csv"




Shell opens the file with Notepad, but it is not maximized

Application.FollowHyperlink will open the file maximized, but it opens it in Excel and I need it to be opened with Notepad.

Is there a VBA instruction that will open a CSV file with Notepad with a Maximized screen?

Thanks

Brad 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com