• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. R

    VBA Code to Extract Specific Data from .txt File into Excel

    See if this macro does what you want (it writes to the active sheet which is assumed to be empty)... Private Sub CommandButton1_Click() Dim X As Long, Rw As Long, FileNum As Long, TotalFile As String, Desc() As String, Txt() As String FileNum = FreeFile Open "C:\dump2.txt" For Binary As...
  2. R

    preventing overlapping date ranges

    For all who are reading this thread... xlfan posted this same question over in The Code Cage forum where I responded with a VB coded solution that xlfan indicated he was going to use. I thought it would be useful to post a link to that solution for those who might be interested. There are 3...
Back
Top