Need Help to create macro

[Juiceman101]

Im trying to create a macro that will open excel and then a spacific file over a network drive. is this even possible or should i just create a link to open excel and then the user can select the file that they want to use from there? Please help. im just begining with access. and i dont code sql or vb so is it possible without coding?

thanks
Juiceman101

 

[FoFa]

Try using the RUNAPP macro command, the only issue is the filename would be hardcoded.

 

[Juiceman101]

Thanks

Thanks for the help, but i tried that and it wont allow the link over the network. even though i have the drive mapped. could you give an example of what the code would be like? and i cant find the RUNAPP macro. where is that? im using Access 2003, if that helps any.

 

[FoFa]

RUNAPP is a macro command in Access. Basically you tell it the path to Excel and the excel program, and the path and file to open. Think of it as running excel from a DOS command prompt. It would be somrthing like:
C:\program files\microsoft office\bin\excel.exe S:\myfiolder\myfile.xls

 

[Juiceman101]

Cool Thanks

Thanks that helps a ton. and its working that way.