Want to enjoy the benefits of new Excel file format and having many files in old file format?
This video showing how you could get it done easily with VBA.
Download The File in This Video
#Exce #Excesifu #Macro
Download eBook: The 5 Magic to Master Business Data
👉
Connect to me in LinkedIn
Like our FB
Music: …(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
You could download the file of this video from
https://drive.google.com/file/d/1fkYXtudi4e1o2hLIXCCiYO3uJg7ZLiyR/view?usp=sharing
Thanks you so much… You are a life saver…. Wish you all the fortune in the world
Thanks for this file. Works great. Could you tell me what exactly I would need to change for xlsm format to xlsx. Would it be as simple as replacing xls with xlsm throughout the code?
Posisble to share the macro details for converting just 1 file from xls to xlsx
The missing part of the code.
Function BrowseOneFolder(Optional strInitialPath As String) As String
Dim objFileDialog As FileDialog
Dim sItem As String
Set objFileDialog = Application.FileDialog(msoFileDialogFolderPicker)
With objFileDialog
.Title = "Select a Folder"
.AllowMultiSelect = False
If strInitialPath > "" Then
.InitialFileName = strInitialPath
End If
If .Show = -1 Then
BrowseOneFolder = .SelectedItems(1)
End If
End With
Set objFileDialog = Nothing
End Function
HI SiFu, Please, how can we get the code? Thanks
Hello. Thanks for sharing. I get an issue. When I run your code, I got an error "Sub or Function not defined" and highlight the "BrowseOneFolder" in Main macro. Can you fix this?