How to Export Excel file to PDF and Save in Folder by using VBA Button

 How to Export Excel file to PDF and Save in Folder by using VBA Button 

  • Open a new excel file
  • Click on developer tab
  • Click on visual basic tab


  • Click on Insert tab
  • Click on Module tab
  • Paste VBA Code
  • Replace Folder path 


  • Save this file in Excel Macro enabled work book format. OR
  • Save it in Excel Add-ins format.

  • Paste that saved file in below folder path (in C drive)


  • Do right Click on any free white space.
  • A new option list will be Opened
  • Click on Customize ribbon. 

  • Select Macro
  • Select Main Tab
  • Select Home Tab
  • Click on New Group
  • Do Rename created New Group
  • Select New Group
  • Select VBA Code ( Ex. SaveActiveSheetAsPDF...)
  • Click on Add button.
  • Click on New TAB under new group
  • Do Rename of New Tab.
  • Select any Icon for new Tab and click on ok



  • A New Button with VBA code will be created under home tab in all excel sheet.

  • Select print range by using page set-up under page Layout tab.

  • Click on button & file will be exported in folder.


  •     Exported PDF file will be placed in folder.


  • Sample file


Thank you

Comments

Post a Comment

Popular posts from this blog

Skill Matrix Tool & Excel Format

Image
Skill Matrix Tool About Skill Matrix: A skill matrix tool , also known as a competency matrix or skill assessment matrix, is a valuable resource for organizations and individuals alike. It helps assess and visualize the skill levels and proficiencies of individuals within a team or organization. Here are some benefits of using a skill matrix tool: Identifying Skill Gaps: A skill matrix tool allows you to clearly see where there are gaps in skills within your team or organization. This can help in planning training and development programs to address these gaps and enhance the overall skill set. Training and Development Planning: With a skill matrix in place, you can create targeted training and development plans for individuals. This ensures that employees receive training that is directly relevant to their current skill levels and future career goals. Succession Planning: Skill matrices can assist in identifying potential successors for critical roles within the organization. By un
Read more

How to take print out of multiple pdf files in one click.

Image
  How to take print out of multiple pdf files in one click. Step-1 Save all Pdf files in a folder. Step-2 Open control panel and select "printer and devices". Right click on printers and devices Click on the option  "See What's Printing" A new window will open, keep it open and do it smaller size.  Step-3: Open "What's see printing" window & file folder in parallelly. Select all files in folder.  Step-4 Drag all selected files from folder to " See what's printing" window. Step-5 Click on Yes, all prints will come in one command. Thank you
Read more

Use Vlookup in multiple columns at a time

Image
माइक्रोसॉफ्ट एक्सेल में  30 कॉलम में एक साथ VLOOKUP FORMULA कैसे लगायें।  वीडियो को देखने के लिए यहां क्लिक करें। How to vlookup multiple columns in Excel – example Here is the VLOOKUP formula we have: = VLOOKUP ( I2,A:F, { 4 , 5 , 3 } , FALSE ) But you can’t just insert this formula into J2 cell and hit enter. This would only return one value. What you need to do is select a vertical array that corresponds to the number of columns in your VLOOKUP formula. In our case, we need to select three cells. After that, you can insert the formula to the formula bar and press  Ctrl+Shift+Enter  for Windows ( Command+Return  for Mac) – this will apply an array formula in Excel. Excel Online vlookup to return multiple columns  In Excel Online, VLOOKUP works almost the same way, but you don’t have to select an array and press the combination of buttons to implement it. You can just insert the formula in one cell and press  Enter  => the matching values for the columns specified in the formula w
Read more