How would I create a macro that will open an .xls? AdamZ 13.09.2006 15:48:02 How would I create a macro that will open an .xls file on my "C" drive? Thanks! -Adam

RE: How would I create a macro that will open an .xls? AdamZ 13.09.2006 15:58:02 I tried "runapp" with a test of "c:\test.txt" but receive the following error: "Microsoft Office Access can't invoke the application using the RunApp action... the path to the application is invalid." Does it matter that the .mdb is in the "i" drive? -Adam "AdamZ" wrote: [Quoted Text] > How would I create a macro that will open an .xls file on my "C" drive? > > Thanks! > -Adam

RE: How would I create a macro that will open an .xls? AdamZ 13.09.2006 16:09:02 Figured it out... _AZ "AdamZ" wrote: [Quoted Text] > I tried "runapp" with a test of "c:\test.txt" but receive the following > error: "Microsoft Office Access can't invoke the application using the RunApp > action... the path to the application is invalid." > > Does it matter that the .mdb is in the "i" drive? > > -Adam > > "AdamZ" wrote: > > > How would I create a macro that will open an .xls file on my "C" drive? > > > > Thanks! > > -Adam

Re: How would I create a macro that will open an .xls? "Ron2006" <ronnemec[ at ]hotmail.com> 21.09.2006 20:18:56 One way is application.followhyperlink "fullymappedfilenameofthespreadsheet" Ron