Database form that can capture file address and save to cell in hyperlink format

roroexcel

New Member
Joined
Feb 12, 2020
Messages
1
Office Version
2016
Platform
Windows
Hi,
I have a database form that captures information off a physical form using a simple vba program. The physical form, once signed off, needs to be scanned and saved to a network folder. When the clerk is capturing the form in VBA, I would like them to be able to add a link to the copy of the physical file saved in pdf on a network folder.

Currently, the form opens and dates are captured, people, departments etc, the last one would ideally say PDF copy. They would hopefully be able to navigate to the folder, select the file and then back to the form. When clicking save in the form, the date in column 1, the name column 2 etc, all captured from textbox controls. The last column, in my case, N, would hopefully be a hyperlink to the pdf file that was scanned before capturing the information off the physical form.

So where it says link to site, if they can paste the address of the file to hyperlink to, then excel hyperlinks it on the database sheet 2, or if they could browse to the file that would be better.

I am struggling to explain clearer.

Is it also possible to add a print button, that could print a blank pdf copy of the form in question? The form, a pdf version of the vba form, is saved in the same place that the excel document is. That would be ideal.

Thank you.
 

Attachments

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Watch MrExcel Video

Forum statistics

Threads
1,102,344
Messages
5,486,309
Members
407,539
Latest member
ltwkuav

This Week's Hot Topics

Top