Sometimes, you need to b e able to export out a portion of your Excel sheet and print to PDF isn't quite right.
This might help you, as you can specify a range for any and all pages you have in an Excel file with this macro.
This will collect the data, turn this into a PDF content, and then write this out into a directory you choose!
-
Review the contents of the macro located in the etc folder.
-
Please follow the directions here, setting up the macro.
├── etc │ └── SampleMacOrWindowsReportExporter.macro.txt
- This is the source code to the macro
└── var └── SampleMacOrWindowsReportExporter.xlsm
- This is an example excel file with the macro installed
NOTE: Please handle any files downloaded from the internet with extreme care.
-
Scan the file for any viruses
-
Open the file and disable macros when originally looking
-
Only when comfortable, please consider carefully enabling macros
NOTE: It is highly recommended to follow the instructions and create the macro yourself.
Copyright 2020 Wayne Kirk Schmidt https://www.linkedin.com/in/waynekirkschmidt
Licensed under the Apache 2.0 License (the "License");
You may not use this file except in compliance with the License. You may obtain a copy of the License at
license-name APACHE 2.0
license-url http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and limitations under the License.
Feel free to e-mail me with issues to:
I will provide "best effort" fixes and extend the scripts.