Consulting

Results 1 to 9 of 9

Thread: Testing help wanted!

  1. #1
    Knowledge Base Approver
    The King of Overkill!
    VBAX Master
    Joined
    Jul 2004
    Location
    Rochester, NY
    Posts
    1,727
    Location

    Testing help wanted!

    Hi Everyone,

    Attached is an add-in I made for exporting to text files. Testing/Finding Errors/Suggestions much appreciated!

    Thanks!!
    Matt
    Last edited by mvidas; 08-17-2004 at 11:54 AM. Reason: Removed attachment, added to later post

  2. #2
    Knowledge Base Approver
    The King of Overkill! VBAX Master
    Joined
    Jul 2004
    Location
    Rochester, NY
    Posts
    1,727
    Location
    Also, if something doesn't look right or is mispelled or anything else (even minor), please let me know as well

  3. #3
    VBAX Regular
    Joined
    Jun 2004
    Location
    USA
    Posts
    10
    Hi Matt,
    Just a quick note: if there is no active workbook, the following line fails:

    Private Sub UserForm_Activate()
          If Left(Right(ActiveWorkbook.Name, 4), 1) = "." Then
    You could check for 'ActiveWorkbook Is Nothing' before that line.
    I haven't had time try the tool yet.

    Regards,
    S?bastien
    Seb

  4. #4
    Knowledge Base Approver
    The King of Overkill! VBAX Master
    Joined
    Jul 2004
    Location
    Rochester, NY
    Posts
    1,727
    Location
    Good point... consider it fixed, thanks!

  5. #5
    Knowledge Base Approver
    The King of Overkill! VBAX Master
    Joined
    Jul 2004
    Location
    Rochester, NY
    Posts
    1,727
    Location
    By the way, I'm using excel 2000 sr1, if anyone gets any errors please let me know what version you're using

    On top of the no-activeworkbook thing Seb mentioned, I also fixed the msgbox text for when no delimiter is entered and fixed width is not checked (was missing a space).

    Anyone know offhand how to make it so the escape key hides the userform?

  6. #6
    VBAX Regular
    Joined
    Jun 2004
    Location
    USA
    Posts
    10
    There is no direct ESC for the Userform. The way it works is that you set the Cancel's button property called Cancel to True. That is, pressing ESC triggers the cancel_Click and runs that code.

    Regards,
    Seb

  7. #7
    Knowledge Base Approver
    The King of Overkill! VBAX Master
    Joined
    Jul 2004
    Location
    Rochester, NY
    Posts
    1,727
    Location
    Perfect!

    Revised add-in attached

    Thanks Seb!
    Last edited by mvidas; 08-18-2004 at 06:32 AM. Reason: Removed attachment, added to later post

  8. #8
    Knowledge Base Approver
    The King of Overkill! VBAX Master
    Joined
    Jul 2004
    Location
    Rochester, NY
    Posts
    1,727
    Location
    quick update, fixed an error in ExportButton_Click sub, changed ActiveSheet.Close to ActiveWorkbook.Close (for fixed width exports)

  9. #9
    Knowledge Base Approver
    The King of Overkill! VBAX Master
    Joined
    Jul 2004
    Location
    Rochester, NY
    Posts
    1,727
    Location
    I have made a few minor aesthetic changes, as well as an added functionality for the fixed width exports. Most recent version attached. All comments are appreciated!
    Thanks
    Matt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •