2007-2003 Excel + VBA

[Istiyak]

I m using 2003 at my office and my other office using 2007.


The query is that when i m designing something in 2003 and open it at my other place in 2007 it will looking mismatch..... (not at proper place as i already set up good in 2003).


while i m coming back and checking it in 2003 it is fine.


Kindly suggest what is the Issue..


The another thing is VBA problem.


i m not able to export the selection as PDF format.


VBA


sub pdf()


range("a1:a10").select

Selection.ExportasFixFormat type:=xlTypePDF, filename:=123

msgbox("Exported Successfully")


End Sub


Any Suggestion or resolution plz guide..


Regards

Istiyak

 

[dan_l]

I think it should be ExportAsFixedFormat and not ExportAsFixFormat.

 

[Istiyak]

Hi Dan_i


i already type the same thing as u mentioned. bt still awaiting for solution.


Regards

Istiyak

 

[dan_l]

can you send me or post the file?

 

[Istiyak]

Hi dan_I


i have upload file on my website


http://www.istiyakshaikh.hpage.com > Downloads > PDF Export


Any query plz let me know.


regards

Istiyak

 

[SirJB7]

Hi, Istiyak!

Tried replacing:

Selection.ExportAsFixedFormt Type:=xlTypePDF, Filename:="Sample"

by:

[pre]Selection.ExportAsFixedFormat Type:=xlTypePDF, Filename:="Sample.pdf", _
Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=True

[/pre]
I can't check in 2003/2007 but it works in 2010.

Regards!

 

[Istiyak]

Hi SirJB7


I m using Excel 2003


It is Showing


Run Time "438"

Object doesn't support this property or method..


Regards

!$T!

 

[SirJB7]

Hi, Istiyak!

You're right, I've checked it and it's a feature added in 2007 version.

A workaround and probably your best bet is to install PDF creator and then print to PDF creator printer.

With that installed, you can try recording a macro to find out if it's possible to automatize the process as desired.

Regards!

 

[Istiyak]

Ok,,,, SirJB7

Thanks For Your reply..


plz let me know if any alternative.


Regards

!$T!