Home/Tag: Workbook

VBA Open File DialogBox – Excel Macros Example Code

VBA Open File Dialog Box helps to browse a file and open Excel Workbook. Users can choose file by clicking on the button to open an Excel File with specific filter, title. VBA Code to Open an Excel File using File Dialog Box We can open the Excel files using File dialog box using Application.GetOpenFilename

By |April 22nd, 2014|VBA|10 Comments

VBA Save Sheet as Workbook Excel Macro Code

VBA code to save sheet as Workbook example code will help us to save a specific sheet as new workbook. We can use Copy and SaveAs methods of Workbook to copy and save the sheet into new workbook. In this example we will see how to save Active Sheet and specific worksheet as new excel

By |April 22nd, 2014|VBA|35 Comments

VBA Save Excel File Example Macro Code

VBA code to save the excel file example code will help us to save the excel file. We can use Save method of Workbook to save the file. In this example we will see how to save the current Excel file using VBA. And this code should work for all the version of Microsoft Excel

By |April 22nd, 2014|VBA|0 Comments

VBA Close Excel File – Workbook Example Code

VBA code to close the excel file example will help us to close the excel file. We can use Close method of Workbook to close the file. In this example we will see how to close the Active Excel Workbook using VBA. VBA code for closing Active Workbook macro should work for all the version

By |April 22nd, 2014|VBA|2 Comments

Related pages

excel merge columnsadodb connection examplekeystrokes in exceldeleting duplicates excelexcel vba close formvba examplehlookup formula with exampleexcel vba operatorsexcel what if statementsvba outlook folderformula for duplicates in excelbasic excel for beginnersproject timeline powerpoint template freeindirect function in vbaadd developer tab to excel 2007excel formula cell colourvba formmicrosoft excel nested ifvba excel userformexcel programingrecordset vba excelindex formula excel 2007opening xlsx files in excel 2003what is a logical function in excelddl tutorialloop function in exceltotal no of rows and columns in excelvba interview questions and answersvba error messageexcel vba programming for dummies free downloadvba close workbookexcel macro delete rowshow to unhide worksheetvba activecellcommand button code in excelvba clearhow to use lookup function in excel 2010interview questions for beginnersvlookup conditional formattinghow to build a pivot table in excel 2007paste special values macrovba language referencevba colour indexvba application.getopenfilenameproject management timeline excelxls vlookup exampleexcel vba delete entire rowvba connect to sqlwriting vba code in excelto merge cells in excelvbscript to delete filesbusiness analyst interview questions and answers for experiencedhide rows in excelaccess vba formathow to deduplicate in excelcopy sheet to another sheet vbavbscript listboxexcel graphs tutorialmicrosoft excel 2010 pivot table tutorialvba save as csvexcel 2013 comboboxexcel 2013 remove password protectionactivecell interior colorindexpopulate combobox vbadatevalue in excelexcel shortcut keys 2007vba excel iferrorhow to create bar chart in excel 2007remove hyperlinks excel 2007vbscript check if file existsexplain vlookup in excelvba application functionwhat is vlookupsdelete a row in excel vbahow to write macros in excel 2007vba code to unprotect workbookhow to search for blank cells in excel