About 1,049,536 results (1,056 milliseconds)
Problem with VBA in Excel X on Mac OS x
https://groups.google.com/g/microsoft.public.mac.office.excel/c/zEnjTazqn_o Jan 7, 2003 ... without saving anything, my VBA-Script should close the newly build file, ... always produces an error on the line 'ActiveWorkbook.Close' on os x.
Close Excel without being prompted to save
https://groups.google.com/g/microsoft.public.scripting.vbscript/c/hOGsNTvg3sA Mar 20, 2001 ... I am using VBScript to open an Excel workbook, print it and close Excel. But when Excel closes it always asks if I want to save changes.
Wait for an Excel Macro to Finish Before Continuing
https://groups.google.com/g/microsoft.public.scripting.vbscript/c/ncCojYsfhoU Apr 28, 2011 ... > >> > ' exapp.activeworkbook.save ... > Remove of comment this one above too. > > exapp.activeworkbook.close true > exapp.quit > set exapp = ...
Phantom External File Links, how can I break them?
https://groups.google.com/g/microsoft.public.mac.office.excel/c/hBVji035hqo closed the workbook without saving it and re-opend it. This time I went to ... it to be sure. So that's what worked for me. It seems that an Excel workbook can ...
objExcel.ActiveWorkbook.SaveAs
https://groups.google.com/g/microsoft.public.scripting.vbscript/c/89WaWrco0WM in excel. - then just save as: an xls file. I don't have any code for you, but you can "roll-yer- ...
Re: [wxPython-users] wxPython & COM server
https://groups.google.com/g/wxpython-users/c/wumHB0CzvY8 ... Microsoft Excel saves the file in the current folder. FileFormat Optional ... (VBA) (which is typically US English unless the VBA project where Workbooks.
VBscript / Excel SaveAs question
https://groups.google.com/g/microsoft.public.scripting.vbscript/c/olu29ZJUCTs Mar 25, 2002 ... xls file and save as a .prn textfile in VBScript? (see code example below) ' (I'm currently invoking an Excel macro from a VBS script as a ...
Threading errors when retrieving ActiveWorkbook ...
https://groups.google.com/g/exceldna/c/Cro350IrNrg Jun 29, 2017 ... If I save the workbook and open it an exception is thrown on. public ... using Microsoft.Office.Interop.Excel;. using IRibbonControl ...
ActiveWorkbook.SaveAs FileName:= ....variableName
https://groups.google.com/g/microsoft.public.mac.office.excel/c/jseeYxPnptM Close search. Main menu ... I would like to save a workbook with the File Name variableName.xls, but haven't had any luck. The following VBA macro, which is
Save as pdf Microsoft Excel from Matlab
https://groups.google.com/g/comp.soft-sys.matlab/c/Sxq2Y9gSnfo sPDFPath = ActiveWorkbook.Path & Application.PathSeparator 'Check if worksheet is empty and exit if so. If IsEmpty(ActiveSheet.UsedRange) Then Exit Sub Set ...
Excel VBA to ExcelDNA?
https://groups.google.com/g/exceldna/c/Uig6XVD9BZg Jul 6, 2021 ... ... active workbook. If that's awkward because the locations change, then write a Save macro to search for all cells containing the UDF and ...
Excel crashing randomly
https://groups.google.com/g/microsoft.public.mac.office.excel/c/j_Dgl_aq25I I guess Excel has been storing recovered versions of the document so that I can recover my saved data after the crash... The problem is that the workbook itself ...
RE: Cursor to upper left of frozen cells (in macro)
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/GgjHirD_bxM this macro before saving and closing a workbook so that when it is opened ... For Each wk In ActiveWorkbook.Worksheets >>>>>>>> wk.Activate >>>>>>>> Range ...
I need a script to clear certain cells in sheets when a button is ...
https://support.google.com/docs/thread/5809954/i-need-a-script-to-clear-certain-cells-in-sheets-when-a-button-is-pressed?hl=en May 9, 2019 ... I simply clicked record macro and then manually cleared out the cells I wanted to delete and then saved. Once I saved I then drew a crude button ...
Volatile function + XlCall.Excel(XlCall.xlfVolatile, false) = always non ...
https://groups.google.com/g/exceldna/c/7hkXd7Ax8oM Dec 16, 2016 ... ... without dealing with the new workbook being opened explicitly in an event or something. Once you've made the function not-volatile and saved ...
Different password for different worksheet
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/c_-kGU3JQTQ however, is that your users will forget to re-protect the worksheet before saving & closing the workbook. ... Here I am facing an error without saving anything.
Generating kml files from excel data
https://groups.google.com/g/kml-support-getting-started/c/TJa5caymWm8 Then you copy the sheet to a new workbook and save this new document with ... ActiveWorkbook.Close (False) end sub. Regards. KaMeLwriter's profile photo ...
Formulas skipping rows when new data is entered in another sheet ...
https://support.google.com/docs/thread/49936689/formulas-skipping-rows-when-new-data-is-entered-in-another-sheet?hl=en May 29, 2020 ... The first 2 sheets in my workbook have rows of values added to them regularly. One outside program adds rows to sheet 1 and another outside ...
Re: Timed call by Timer or OnTime, EXCEL keeps using more ...
https://groups.google.com/g/exceldna/c/oahQNZtjFOU access - ActiveWorkbook, .Worksheet, .Cells Range, .Cells(1,1) Range). Don't try to release the ExcelDna.Application reference. * Some internal Excel structures ...
CSV to XLS
https://groups.google.com/g/harbour-users/c/vsOBGfZkFBY/m/OtpJ4XoVBgAJ Do you think it would be best to copy the txt to a new workbook and save as normal? ... Do you get an RTE and a red box on screen? Or does it just quit without ...