Function in Access to Open Excel adn Save as .pdf 2

[Tekhelpnet]

Helo everybody!

I am going to try my best to explain.
Just got a new job.
I am System Analyst and writing some Reports.
I just saw few Excel Reports that are suppose to be saved as pdf file and send by email to clients.
It takes ennormous amount of time to do this.
I was wondering if I can write a function in Access that will open Excel (I have to call Excel Application somehow)file using it's path and save every worksheet (Name_Date)in Path directory.
Then I could simply take these files and post them.
It would save me days.
I am open for ideas. I use to have this function years ago but I forgot completely how to write them.
Please, help me to find a way.
Thanks

 

[Tekhelpnet]

tHANKS jERRY! iT IS IMPORTANT PART, i FORGOT eXCEL WOULDN'T CLOSE ITSELF...