如何使用“保存工作簿"并添加新工作表? [英] how to use A Save Workbook and add new sheet?

问题描述

首先，请原谅我SAKryukov，
在您的邮件从收件箱中弹出之前，我删除了我无法理解的Excel公式"线程，就像这样说，
=''IE-YTD''！D92，-IE-YTD是工作表的名称，D92是行/列.

对不起，SA.

现在的问题是如何打开保存工作簿并添加新工作表并在自动化中使用该工作表?

Hi,

First, forgive me SAKryukov,
I deleted the thread "Excel Formulas I could not Understand" before your message popped from my inbox, and just like what so said,
=''IE-YTD''!D92, - IE-YTD is the sheet''s name and D92 was the row/column.

Sorry bout that SA.

My question now is How can I opened a save workbook and add new sheet and use that sheet in my Automation?

推荐答案

'open existing workbook
xlWbk = ExcApp.Workbooks.Open(sFileName)
'add new worksheet
xlWsh = xlWbk.Worksheets.Add()

这篇关于如何使用“保存工作簿"并添加新工作表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！