We help IT Professionals succeed at work.
Get Started

automatically unlock incoming sheet - import file macro

mikes6058
mikes6058 asked
on
101 Views
Last Modified: 2016-02-10
The "import" button on the attached sheet entitled "master query log"  is designed to automatically add the details of the chosen file sheet to the bottom row of the master query log spreadsheet. However in the future the files that need to be imported will be password protected (current sheet).

Two queries.

1.Could someone change the coding of the macro assigned to the "import" button so it will import the same information as it is currently set up to but for the attached sheet "random query". I have attached an example of the previous import file (query) for you to test and see how it should work for the "random query" template instead.

Note: import files will always be in the layout and format of that found in the attached "random query" sheet. They will always be current sheet protected with the password trinity.

2. Automatically unlock the incoming sheet so it can be copied into the master query log. The password is trinity
Master-Query-Log-V01--2-.xlsm
random-query.xlsm
query1.xlsx
Comment
Watch Question
Group Finance Manager
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 13 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE