Macro to Open New Workbook

This project received 11 bids from talented freelancers with an average bid price of $7 USD / hour.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
Total Bids
Project Description

**This project is urgent. If you bid on this project you need to be able to start work ASAP**

-Create a macro in an Excel file that opens a second Excel file.

-The second file is in the same directory as the first, but the directory itself is unknown. This means VBA will need to look up the location of the first Excel file in order to open up the second from the same directory.

- The second Excel file is password protected. The macro must enter the password.

- The second file must open Read Only. ([url removed, login to view] Filename:= "C:\[url removed, login to view]", ReadOnly:=True )

- The second file must use the Workbook_BeforeSave event to hide all worksheets and protect the workbook with a password before it is saved. (Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) ....)

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online