Hi Everyone,
I'm sorry to bother you with this, but i'm kind of stuck and looking for assistance.
I am looking for a way to have a report run automatically, refresh its data, and save as a PDF into a dropbox or Evernote folder....any ideas? I am using Excel 2010 and the file is saved on my laptop that is always connected to the net. I really appreciate any help!
Thank you.
Will
Hi Will,
I'd record a macro of you doing it at first. The PDF creation records a macro nicely, so should be good start.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Thanks Nathan. I'm assuming for this task, it will have to be a mix of VBA and macro? Since I need the report to be run automatically, will I need a script in a scheduler?
to run things atutomatically, how do you mean at a time or on opening, on opening is the Workbook_Open event, and scheduling will be using Application.OnTime. I'd read up on that, cause it needs to be stopped otherwise it keeps going.
Thread posted in Commercial services, hence closed.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks