Need Help, New to the Forum

[pujo]

Hello to all from the Gulf of Mexico.

Name here is Pujo, and I need a little help.

I am using Excel 2003, I want to use certain cells in my database and convert them to word or pdf and email.
I do not need to save the db and I only need a portion of the spreadsheet, not the entire sheet.

I have searched over the net and found nothing.

If anyone can shed any light on this please do.

Thanks in advance,
pujo

[gistek]

On one of the tabs in the Page Setup window there is a place where you can set the print area.

It's the same tab that lets you set the rows and columns to be repeated on every page.

[pujo]

Originally Posted by gistek

On one of the tabs in the Page Setup window there is a place where you can set the print area.

It's the same tab that lets you set the rows and columns to be repeated on every page.

I tried to record a Macro, my steps are as followed.
Started recording, set print area, convert to pdf and email, reset print area.

I thought this would work, but when I wanted to reset the print area it gave me an error. So I am still trying.
I will paste the code in a few.

Thanks,
Pujo

[pujo]

ok,
Here is what I have so far.


Private Sub CommandButton1_Click()
ActiveSheet.Range("A6:K32").Select
ActiveSheet.PageSetup.PrintArea = Selection.Address
ActiveSheet.PageSetup.FitToPagesWide = 1
ActiveSheet.PageSetup.FitToPagesTall = 1
Application.ActivePrinter = "Adobe PDF on Ne05:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"Adobe PDF on Ne05:", Collate:=True
ActiveSheet.Range("A1:K91").Select
ActiveSheet.PageSetup.PrintArea = Selection.Address
ActiveSheet.PageSetup.FitToPagesWide = 1
ActiveSheet.PageSetup.FitToPagesTall = 1
End Sub

Problem is that I want to use the "convert to adobe pdf and send for review" rather than just convert to pdf.

Is there anyway that I can do this?

[gistek]

I haven't done much with Macros, but I believe that any command available within the application can be used in a macro.

If there isn't a "... and send for review" command, you may have to settle for ending with the print to .pdf

You should be able to set a save directory for it that will make it easy to send for review as a non-excel action.

If this isn't helpful, and no one else responds, try posting a new thread with the title, "Excel Macro Help Needed" and include your Excel version, the macro and what you want it to do. The title will attract someone more macro savvy than I am, and a full description, including the Excel version and macro will help elimiate some question and answer posts.