Hi Everyone,

I think my thread name says it all but I will go into more details...

I currently have an automated General Journal(GJ) that posts my inputs into my General Ledgers(GL), accommodated on the information I supply from the GJ. The outputted data is posted in my GLs as a string, so it will not recalculate or update, same goes for the information in my GJ. Now to the dilemma...

I need a code that can be activated by a CommandButton, from my main menu, that will basically highlight my entire GJ and Save it as a PDF file - only, I need it to be saved in my OneDrive folder.

Does anyone know if this can be done?

The reason I want it uploaded immediately is because I do not want a copy linked to my PC, and I do know the recycling bin keeps a digital footprint of deleted files.

Any ideas?

WesRuss