保存excel文件没有提示 [英] Saving an excel file without prompt

问题描述

我正在尝试在后台打开并保存和excel文件，而无需用户参与。我已经打开了正确的excel页面并隐藏了它工作正常，但是当我尝试保存它时，我要么打开这个文件你就无法保存打开的文件或弹出一个保存框说重新命名文件。



我只是希望它保存，好像你只是点击保存没有询问覆盖等只是保存该死的东西！



提前干杯



Dan

Hi, I am trying to open and save and excel file in the background without the user being involved. I have opened the correct excel page and hidden it which works fine but when I attempt to save it I either get this file is open you can't save an open file or a save box pops up saying re-name the file.

I simply want it to save as if you just clicked save no asking about overwriting etc just save the damn thing!

Cheers in advance

Dan

推荐答案

找到它！对于任何想要它的人：

Found it! For anyone who would like it:

App.DisplayAlerts = false;
workbook.save();
workbook.Close();
App.DisplaAlerts = True;
App.Quit();

这篇关于保存excel文件没有提示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！