New answers tagged microsoft-excel-2007
0
votes
How to modify these VBA codes to save excel sheet in excel format (.xlsx)?
Correction to other answer there should be only one save location
Option Explicit
Sub Button1_Click()
'Sub PDFActiveSheet2()
Dim ws As Worksheet
Dim strFile As String
On Error GoTo errHandler
...
Top 50 recent answers are included
Related Tags
microsoft-excel-2007 × 2256microsoft-excel × 1616
worksheet-function × 786
microsoft-excel-2010 × 715
vba × 247
charts × 103
macros × 86
conditional-formatting × 59
pivot-table × 56
microsoft-office × 53
microsoft-excel-2013 × 52
formatting × 39
microsoft-excel-2016 × 34
csv × 28
windows-7 × 27
microsoft-excel-2003 × 25
spreadsheet × 24
windows × 20
microsoft-office-2007 × 20
sorting × 19
microsoft-word × 18
vlookup × 18
copy-paste × 17
data-validation × 17
keyboard-shortcuts × 13