Macro to Open New Workbook

Closed

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

Skills: Excel, Visual Basic

See more: 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

About the Employer:
( 4 reviews ) chicago, United States

Project ID: #4286213

11 freelancers are bidding on average $7/hour for this job

djain01

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

$8 USD / hour
(12 Reviews)
5.4
nagybatonyi

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 / hour
(39 Reviews)
5.3
ethicalboy

Easy task, let me see your file please.

$8 USD / hour
(21 Reviews)
4.4
FLinCanada

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 More

$8 USD / hour
(7 Reviews)
2.9
seaanddream

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

$8 USD / hour
(5 Reviews)
2.8
sokhom168

I can make it done nnow.

$2 USD / hour
(1 Review)
1.3
chelseasmile

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 / hour
(0 Reviews)
0.0
danneacsu

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

$10 USD / hour
(0 Reviews)
0.0
amitchaps

Hi, Interested.Have done a similar functionality before. Please check my message.

$6 USD / hour
(0 Reviews)
0.0
DoGau247

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

$7 USD / hour
(0 Reviews)
0.0
pararols

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

$7 USD / hour
(0 Reviews)
0.0