Print Page | Close Window

Printing to PDF and naming a tab in Excel

Printed From: www.exp-systems.com
Category: PDF reDirect
Forum Name: Using PDF reDirect
Forum Discription: Questions and Comments on using PDF reDirect Freeware and Pro
URL: http://www.exp-systems.com/Forum_exp/forum_posts.asp?TID=572
Printed Date: 23 Nov 24 at 8:25AM


Topic: Printing to PDF and naming a tab in Excel
Posted By: Rebecca L
Subject: Printing to PDF and naming a tab in Excel
Date Posted: 20 Jan 10 at 2:26PM
Hello
 
I'm trying to create a macro that will do two additional things. 
 
First I have a cell (A2) that is changing based on a vlookup formula and I would like the name of the Excel tab (not the whole Excel worksheet) to change to whatever Cell A2 is equal to. 
 
After the tab name is changed, I want to print the worksheet to pdf (I currently use Do Pdf, however, have read that it isn't compatible with what I'm trying to accomplish.  I'm willing to add another pdf program to my PC in order to accomplish this) and name the pdf file the same as the tab name that changed in step one. 
 
Any help with coding, etc would be greatly appreciated!  Thanks!


Replies:
Posted By: Michel_K17
Date Posted: 20 Jan 10 at 11:58PM
H Rebecca,

   Sorry, I do not provide coding advice. I'm already overloaded as it is.

   However, one excellent option sis to ask someone to help on http://www.getacoder.com - www.getacoder.com . Often, you can put your question up for a bid, and get someone to provide an answer for $5 to $20. This web site

   I hope that helps.



-------------
Michel Korwin-Szymanowski
EXP Systems LLC

Posted By: karldeabrew
Date Posted: 26 Jan 10 at 11:52PM
If you post your question to our StackExchange style help forum @ %20http://help.4xpdf.com - help.4xpdf.com you should be able to get some assistance...


Print Page | Close Window