Macro to Open New Workbook - repost

**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) ....)

Taidot: Excel, Visual Basic

Näytä lisää: password vba project excel, password protected excel, excel macro file location, excel 2013 vba, vba excel macro, Macro vba, Excel Macro VBA, xls visual basic, excel vba project password, 2013 excel visual basic, excel vba macro file, excel 2013 visual, project macro, excel 2013 macro, create workbook, excel macro open workbook, excel vba open workbook, visual basic excel 2013, excel macro open file, vba open excel workbook, excel create macro, macro open vba project, create macro excel open workbook, open workbook open file file, macro open file workbook

Tietoa työnantajasta:
( 4 arvostelua ) chicago, United States

Projektin tunnus: #4286249

Myönnetty käyttäjälle:


OK. Let's do it now. I can help you with this ASAP.

$8 USD / tunti
(1 arvostelu)

2 freelanceria on tarjonnut keskimäärin 8 $/tunti tähän työhön


Sir, Ready to start now. Check your inbox.

$8 USD / tunti
(0 arvostelua)