+ Reply to Thread
Results 1 to 2 of 2

subroutine modification and testing

Hybrid View

  1. #1
    Registered User
    Join Date
    06-21-2007
    Location
    Vancouver, Canada
    Posts
    74

    subroutine modification and testing

    I'm trying to modify one of the subroutines that is used to decipher a particular type of csv file out of an entire project of vba macro subroutines. I may be a bit vague here, but I'm not too sure how to test my modified subroutine while keeping the rest of the project's codes relatively intact as the code that I'm working on involves instantiating a class object defined in the original class module code in the project. Should I be coding the subroutine that reads the csv file independently on a separate excel workbook macro?

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259
    Hello Stanigator,

    That's a good strategy. Isolate and build the code to read the CSV file first. Once you know this works correctly, you can move on to the next step of integration. Isolate and test each part if you can. Makes troubleshooting much easier.

    Sincerely,
    Leith Ross

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1