CODEWITHSUNDEEP
vb.netvisual-studio-2013ms-officeexcel-2010
Joe
Joe

Reputation: 871

Visual Basic in VS 2013 and Excel 2010: cannot find xlQualityStandard (is not declared)

I am trying to code some Excel automation stuff using VB in VS2013. Basically, I can perform a lot of excel operation from my code (even applying the data analysis tool, and creating histograms).

However, in my case, Visual Studio is complaining 'xlQualityStandard' is not declared.

Here is a sample of my code

Imports Microsoft.Office
Imports Excel = Microsoft.Office.Interop.Excel

' do something
xlTempSheet.ExportAsFixedFormat(Type:=Excel.XlFixedFormatType.xlTypePDF, Filename:="c:\plots test\test.pdf",
                                    IgnorePrintAreas:=True, OpenAfterPublish:=True, Quality:=xlQualityStandard)

If I remove

Quality:=xlQualityStandard

The code will just work.

Upvotes: 2

Views: 908

Answers (2)

Toby Allen
Toby Allen

Reputation: 11213

The values can be found here

https://msdn.microsoft.com/en-us/library/bb241292(v=office.12).aspx

xlQualityMinimum    1   Minimum quality
xlQualityStandard   0   Standard quality

Interestingly Google now seems to provide API help

Upvotes: 1

Joe
Joe

Reputation: 871

In my case, 

Excel.XlFixedFormatQuality.xlQualityStandard

will work. Thanks to user2930100

Upvotes: 1

Related Questions