By using expertatexcel.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

Become an Σxpert at Σxcel.com

 


Standard VBA/Excel (40 of 1182)

(Clear Filter = *workbook*)

Compress Large Excel Workbooks
Workbooks.Open
ActiveWorkbook after opening an excel file
Thisworkbook (xl reserved word)
Activeworkbook.name
Workbooks(thisworkbook.name).sheets("xxxx").Range("DER_cc") ' get the range name in another workbook
ThisWorkbook.Sheets(....).Range(....) ' use when a different sheet is active
ActiveWorkbook.Close False
GettheVersion - opens workbook and finds the version and date by searching the sheet
ActiveWorkbook.SaveAs sFile
ActiveWorkbook.Worksheets("....").Autofilter.sort.sortfileds.clear ' clears a filters sorting ' recorded
ThisWorkbook.Activate
ActiveWorkbook.Save
Open two workbooks and apply adjustments from one workbook to the other
WorkBooks.Open sFileout, UpdateLinks:=False
ActiveWorkbook.FullName
ActiveWorkbook.SaveCopyAs sFile
Thisworkbook.path
LoadArray(workbookname, Sheetname, header) 🔝
Run "Thisworkbook.WorkBook_Open"
Workbooks(sWB).Close False
ActiveWorkbook.RefreshAll
ActiveSheet.Copy After:=Workbooks(sMainWBK).Sheets(Sheets.count)
ActiveWorkbook.Names("dataset").RefersToR1C1 = "=cpt_input_data!R1C1:R40C13"
Workbooks(sWBK).Sheets("CPR_LIst").Range("portfolio")
set wb = ActiveWorkbook
ActiveWorkbook.worksheets("sfile1").sort.sortfields.Add Key:=Range("N2"), SortOn:=xlSortOnValues, order:=xlAscending, DataOption=xlSortTextAsNumbers
Workbook_open - event
Workbook_close - event
Get ini file - gsINIFile = Left(ThisWorkbook.Name, Len(ThisWorkbook.Name) - 4) & ".ini"
WorkBook
Workbooks Collection
ThisWorkbook
Using Multiple Workbooks
This Workbook contains links to one or more external sources [update] [don't update]
Hidden Workbook
ActiveWindow.DisplayWorkbookTabs = True
We can't update some of the links in your workbook right now ... [continue] [Edit Links...] dialog
FindWorkbook(sWB) udf
OpenExcelWorkbook(sFile)