Convert VBA to C#

richard smith

I need this line of code:

ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF FileName:="sales.pdf" Quality:=xlQualityStandard DisplayFileAfterPublish:=True

converted to C#

Can someone please oblige this request?

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
Accepted answer
If you don't specify a full path, then the file will be saved to the 'current' directory, normally the same directory as the .exe starts from.

If you don't want to hard-code a path, then it's possible to save files to system folders using the Environment.SpecialFolder enumeration:

http://msdn.microsoft.com/en-gb/library/system.environment.specialfolder(VS.100).aspx
richard smith13y ago
I had to list out where it was saving the .pdf. DUH! Such a simple fix.
richard smith13y ago
That is definately generating a .pdf but my ? is where does it save it, or do I need to add a parameter in to save the pdf also?
richard smith13y ago
Let me give that a twirl. I have lots of variables so it may take me a bit to get them updated as such.
Vulpes13y ago
What I generally do with Excel is to add this 'using' alias at the top of the file:

using Excel = Microsoft.Office.Interop.Excel;

I then prefix everything with Excel. So the call to this method would become:

Excel.Application oXL = new Excel.Application();
// etc

oXL.ActiveWorkbook.ExportAsFixedFormat
(Type: Excel.XlFixedFormatType.xlTypePDF, Filename: "sales.pdf", Quality: Excel.XlFixedFormatQuality.xlQualityStandard, OpenAfterPublish: true);

If you need to use tools as well, you could define a using alias for that:

using XLTools = Microsoft.Office.Tools.Excel;

and then use that alias to distinguish between the two.

However, if you don't need to use tools then, yes, I'd remove the assembly reference as Office interop is complicated enough!
richard smith13y ago
I added a Assembly Extension to the Microsoft.Office.Tools.Excel.v4.0.Utilities

On the very first argument
(Type: XLFixedFormatType.xlTypePDF,

I get a compile error of The name 'XLFixedFormatType' does not exist in the current context.

However on top of that, I am now receiving multiple Errors like:
'Workbook' is an ambiguous reference between 'Microsoft.Office.Interop.Excel.WOrkbook' and 'Microsoft.Office.Tools.Excel.Workbook'

And the 2nd compile error of Cannot find the interop type that matches the embedded interop type 'Microsoft.Office.Tools.Excel.Worksheet' Are you missing an assembly reference?

I am going to remove the Assembly Extension, as that will remove my compile errors. Did I do that incorrectly?
Vulpes13y ago
Try this:

oXL.ActiveWorkbook.ExportAsFixedFormat
(Type: XlFixedFormatType.xlTypePDF, Filename: "sales.pdf", Quality: XlFixedFormatQuality.xlQualityStandard, OpenAfterPublish: true);

The ExportAsFixedFormat method doesn't have a parameter called DisplayFileAfterPublish (not in Excel 2007 anyway) so I've assumed that it must be OpenAfterPublish that's intended.