【VB語言】EXCEL中VB宏的應用

---

文章目錄

• • @[TOC](文章目錄)
• 前言
• 一、EXCEL-VB
• • 1.實驗過程
  • 2.代碼
• 二、EXCEL-VB 生成.c.h文件
• • 1.實驗過程
  • 2.代碼
• 四、參考資料
• 總結

前言

1.WPS-VB擴展包

提示：以下是本篇文章正文內容，下面案例可供參考

一、EXCEL-VB

1.實驗過程

2.代碼

略

二、EXCEL-VB 生成.c.h文件

1.實驗過程

2.代碼

Private Sub CommandButton1_Click()
MsgBox ("hello")
End SubPrivate Sub Genertor_file_Click()Dim FilePath As StringDim FileContent As String' 設定文件路徑和名稱FilePath_C = "D:\TEST.c"FilePath_H = "D:\TEST.h"FilePath_txt = "D:\readme.txt"' 寫入文件Open FilePath_C For Output As #1Open FilePath_H For Output As #2Open FilePath_txt For Output As #3Print #1, "*/ "Print #1, "* File: TEST.c  "Print #1, "* Author: GDX  "Print #1, "* Date: 2024-11-21  "Print #1, "* Description: This is a main file of TEST.  "Print #1, "* Version: 1.0  "Print #1, "*/  "Print #1, "  "Print #1, "* Function: TEST   "Print #1, "* Description: TEST.c   "Print #1, "* Input: None   "Print #1, "* Output: None  "Print #1, "* Returns: None "Print #1, "*/ "Print #1, "  "Print #1, "* code comment */ "Print #1, "  "Print #1, "#include <stdio.h>"Print #1, "int main()"Print #1, "{"Print #1, "  " & "//代碼段"Print #1, "  " & "while(1);"Print #1, "}"Close #1Print #2, "#ifndef __TEST_H_"Print #2, "#define __TEST_H_"Print #2, "#endif"Close #2Print #3, "code log"Close #3MsgBox "C文件已成功生成!"
End Sub

四、參考資料

利用excel（vba）生成一個.c文件和.h文件
EXCEL-VBA書籍PDF版本
Microsoft Visual Basic for Applications 7.0 插件（vba7.0插件）
【辦公軟件】Excel中插入VBA宏處理
微軟的excel啟用宏，查看宏的vb腳本
excel無法在未啟用宏的工作簿中保存以下功能

總結

本文僅僅簡單介紹了【VB語言】EXCEL中VB宏的應用，評論區歡迎討論。