sunsuper.blogg.se

1. CAN I DO A WATERFALL CHART IN OFFICE FOR MAC 2011 PDF
2. CAN I DO A WATERFALL CHART IN OFFICE FOR MAC 2011 FULL
3. CAN I DO A WATERFALL CHART IN OFFICE FOR MAC 2011 CODE
4. CAN I DO A WATERFALL CHART IN OFFICE FOR MAC 2011 WINDOWS

Partial (51): Afrikaans, Albanian, Amharic, Armenian, Assamese, Azerbaijani (Latin), Bangla (Bangladesh), Bangla (Bengali India), Basque (Basque), Belarusian, Bosnian (Latin), Catalan, Dari, Filipino, Galician, Georgian, Gujarati, Icelandic, Irish, Kannada, Khmer, KiSwahili, Konkani, Kyrgyz, Luxembourgish, Macedonian (FYRO Macedonia ), Malayalam, Maltese, Maori, Marathi, Mongolian (Cyrillic), Nepali, Norwedian Nynorsk, Odia, Persian (Farsi), Punjabi (Gurmukhi), Quechua, Scottish Gaelic, Serbian (Cyrillic, Bosnia & Herzegovina), Serbian (Cyrillic, Serbia), Sindhi (Arabic), Sinhala, Tamil, Tatar (Cyrillic), Telugu, Turkmen (Latin), Urdu, Uyghur, Uzbek (Latin), Valencian, Welsh.

CAN I DO A WATERFALL CHART IN OFFICE FOR MAC 2011 FULL

CAN I DO A WATERFALL CHART IN OFFICE FOR MAC 2011 PDF

Honestly, the user doesn't have to create their own file name, but what I do need and hope to achieve is only the range specified is exported to a PDF and it is landscape with the narrow margins (otherwise the tables won't fit).įilesavename = Range("A2").Value & "_" & "Overview"ĪctiveSheet. So it would be 2018 overview or 2019 overview, and that is perfectly fine.

CAN I DO A WATERFALL CHART IN OFFICE FOR MAC 2011 CODE

If this isn't possible on a Mac, is there at least Mac friendly code that would print the correct range to a PDF file with a set name. #End IfBut I am not sure I understand the whole fName, 4 bit-what it is doing. Worksheets(myName).SaveAs FileName:=fName, FileFormat:=xlpdf If (Right(fName, 4) = ".xls") Or (Right(fName, 4) = ".xlt") Then

' if there's ".xls" or ".xlt" at the end of the name, remove it I want the user to be able to name it what they want and put it where they want.īut I am new to VBA and might be understanding the code found on the page I put earlier. With Ron's code, it is making the filename a certain string, and then just telling the user "ok here is what I called the file, and here is where it is found," which is odd to me.

CAN I DO A WATERFALL CHART IN OFFICE FOR MAC 2011 WINDOWS

I would like the code to prompt the user to enter in the file name as it does for Windows.įor Windows when I run my above posted code, it sets the print area, changes the orientation to landscape and the margins to narrow, then it prompts the user to save the file with whatever name they want to give it and they can navigate to whatever folder they want to put it in, and then it creates the PDF and opens it right away. However, if I am understanding the code correctly, the user isn't creating the filename it is a fixed file name with the string. This is the Ron de Bruin page that seemingly addresses my issue.

, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _ FooterMargin = Application.InchesToPoints(0.3)ĪctiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=FName _ HeaderMargin = Application.InchesToPoints(0.3) BottomMargin = Application.InchesToPoints(0.75) TopMargin = Application.InchesToPoints(0.75) RightMargin = Application.InchesToPoints(0.25) LeftMargin = Application.InchesToPoints(0.25)