Hardware

Ask something
Question Locked

Opening a Excel document from a form in Access 2003

0 helpful
4 replies

by sonya.pewtress 2 views

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am a beginning datbabase developer, and I created a form, I need VBA assistance. When a command button is clicked I would like it to open a excel document saved on my hard drive. The document is a insurance premium calculator that I created. The information will not be stored in the database, just used occasionally. Any help would be great with the VBA.

4 replies

by sgt_shultz

supply the path and name of the excel executable and your speadsheet name. See Access Help for more

by sonya.pewtress

The spreadsheet is located at P:\Tables\FEHB PT Calculator.xls . FEHB PT Calculator is the name of the file.

Thank you for your assistance.

This discussion is closed to new replies.