登录
首页 » Others » 完全手册Excel VBA典型实例大全—通过368个例子掌握vba

完全手册Excel VBA典型实例大全—通过368个例子掌握vba

于 2020-12-07 发布
0 240
下载积分: 1 下载次数: 2

代码说明:

完全手册Excel VBA典型实例大全,通过368个例子掌握vba,收藏整理的教程,内容不是很全,但有借鉴意义。

下载说明:请别用迅雷下载,失败请重下,重下不扣分!

发表评论

0 个回复

  • C#WEB用户令牌TOKEN验证防止HTTPGETPOST等提交
    C#WEB用户令牌TOKEN验证,防止HTTP、GET、POST等提交包含服务端和客户端源码。Nginx集群,SSL证书的WebApi令牌验证
    2021-05-06下载
    积分:1
  • sigma-delta 入门推导
    讲述了sigma-delta调制器基本单元的原理,并进行了简单推导;
    2020-12-02下载
    积分:1
  • Introduction to Computational Plasticity (ISBN 0198568266), Fionn Dunne, Nik Petrinic.pdf
    书和abaqus中33个用户子程序提供大家参考
    2020-12-09下载
    积分:1
  • ST FOC 5.0说明书 快速入门 SDK v5.0.pdf
    ST FOC 5.0说明书 配合 开源库 https://download.csdn.net/download/hxinstar/10322042使用UM2374List of tablesList of tablesTable 1. List of acronymsTable 2Document revision history..23UM2374 Rey 13/24List of figuresUM2374List of figuresFigure 1. ST MC Workbench -Icon and installation folder treeFigure 2. ST MC Workbench-GUI expanded top viewFigure 3. ST Motor Profiler-GUI889Figure 5. ST Motor Profiler-SM-PMSM parameters exampleFigure 4. ST Motor Profiler- Hardware setup list examples1011Figure 6. ST Motor Profiler-l-PMSM parameters exampleFigure 7. ST Motor Profiler-Measurement results12Figure 8. ST Motor Profiler-Save window13Figure 9. ST MC Workbench - New Project window14Figure 10. ST MC Workbench -New Project Info window14Figure 11. ST MC Workbench -Project Settings15Figure 12. ST MC Workbench-Project Settings window.15Figure 13. ST MC Workbench -Project generation button16Figure 14. ST MC Workbench -Workspace selectionFigure 15. ST MC Workbench -Project generation build infoFigure19. ST MC Workbench- Use of the motor control and monitoring.∴、∴,"…,,∴…….17Figure 16. IDE-MC Project view example18Figure 17. STMC Workbench-Motor monitoring button.19Figure 18. ST MC Workbench -Motor monitoring GUI204/24UM2374 Rey 1/UM2374General informationGeneral informationThe Mc sDK is used for the development of motor-control applications running on STM3232-bit microcontrollers based on the arm Cortex-M processorTable 1 presents the definition of acronyms that are relevant for a better understanding ofthis documentTable 1. List of acronymsAcronymDescriptionGUIGraphical user interfaceIDEIntegrated development environmentFOCField-oriented controlFWFirmwareMotor controlMC WBMotor control Workbench(STMicroelectronics sw tool)MPMotor Profiler(STMicroelectronics software tool)PMSMPermanent-magnet synchronous motorPWMPulse-width modulationSDKSoftware development kitVCVector controlMore information about ST MC Workbench is provided in the stm32 motor control SDKv5.0toolsusermanual(um2380)availableatwww.st.comarmUM2374 Rey 15/24Motor control ecosystem setupUM23742Motor control ecosystem setupA suitable ST Motor Control ecosystem environment includesA PC running the needed Mc software toolsA third-party IDEa third-party ANSI C-compilerA JTAG/SWD interface for debugging and programmingAn STMicroelectronics application board with one of the STM32 microcontrollerssupported. It drives the power stage and featuresPWM outputs to gate driverADC channels to measure currentsDC bus voltageA three-phase PMsM motol· A power supplyRefer to the STM32 motor control software development kit(Mc sDk data brief(DB3548)atwww.st.comandtothereleasenoteformoredetails2.1Software tool setupThe STMicroelectronics motor-control ecosystem runs on a pc with Windows7The following Pc software tools are correctly installedST MC Workbench (v5.0.0 or later)STM32CubeMX(v4 24.0 or later)ST-LINK/2(v4.0.0 or later)Any supported IDEIAR Embedded Workbench@ for Arm(v7.80.4Keil MDK tools (v5.24.2 or later)Ac6 System Workbench(v2.3.0 or later)(a)Refer to the respective user manuals for proper installation. STMicroelectronics documentsareavailablefromtheinternetsiteatwwwst.comSTM32 motor control SDK v5.0 tools user manual (UM2380STM32 CubeMX for STM32 configuration and initialization c code generation usermanual (UM1718)STM32 ST-LINK utility software description user manual(UM0892)The AC6 tool framework is not supported in SDK v5.0 but in later versions6/24UM2374 Rey 1/UM2374Motor control ecosystem setup22Hardware setupThe connection of the STMicroelectronics application board to the pc requires a USBType-A connector. Refer to the description of the application board for details on the USBcableA dedicated description card is delivered with each STMicroelectronics application board forproper installation For more details, refer to the user manual of the board available atwww.st.comThe selected hardware can be one of the three setups· The complete MC KitOne of the complete inverter boardsAny STM32 evaluation board combined with one of the ST evaluation power stagesthat include the mc connectorUM2374 Rey 17/24Getting StartedUM23743Getting StartedWarning: Check that the board is correctly configured for the motorcontrol application and supplied with the expected inputvoltageNoteRefer to the user manual of the related hardware to setup the correct configuration, voltagerange, serial communication capabilities, and programming/debugging interface3.1Hardware connectionConnect a uSb cable between the pc and the stmicroelectronics application board andthe JTAG/SWD programming cable if it is different from the USB cable3.2Motor profilingLaunch the ST MC Workbench software tool either byclicking on its iconrunning it directly from the installation folder treeBoth ways of launching the ST MC Workbench are illustrated in Figure 1Figure 1. ST MC Workbench- Icon and installation folder treeI STMicroelectrorics感FOC SDKLv.3.0MotorControlv500WorkBenchST Motor Control Workbenchd ST Motor profileren the st motor profiler tool either byUsing its dedicated button in the St Mc Workbench GUl as illustrated in Figure 2Running it directly from the installation folder tree as illustrated in Figure 1Figure 2. ST MC Workbench-GUl expanded top viewFile Tools Help Documet ta ionNew ProjectLoad Project4 About HelpMotor ProfilRcGert ProJEcts己tdbrsDRpower board8/24UM2374 Rey 1/UM2374Getting StartedClick on the Select Boards button to display the list of supported boards as shown onFigure 3 and select the STMicroelectronics application board setup. Figure 4 on page 10presents examples from this listNoteThe ST Motor Profiler tool may be used only with ST hardware in the list of supportedsetups.Figure 3. ST Motor Profiler-GUI2 ST Motor Profile.l:e augmentedMotor ProfilersPole pairsPe row to detecbeed and Current /mitsMaκSpet1600FPMn7 Select Board∧pk02530pkMagnetic: SM-PMSN○-NSMMechanIcal mode lO CenElectrical modelOW000UM2374 Rey 19/24Getting StartedUM2374Figure 4. ST Motor Profiler-Hardware setup list examplesE ST Motor ProfiY Hideabsolete boarde arch Control board by narSe arch power boac bv nareControl boardower BoardxCancelHide boards with warningNUCLEO-F302R8X-NUCLEO-HMOTM1 3shNUCLEO-F302R8X-NUCLEO-HMOBM1 3shT2F302R8T6L6230PDSTM32F302R8T6STL22ON6FT●Acf8m:m3SELNRV2 Emiol connectorC Product Web PageG Product Web PageC Product Web PageC Product Web PageNUCLEO-F303RESTEVAL-IPMO5F 3ShNUCLEO.F303RESTEVAL-IPM108 3sh●Aiv命Ativ● Ac livSn Ngor ombreI connectorST-LINKV2C Product Web PageC Product Web PageC Product Web PageC Product Web PageClick on the sTmicroelectronics hardware setup to select it and configure the st motorProfiler toolAs an example, Figure 4 shows the selection of the P-NUCLEO-IHM001 motor controlNucleo pack with NucLEo-F302R8 and X-NUCLEO-IHMO7M1After hardware setup selection, fill in the parameter fields with the motor informationThe number of pole pairs of the motor(mandatory fieldThe Max Speed of the motor(optional field)by default, the st Motor Profiler tool searches for the maximum allowed speedmatching the motor and the hardware setup usedThe Max Current allowed by the motor(optional field)By default, it is the maximum peak current deliverable by the hardware setupThe nominal dC bus voltage used by the hardware setup(optional field)By default, it is the power supply stage as either the bus voltage for low voltageapplications(DC voltage), or the RMs value for high voltage application(Ac voltage)The magnetic built-in type(mandatory field)By default, the SM-PMSM is selectedThe Ld/Lq ratio(mandatory field only when l-PMSM built-in is selected as shown inFigure 6 on page 1110/24UM2374 Rey 1/
    2020-11-29下载
    积分:1
  • morlet小波matlab代码
    关于morlet小波的一个matlab代码,又注释,仅供参考
    2020-12-06下载
    积分:1
  • 基于MATLAB的MEMS表面形貌重构
    分析获取的干涉图,熟练掌握MATLAB的操作,了解还原表面形貌的基本算法,编写适合的算法仿真出微结构表面形貌。技术要求:(1)会分析所获取的微结构表面形貌干涉图;(2)熟练掌握MATLAB的操作;(3)熟悉处理干涉图的相应算法;(4)仿真出微结构的表面形貌。
    2020-12-03下载
    积分:1
  • 弹道导弹的弹道设计与仿真
    本文致力于弹道设计、编写弹道仿真软件能实现不同类型的导弹在不同的发射方式下,进行不同自由度的多段弹道全数字仿真。
    2021-05-06下载
    积分:1
  • Matlab_Simulink 三相桥式全控整流电路的建模与仿真
    Matlab_Simulink的三相桥式全控整流电路的建模与仿真仿真
    2020-12-05下载
    积分:1
  • CMP-MVS开源代码
    CMP-MVS 三维重建开源代码
    2021-05-06下载
    积分:1
  • C51超声波测距序-基于芯片CX20106A
    /* CX20106A 超声波发送与接受程序 40KHz脉冲由单AT89S52单片机P1.0口送出,由P3.2(INT0)采用中断方式接收。 定时器0,定时器1中断方式工作,T1为8位自动重装模式(定时12.5us),T0为16位定时器(定时约65ms) 超声波接受采用外部中断INT0,接受到返回脉冲后,在外部中断程序中计算距离。 65ms超声波传播距离约65×10^(-3) × 340m/s =22.1m,距离足够了,远超CX20106A的测量范围。 40KHz对应波周期T=1/40KHz =25us,方波高占空比50%,高低电平宽度分别占0.5T=12.5us。 定
    2020-12-11下载
    积分:1
  • 696518资源总数
  • 105604会员总数
  • 18今日下载