VB Code to open closed workbook and add print area

**rizmomin** · 03-11-2015, 10:54 AM

Hello:

I need a VB Code to preform following task.

I need to open password protected closed workbook, directory and name of the file will be in cell A2.
Password will be 1234.
Then need to go "Report" Sheet and then do "Set Print Area" by select range A1:L1376.
Then need to add "END in cell A1336 of this sheet.

Please let me know if you have any questions.
Thanks.

Riz

**mikeTRON** · 03-11-2015, 01:50 PM

Where are you having trouble?
Did you try the macro recorder? This is a pretty simple request.

This should get you started:

Please Login or Register  to view this content.

**rizmomin** · 03-11-2015, 02:27 PM

Hi mikeTRON:

Thanks a lot for your help, i will start wit this and should be able to complete my task.

Riz

VB Code to open closed workbook and add print area

LinkBack

Thread Tools

Rate This Thread

Display

VB Code to open closed workbook and add print area

Re: VB Code to open closed workbook and add print area

Re: VB Code to open closed workbook and add print area

Thread Information

Users Browsing this Thread

Similar Threads

Macro to open a closed workbook and select copy cells into an open workbook

VBA to set print range, open box asking for print qty, print, then redefine print area

Open file after workbook executing code is closed

[SOLVED] Macro code to open a workbook only when closed

Print Area:What would be the code for setting the print area

Bookmarks

Bookmarks

Posting Permissions