ExportAsFixedFormat VBA excel changing fonts

[Legacy 93538]

Good Morning,

I was wondering if anyone knew why ExportAsFixedFormat function excel VBA changes font from excel to PDF?

Currently i have a macro which goes though a range of cells and then exports a copy to PDF for each value, however one of cells in the excel sheet been saved to PDF uses a barcode font (IDAutomationHC39M). When it exports to PDF the font on these cells is being changed to ariel.

I have printed to PDF and the barcode is there and displaying fine in the PDF but when i use ExportAsFixedFormat the barcode font disappears.

Does anyone know what might causing this?

Currently i line of code i am using is

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=FolderPath & cell.Value

any help would be appreciated. Thank you in advance

 

[Legacy 93538]

Just so any one suggests i just noticed i left & ".pdf" off the end of the file name so i just added and also tired including the IncludeDocProperties option and still the barcode font converts to arial

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=FolderPath & cell.Value & ".pdf", Quality:=xlQualityStandard, _
        IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True

 

[Legacy 93538]

so i have found the solution. Was a bit odd but what i did was I went into File >> Export >> Create PDF/XPS. then i selected options (under neither the optimize options) and ticked the PDF/A complaint tick box. then closed all these windows. After that my code is now working and the barcodes are displaying on the PDF.

If anyone could tell my why this worked that would be helpful as i am not 100% sure why that worked?