manekankit
Board Regular
- Joined
- Feb 1, 2019
- Messages
- 72
- Office Version
- 365
- Platform
- Windows
Need help with macro to perform following task.
1. I have a file (Original file) with 5 sheets (Index, Report1, Report2, Report3, and Report4)
2. Colum B in Index sheet contains list of sheets for which pdf file is to be created (e.g. it contains Report1 and Report2 in cells B1 and B2 respectively). This list can increase or decrease.
Required:
1. Create a pdf file with sheets listed in column B of Index sheet.
2. Save that pdf file pre-defined name say'NewFile.pdf'.
3. PDF File should be saved to Original file path > Export > mmddyy (i.e. in the same path it should create 'Export' folder and in 'Export' folder it should create folder with dynamic name based on date(mmddyy) (eg. 11272022 for today) and file should be saved in this ddmmyy folder
4. PDF file should have pre-defined password ("ABC123").
Request you to help with macro code.
1. I have a file (Original file) with 5 sheets (Index, Report1, Report2, Report3, and Report4)
2. Colum B in Index sheet contains list of sheets for which pdf file is to be created (e.g. it contains Report1 and Report2 in cells B1 and B2 respectively). This list can increase or decrease.
Required:
1. Create a pdf file with sheets listed in column B of Index sheet.
2. Save that pdf file pre-defined name say'NewFile.pdf'.
3. PDF File should be saved to Original file path > Export > mmddyy (i.e. in the same path it should create 'Export' folder and in 'Export' folder it should create folder with dynamic name based on date(mmddyy) (eg. 11272022 for today) and file should be saved in this ddmmyy folder
4. PDF file should have pre-defined password ("ABC123").
Request you to help with macro code.