Show AllReloads a workbook based on an HTML document, using the specified document encoding.
expression.ReloadAs(Encoding)
expression Required. An expression that returns one of the objects in the Applies To list.
Encoding Required MsoEncoding. The encoding that is to be applied to the workbook.
| MsoEncoding can be one of these MsoEncoding constants. |
| msoEncodingEBCDICArabic |
| msoEncodingArabic |
| msoEncodingArabicASMO |
| msoEncodingArabicAutoDetect |
| msoEncodingArabicTransparentASMO |
| msoEncodingAutoDetect |
| msoEncodingBaltic |
| msoEncodingCentralEuropean |
| msoEncodingCyrillic |
| msoEncodingCyrillicAutoDetect |
| msoEncodingEBCDICDenmarkNorway |
| msoEncodingEBCDICFinlandSweden |
| msoEncodingEBCDICFrance |
| msoEncodingEBCDICGermany |
| msoEncodingEBCDICGreek |
| msoEncodingEBCDICGreekModern |
| msoEncodingEBCDICHebrew |
| msoEncodingEBCDICIcelandic |
| msoEncodingEBCDICInternational |
| msoEncodingEBCDICItaly |
| msoEncodingEBCDICJapaneseKatakanaExtended |
| msoEncodingEBCDICJapaneseKatakanaExtendedAndJapanese |
| msoEncodingEBCDICJapaneseLatinExtendedAndJapanese |
| msoEncodingEBCDICKoreanExtended |
| msoEncodingEBCDICKoreanExtendedAndKorean |
| msoEncodingEBCDICLatinAmericaSpain |
| msoEncodingEBCDICMultilingualROECELatin2 |
| msoEncodingEBCDICRussian |
| msoEncodingEBCDICSerbianBulgarian |
| msoEncodingEBCDICSimplifiedChineseExtendedAndSimplifiedChinese |
| msoEncodingEBCDICThai |
| msoEncodingEBCDICTurkish |
| msoEncodingEBCDICTurkishLatin5 |
| msoEncodingEBCDICUnitedKingdom |
| msoEncodingEBCDICUSCanada |
| msoEncodingEBCDICUSCanadaAndJapanese |
| msoEncodingEBCDICUSCanadaAndTraditionalChinese |
| msoEncodingEUCChineseSimplifiedChinese |
| msoEncodingEUCJapanese |
| msoEncodingEUCKorean |
| msoEncodingEUCTaiwaneseTraditionalChinese |
| msoEncodingEuropa3 |
| msoEncodingExtAlphaLowercase |
| msoEncodingGreek |
| msoEncodingGreekAutoDetect |
| msoEncodingHebrew |
| msoEncodingHZGBSimplifiedChinese |
| msoEncodingIA5German |
| msoEncodingIA5IRV |
| msoEncodingIA5Norwegian |
| msoEncodingIA5Swedish |
| msoEncodingISO2022CNSimplifiedChinese |
| msoEncodingISO2022CNTraditionalChinese |
| msoEncodingISO2022JPJISX02011989 |
| msoEncodingISO2022JPJISX02021984 |
| msoEncodingISO2022JPNoHalfwidthKatakana |
| msoEncodingISO2022KR |
| msoEncodingISO6937NonSpacingAccent |
| msoEncodingISO885915Latin9 |
| msoEncodingISO88591Latin1 |
| msoEncodingISO88592CentralEurope |
| msoEncodingISO88593Latin3 |
| msoEncodingISO88594Baltic |
| msoEncodingISO88595Cyrillic |
| msoEncodingISO88596Arabic |
| msoEncodingISO88597Greek |
| msoEncodingISO88598Hebrew |
| msoEncodingISO88599Turkish |
| msoEncodingJapaneseAutoDetect |
| msoEncodingJapaneseShiftJIS |
| msoEncodingKOI8R |
| msoEncodingKOI8U |
| msoEncodingKorean |
| msoEncodingKoreanAutoDetect |
| msoEncodingKoreanJohab |
| msoEncodingMacArabic |
| msoEncodingMacCroatia |
| msoEncodingMacCyrillic |
| msoEncodingMacGreek1 |
| msoEncodingMacHebrew |
| msoEncodingMacIcelandic |
| msoEncodingMacJapanese |
| msoEncodingMacKorean |
| msoEncodingMacLatin2 |
| msoEncodingMacRoman |
| msoEncodingMacRomania |
| msoEncodingMacSimplifiedChineseGB2312 |
| msoEncodingMacTraditionalChineseBig5 |
| msoEncodingMacTurkish |
| msoEncodingMacUkraine |
| msoEncodingOEMArabic |
| msoEncodingOEMBaltic |
| msoEncodingOEMCanadianFrench |
| msoEncodingOEMCyrillic |
| msoEncodingOEMCyrillicII |
| msoEncodingOEMGreek437G |
| msoEncodingOEMHebrew |
| msoEncodingOEMIcelandic |
| msoEncodingOEMModernGreek |
| msoEncodingOEMMultilingualLatinI |
| msoEncodingOEMMultilingualLatinII |
| msoEncodingOEMNordic |
| msoEncodingOEMPortuguese |
| msoEncodingOEMTurkish |
| msoEncodingOEMUnitedStates |
| msoEncodingSimplifiedChineseAutoDetect |
| msoEncodingSimplifiedChineseGBK |
| msoEncodingT61 |
| msoEncodingTaiwanCNS |
| msoEncodingTaiwanEten |
| msoEncodingTaiwanIBM5550 |
| msoEncodingTaiwanTCA |
| msoEncodingTaiwanTeleText |
| msoEncodingTaiwanWang |
| msoEncodingThai |
| msoEncodingTraditionalChineseAutoDetect |
| msoEncodingTraditionalChineseBig5 |
| msoEncodingTurkish |
| msoEncodingUnicodeBigEndian |
| msoEncodingUnicodeLittleEndian |
| msoEncodingUSASCII |
| msoEncodingUTF7 |
| msoEncodingUTF8 |
| msoEncodingVietnamese |
| msoEncodingWestern |
Only msoEncoding constants that are applicable to HTML work with the ReloadAs method.
This example reloads the first workbook, using Western document encoding.
Workbooks(1).ReloadAs Encoding:=msoEncodingWestern