Åben excel med bestemt fil fra Access?

http://www.mvps.org/access/modules/mdl0006.htm

http://www.mvps.org/access/modules/mdl0035.htm

You can also use ShellExecute which will open any file in its associated application. For example and .xls file will open in Excel!
http://www.mvps.org/access/api/api0018.htm

Denne åbner Excel og lukker Access. Hvis Access ikke skal lukkes ,ubndlader du linien DoCmd.Quit. Husk en reference til Excel i tools > References:

Dim xls As New Excel.Application
xls.Visible = True
xls.Workbooks.Open Filename:="D:\VBA\XP\Mappe1.xls"
DoCmd.Quit

Tak - begge fungerer!

Men mugs var nemmest - så han får point

marcus25>Have you tried using shellexecute? mugs' solution deosnt do anything which shellexecute does other than close access and you didnt ask for that?

No, and it might be right, but it does the same with considerable fewer lines!

I'll remember that in future!

Ved den tråd er gammel, men.
Fungerer fint. Så længe filen ligger på feks. C:, men det fejler når den ønskede fil ligger på Onedrive.