encrypt

Hi, I've got a text-file with aes-encrypted content generated by a software in use at my place. It contains a database name, an username and the corresponding password. In the software, the user can enter these parameters, establish a connection to the database (Oracle DB) and perform different...

Hello there, Hopefully everybody is fine, I have planned a lot and structured the data for many hours and days, now I would like to know how I can link excel cell value of workbook1 to workbook2 in the case that they are in google drive because when I opened the other workbook is shows a...

I have a macro which creates a new workbook. The goal is to have any file created from this workbook "tagged" so when we upload the file, the tag is recognized. If the tag does not exist, the upload is rejected. One idea I had was to use a SHA1 encryption code and plop it into a cell with the...

I am trying to create a spreadsheet that contains personal sensitive information, in this case, Social Security Numbers. Individuals will be asked to enter information, including their SSN. However, I want the SSN to be automatically encrypted once the user fills in the number. The number...

Morning, Please can someone help me with a Print to PDF Macro with a password specified from a cell. I'm really struggling with this! I have PDF Creator but any macro I try doesn;t work so far. "Dim.pdfjob as PDFCreator." is part of the problem, I only have the options "PDFCreatorOBj...

Hi, We need to personalize a (.pdf) memo to multiple recipients, from a mail merge (source: excel data spreadsheet), and wish to have the individual memos encrypted since we plan to send the personalized memos via Outlook email-merge automatically. Has anyone accomplished this before? Each...

I've been trying for countless hours and I can't figure it out. I have the below code for a UserForm in Excel. Everything runs as it should except that it refuses to actually encrypt the email. Anybody able to help? Private Sub Submit_Click() Dim OutApp As Object Dim OutMail As Object Dim...

Hi, I am trying to make it so that a spreadsheet cannot be opened without a password after a certain date using VBA.. So far I have this Private Sub Workbook_Open() If Sheets(1).Cells(2, 2).Value <= Date And Sheets(1).Cells(2, 2).Value <= Date Then ActiveWorkbook.Protect...