Link to home
Start Free TrialLog in
Avatar of jnikodym
jnikodym

asked on

Automatically generate a pdf file from an excel file and email out everyday

I'm looking for the best way to automatically email out a report everyday.  I have an excel file with some vba code on it.  There is a macro setup to run a procudure on the excel file.  I need to have that macro run everyday, then create a pdf from the excel file, and then email that pdf file out.  Anyone know of a way to do this without any user intervention?
Avatar of Shaun Vermaak
Shaun Vermaak
Flag of Australia image

Use http://www.folderagent.com/
It can automate tasks against a monitored folder
  1. Select folder to monitor
  2. Printer to PDF
  3. Email PDF
ASKER CERTIFIED SOLUTION
Avatar of ServiceTeam
ServiceTeam

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial