On Thu, 29 Apr 2010 07:50:21 GMT, Achit via AccessMonster.com wrote:

I Have 2 question
1.I want maximize view of form, when I move to another computer, the view of
form not flexible, it means on computer A the view is normal(maximize), but
on computer B the view is mess.What should I do????

2.How to open excel files using command button on access vba.
I have syntax
Dim stAppName as string

stAppName="Excel.exe C:\Myspreedsheet.xls"
Call shell(stAppName, vbMaximizedFocus)

it works but When I use:
stAppName="Excel.exe C:\Audit\Myspreedsheet.xls"
it doesn't work..What should I do if I want open file in folder or subfolder??
??

Is the file name Myspreedsheet or Myspreadsheet?
Make sure you've spelled it correctly.
Is it in a Folder named "Audit"?
Assuming the file is actually named MySpreadsheet, why not simply use:

Application.FollowHyperlink "c:\Audit\MySpreadsheet.xls"

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail