我想在 VBA 中創建一個宏以在特定位置制作 excel 檔案，但檔案名必須從 userform 提供。到目前為止，這是我的代碼：
Dim wbname, wbsheet, wblocat As String
Dim wbghkv As Double
wbname = devserv.wbnamebox 'name of workbbok from userform
wbsheet = devserv.wbsheetbox 'name of worksheet from userform
wbghkv = devserv.ghkvbox 'value of gerate hkv from userform
wblocat = "T:\nf\usefullstuff\excel" 'location of file folder
Workbooks.Add.SaveAs Filename:="wblocat \ wbname"
Workbooks(wbname).Activate
Worksheets.Add
Worksheets.Add.Name = wbsheet
但是我在Workbooks.Add.SaveAs.....之前我嘗試使用chdir函式之前出現錯誤，Workbooks.Add.SaveAs但檔案保存在 mydocuments 中。請你幫助我好嗎 ？
uj5u.com熱心網友回復：
您正在嘗試另存為文字 string "wblocat \ wbname"。
相反，嘗試Workbooks.Add.SaveAs Filename:=wblocat & "\" & wbname.
順便說一句，Dim wbname, wbsheet, wblocat As String宣告wbnameand wbsheetas Variant。如果您希望它們成為String，您將需要使用Dim wbname As String, wbsheet As String, wblocat As String.
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/443973.html
下一篇：通過Vba回圈保存Excel行