Access to Excel Exchange

[uaguy3005]

I have created a database to maintain an Quality Alert list (sort of an open issues list). I would like to add a button to the form that will open a blank excel form, that is saved on a network drive, and populate some of the cells with data that the user entered on the Access form. Any help would be appreciated.

[pbaldy]

This should get you started:

http://support.microsoft.com/kb/247412

[uaguy3005]

This should get you started:

http://support.microsoft.com/kb/247412

Excellent! Thanks for the help. Got it figured out

[pbaldy]

Excellent! Happy to help.

[tobydobo]

Hello,

This thread seems to be what I need; however, I need to be able to open an existing excel template and have access populate specific fields, then save as specific file name. Could you help me with the syntax?

[pbaldy]

Generically:

Set xl = CreateObject("excel.application")

xl.Workbooks.Open (strFile)

Where strFile is the path to the existing file. I suspect the rest is in that link.