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

John and Paul,

(I almost wrote John, Paul, George, and Ringo  :-)

Thanks for the help, I appreciate it.

I now have it working nicely, plus I learned something new this morning.

Thanks again,

Brad  

________________________________________
From: accessd-bounces at databaseadvisors.com <accessd-bounces at databaseadvisors.com> on behalf of John Bodin <jbodin at sbor.com>
Sent: Friday, February 27, 2015 8:25 AM
To: Access Developers discussion and problem solving
Subject: Re: [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

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