Forum Discussion
Solved
Macros & Passwords
I inherited an excel spreadsheet when I became the treasurer for the school band. It is Excel 2013. So old. Within my spreadsheet, each student has an account page. Every month a macro creates a pdf ...
- It sounds like the original author took a picture of the password information just so future users will have it but almost certainly the password itself is in the VBA/macro section. You and go there and search for the password and try to change it yourself. if you click alt-F11 that should open the VBA editor/environment and then on the left is a list of the workbooks that are open (and maybe some other things) if you don't see that try clicking ctrl-R to open the project explorer. double click an item is the workbook of interest to open a page of code (even if it is blank) and then hit ctrl-f to do a search. make sure you select entire project on the bottom left. search for the old password.
Other than that, I would need the workbook to help you.
ah. got it. for some reason my PMs don't give me that notification so I often don't realize I got a new message right away.
I sent u another message. But I’ll type it here too. I don’t think the password is my only issue. Google stopped supporting less secure apps which includes my excel. Do u think updated my excel would help, or perhaps using a different email?
- I have no idea what sort of protocol was used to log into the gmail and send the messages so not sure why it isn't working. You could also have a local mail client (application) on your computer that has the account information and send mail using that. Another option is to use Office 365 and then you have access to the additional MS apps either local or online.
- So with Office 365, would that include an MS email address?
- Yes I believe it does. Here is a link that might be helpful. It teaches and gives code to create a mail merge using excel:
https://www.youtube.com/watch?v=URF3ikW0Svc
Maybe you could use some of that code to create the e-mails