
用批處理怎么啟用Excel的插件呢請教一下各位,我Excel卡住就經常會被禁用DLL文件,我想快速解除禁用后再啟用這個插件,自己的電腦我就可以用批處理啟用,但是不知道怎么解除禁用,但是我換一臺電腦用的是就無效了,不知道是不是注冊列表不一樣。我需要在以上的版本都通用,就是不知道怎么改,請教一下各位。代碼如下:
nclick="copycode($('code0'));">復制代碼
- @echo off
- setlocal EnableExtensions EnableDelayedExpansion
- rem 檢測Excel安裝路徑
- for /f tokens=3 %%i in ('reg query HKEY_LOCAL_MACHINESOFTWAREMicrosoftOfficeClickToRunConfiguration /v ProductReleaseIDs') do (
- set version=%%i
- )
- if not defined version (
- echo Could not determine installed Excel version.
- pause
- exit /b 1
- )
- rem 檢測CE card文件夾路徑
- set ce_card_path=C:WindowsSysWOW64CE card
- if not exist %ce_card_path% (
- echo CE card folder not found.
- pause
- exit /b 1
- )
- rem 添加workbook32.dll
- set dll_path=%ce_card_path%workbook32.dll
- if exist %dll_path% (
- regsvr32 /s %dll_path%
- echo Successfully added workbook to Excel COM add-ins.
- ) else (
- echo %dll_path% not found.
- )
- rem 添加workbook64.dll
- set dll_path=%ce_card_path%workbook64.dll
- if exist %dll_path% (
- regsvr32 /s %dll_path%
- echo Successfully added workbook to Excel COM add-ins.
- ) else (
- echo %dll_path% not found.
- )
- rem 啟用workbook加載項
- set progid=workbook
- set version=%version:.=.%
- set reg_key=HKEY_CURRENT_USERSoftwareMicrosoftOffice%version%ExcelOptions
- reg add %reg_key% /v OPEN /t REG_SZ /d !%progid! /r /f >nul
- if errorlevel 1 (
- echo Failed to enable workbook COM add-in.
- ) else (
- echo Successfully enabled workbook COM add-in.
- )
- echo Done.
- pause

