pat= Application.CurrentProject.path & "\Serviços-Materiais-" &
Forms![Orçamento]![numprojeto]
call shell(pat) or call shell(pat &".xls") it does not do right
how to do to open a file of the excel, of easier way?
To open a file of the Excel using code VBA, but using a path?
Advanced Beginner
Windows 7 32bit 
Access 2003
pat= Application.CurrentProject.path & "\Serviços-Materiais-" &
Forms![Orçamento]![numprojeto]
call shell(pat) or call shell(pat &".xls") it does not do right
how to do to open a file of the excel, of easier way?
VIP
Windows XP Access 2010 32bit
Try:
Shell "Excel.exe " & pat, vbNormalFocus
This article shows another method for opening files: http://allenbrowne.com/func-GoHyperlink.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Advanced Beginner
Windows 7 32bit Access 2003
ok, it is correct, very much thank you!
Excel code not working with Excel open
Posting Permissions
Reply With Quote