Exporting PDF to SharePoint site

Alright experts,
I have a macro that uses the ExportAsFixedFormat function to create a PDF an upload it to our company's SharePoint site. The trouble I have is with the password required to upload to the site. If the site as been accessed, there are no problems for the rest of the day. But, I'd like to hard code the password in so that there isn't an error thrown if I haven't already accessed the site. Thanks for the help.

Can this be done?