Hi there,
I am trying to create a VBA project that does the following:
Selects 2 named sheets - Sheet 1 & Sheet 2
Opens a Save As box for the user to select where they want to save the file
Creates a pdf file of the 2 selected sheets named as the same content in cell G3 and the current date...
Hello everyone, VBA newbie here. I didnt write this code but Im attempting fix some errors.
Whats supposed to happen is that a loop that is supposed to iterate over certain rows and create subsequent word and pdf files related to isnt working.
The debugger gives an error at the part which...
My question is hopefully rather simple, but I'm relatively new to VBA and I know nothing about Acrobat API. After spending the better part of the past two days scouring the web for an answer, I've only found long-outdated results (like like this post from 2016 based on this blog from 2009 and...
Hi there
I need to create a button, called "Submeter", which will be in a sheet called "Comp.proc.norm.NLT 107 98 ". I need to come up with a code for that button that does the following things:
*Creates a PDF of the worksheet and saves it in a selected location, for now it could be a folder...
I'm pretty new to all this, but I was wondering if anyone could help with a macro. I'm trying to get it to create a PDF of my current worksheet with certain cells as the file name in a predetermined folder. For instance:
A1=Job
A2 = Dallas
A3 = Today()
Folder = /work
The PDF would be created...
I have just moved from a laptop running XP/Excel 2007 to a laptop running Windows 8 64-bit/Excel 2013.
I have a .xlsm file that contains a macro which prints various sheets from the graph into 7 pdf files stored in other folders. The part of code that creates (i.e. overwrites the existing...
I have a spreadsheet exported from Access that contains each department's budget information (used, remaining, etc.).
I want to create a command button that when clicked will create a separate PDF for each worksheet. I want each .PDF file to be named the same as the Worksheet name.
Can you...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.