About 1,781,932 results (3,594 milliseconds)
ActiveWorkbook.SaveAs FileName:= ....variableName
https://groups.google.com/g/microsoft.public.mac.office.excel/c/jseeYxPnptM 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 ... I first got Excel 98.
Why this excel sheet is not working when I upload it to google sheets ...
https://support.google.com/docs/thread/2425399/why-this-excel-sheet-is-not-working-when-i-upload-it-to-google-sheets?hl=en Mar 14, 2019 ... Excel : Formulas -> Name Manager. May be it is wrong assumption ... To extract vba file from you excel file it is a task, if you cant ...
Create Global Variable in Google Apps Script - Google Docs Editors ...
https://support.google.com/docs/thread/69070626/create-global-variable-in-google-apps-script?hl=en Sep 4, 2020 ... Sheet names in the function will be static. There will be multiple functions that will use the same Id's so I was hoping to find a way to ...
Export Data to Sheets in Excel
https://groups.google.com/g/comp.databases.pick/c/96TMadT4JKU > How can I name the sheets ? Sheets("SheetName").Name = "Literal"/Variable ... name the file with a ".xls" extension. Open with excel, change column widths ...
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 ... Workbooks.Open Filename:=pfad_stzh 'variable wird im autoopen modul 5
Executing MS Excel through MS Access vba
https://groups.google.com/g/microsoft.public.access.formscoding/c/UWZ25GQ4IYs Dim xlBook As Object 'Workbook Object Dim xlSheet As Object 'Worksheet Object Dim varGetFileName As Variant 'File Name with Full Path Dim rstSCCB As ...
CLEAN function - macro??
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/jsHw9KXMKuU This opens the VBA editor. Note the "Project" browser is on the left (unless you have already rearranged things), with your current workbook name highlighted.
Inserting a row into excel file
https://groups.google.com/g/python-excel/c/OIS2_F5EDR4 You can modify xls files. It fully supports everything. Its very simple, the Excel COM API was designed for VBA coders, so we're really talking lowest common ...
ExcelDNA / Excel / Other libraries = crash on exiting
https://groups.google.com/g/exceldna/c/WI57wbzWSec Nov 1, 2011 ... The first version only uses VBA (Actual Excel functions comes in next ... object in the static variable (and returns Application.Name.Length), ...
Two-way syncing of data between sheets so changes can be made ...
https://support.google.com/docs/thread/3961222/two-way-syncing-of-data-between-sheets-so-changes-can-be-made-on-either?hl=en Apr 10, 2019 ... ... sheet name and which is the program itself. Can you explain what that would look like if my master sheet name is "report" and the other is ...
Help with For Loop to use getValues and getFormulas depending on ...
https://support.google.com/docs/thread/9380885/help-with-for-loop-to-use-getvalues-and-getformulas-depending-on-cell-contents?hl=en Jul 7, 2019 ... openById(file.getId()); var sourcesheet = SpreadsheetApp.getActive().getSheetByName("SHEET NAME"); var sourcerange = sourcesheet.getRange ...
Find the last filled row in Excel using Revit Python Shell
https://groups.google.com/g/revitpythonshell/c/Kj0CLM6wAXs Jun 30, 2020 ... In my example, ws is the worksheet - my variable names were not very clear! I'm getting the sheet object from the workbook using its name as a ...
Export large access table to excel in multiple worksheets
https://groups.google.com/g/comp.databases.ms-access/c/xvOfpAVgcm0 @yahoo.com (Martin Hanna) wrote: In principle what you need to do is create a parameter query which selects the records you want based on a variable week/year ...
excel - Setting a range from a workbook VBA - Stack Overflow
http://feedproxy.google.com/~r/stackoverflow/tGpU/~3/CMpXwZatnNM/setting-a-range-from-a-workbook-vba Jul 23, 2021 ... @NickChristensen Most likely problem is the spelling of the workbook name. ... Set a range using variables in Excel vba · Hot Network Questions.
Listing all worksheets in a workbook
https://groups.google.com/g/exceldna/c/mqBmbKNJ5Lo VBA, and the default object when resolving a token like ThisWorkbook). From a macro in Excel-DNA, you get hold of the right Application ... a) the name of the ...
How can I design the code in VBA in order to refer to a previously ...
http://feedproxy.google.com/~r/stackoverflow/JqJq/~3/EoQDwLNa39E/how-can-i-design-the-code-in-vba-in-order-to-refer-to-a-previously-already-newly?utm_source=feedburner&utm_medium=email Jun 12, 2021 ... How to create and name an Excel Sheet referencing a cell in the workbook ... Referring to a new worksheet with variable name · 2 · How to ...
Unable to access DNA-Excel library in VBA code
https://groups.google.com/g/exceldna/c/jeCLtZYPlao Jul 12, 2016 ... It is the XLL file, which even though accessible to the spreadsheet, cannot be referenced in a VBA variable, for some reason. Govert van ...
Exception from HRESULT: 0x800A03EC when writing UDF output to ...
https://groups.google.com/g/exceldna/c/S8fNodKiSiU I have the function code below wrap in my MyFunction class. [ExcelFunction()] public void WriteFuncOutToCell(string name) { Microsoft.Office.Interop.Excel.
Importing Value from Excel instead of a formula
https://groups.google.com/g/mercuryqtp/c/pL_6oyufO5E Jan 13, 2014 ... The data I use for my scripts are stored in Excel workbook that we import in QTP. ... Variable name = oWorksheet.cells(row number,column number).
Save and Restore AutoFilter
https://groups.google.com/g/exceldna/c/P4czzE9x6rA Jun 4, 2012 ... equivalently from VBA, VSTO or Excel-DNA. On top of that, Excel ... <Reference Name="Microsoft.Office.Interop.Excel" /> <![CDATA[ using ...