you can.” - John Wesley
-
From: saravanan R
To: excel-macros@googlegroups.com
Sent: Tuesday, August 18, 2015 2:05 AM
Subject: Re: $$Excel-Macros$$ Excel to Pdf
Hi Paul,
I found macros to export all the sheets to PDF, but I need to select only the
s
---
> *From:* saravanan R
> *To:* excel-macros@googlegroups.com
> *Sent:* Thursday, August 13, 2015 5:41 AM
> *Subject:* $$Excel-Macros$$ Excel to Pdf
>
> Hi,
>
> I have an query about exporting each sheet(multiple sheets but not all) of
> the excel workbook to Pdf an
cel-Macros$$ Excel to Pdf
Hi,
I have an query about exporting each sheet(multiple sheets but not all) of the
excel workbook to Pdf and save this PDF by name provided in the list.
This task should be automated, because there are 20 to 45 sheets in the report.
Please help me sort out this time cons
Hi,
I have an query about exporting each sheet(multiple sheets but not all) of
the excel workbook to Pdf and save this PDF by name provided in the list.
This task should be automated, because there are 20 to 45 sheets in the
report.
Please help me sort out this time consuming task.
thanks in adv
Dear Abdulgani,
Please use this one, and Change your path as per your
requirement...
Sub exltopdf_converter()
On Error Resume Next
flname = Application.GetOpenFilename(MultiSelect:=True)
For Each flnm In flname
Workbooks.Open Filename:=flnm
sheetname = ActiveWorkbook.Name
ActiveWo
*Workbook.ExportAsFixedFormat Method:*
http://msdn.microsoft.com/en-us/library/bb238907%28v=office.12%29.aspx
Regards,
MARIES.
+971559828492
On Sun, Dec 4, 2011 at 5:20 PM, Sam Mathai Chacko wrote:
> You will either need excel 2010 or install the pdf addin in excel 2007
>
> here's the link http
You will either need excel 2010 or install the pdf addin in excel 2007
here's the link http://www.microsoft.com/download/en/details.aspx?id=9943
Sam Mathai Chacko
On Sun, Dec 4, 2011 at 6:18 PM, Abdulgani Shaikh wrote:
> Dear Noorain,
>
> I have gone through your code of Excel to PDF, but it is
Dear Noorain,
I have gone through your code of Excel to PDF, but it is not working.
Please guide where I am wrong.
Sub exltopdf_converter()
Dim wrknm As String
wrknm = ActiveWorkbook.Name
wrknm = Left(wrknm, InStr(1, wrknm, ".") - 1)
ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename: