Search results

Hi, Thanks for the reply. I can't seem to add this into the code? Here's the full Code: Public Sub Convert_TXT_XLS() Dim sFolder As String Dim fd As FileDialog Dim strFile As String Dim booResult As Boolean 'Progress Bar Dim CurrentProgress As Double Dim...

Good Morning All, I have a "Simple" problem that I'm struggling to solve. My code loops through multiple txt files in a specific fold and converts them to excel files. I'm developing a piece of code to show the user the Progress of conversion of each file. What do I need to change to make it...

Sorry to be a nuisance, but can someone give me a piece of code that uses the file name has the chart title? Much appreciated

All works perfect > Thanks for your support. Much Appreciated :)

Appreciated that. Maybe I'm missing something very simple. I've made the following modifications to the code: Dim sPath As String, sDir As String sPath = Application.FileDialog(msoFileDialogFolderPicker) With Application.FileDialog(msoFileDialogFolderPicker) 'Makes...

Thanks for your replies. All scripts are using file paths location. I need to use Folder Picker of some sort. This will all the user to select they own data location.

Hello All, Can you help me solve the following problem. I want to change a piece of code in the below VBA which converts .txt to excel file, but I want the code to do all files in the folder. Instead of selecting individual files. I've tried the obvious of change FilePicker to...