Recent content by wayne123

  1. W

    Progress Bar

    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...
  2. W

    Progress Bar

    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...
  3. W

    Converting all .txt to excel in a given folder.

    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
  4. W

    Converting all .txt to excel in a given folder.

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

    Converting all .txt to excel in a given folder.

    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...
  6. W

    Converting all .txt to excel in a given folder.

    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.
  7. W

    Converting all .txt to excel in a given folder.

    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...
Top Bottom