Macro to Open New Workbook

**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ää: macro open workbook, excel macro open workbook, excel vba open workbook, excel macro open file, vba open excel workbook, macro open vba project, create macro excel open workbook, open workbook open file file, macro open file workbook, macro open excel workbook, excel macro open workbooks filename, open workbook macro, open workbook vba, macro open file open workbook, 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

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

Projektin tunnus: #4286213

11 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_18% %project_currencyDetails_sign_sub_19%/tunti tähän työhön


Hi, Excpert in Excel VBA. Lets do it now. Thanks djain01

$8 USD / tunti
(12 arvostelua)

I'll complete it in 8 hours. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards!

$10 USD / tunti
(39 arvostelua)

Easy task, let me see your file please.

$8 USD / tunti
(21 arvostelua)

Sure Doug. I think you pretty much have this solved. It is just a matter of getting the right values (which you have researched) into the right places (which you have listed). Excel has a way of being difficult about t Lisää

$8 USD / tunti
(7 arvostelua)

Hi, I revised my bid. I bid at $16 in total. You will have the result asap. KR,

$8 USD / tunti
(5 arvostelua)

I can make it done nnow.

$2 USD / tunti
(1 arvostelu)

Hello, I've got the solution see details at PM. BR Albert Pararols

$7 USD / tunti
(0 arvostelua)

Hello... I am new to this group..! But I have worked on similar sheets before...!

$7 USD / tunti
(0 arvostelua)

Hi, [url removed, login to view] done a similar functionality before. Please check my message.

$6 USD / tunti
(0 arvostelua)

Hi, it's already done; see the video capture in PM

$10 USD / tunti
(0 arvostelua)

You described very good what you need. i have a good experience in writing vba makros. i have a skype account if you choose me, you will get the result within 48 hours

$5 USD / tunti
(0 arvostelua)