+ Reply to Thread
Results 1 to 17 of 17

Changing the structure of the files

Hybrid View

  1. #1
    Registered User
    Join Date
    11-08-2014
    Location
    Malaysia
    MS-Off Ver
    2010
    Posts
    84

    Re: Changing the structure of the files

    Quote Originally Posted by Brendan_Floyde View Post
    Could you run it again and when it error hit debug
    then type ?strfilenamez
    This will then tell you the file it errors out on - could you then post that file? Or rerun excluding that file and see it it gets further? I want to work out if it is a particular file that is the issue
    I could't find a place to type the ?strfilenamez; because after that it highlights the error line. By the way, I skipped the file that the program stopped and run for the rest. The program works well. THANK YOU SO MUCH (I already clicked on *).
    However, this file starting with "?" missing values. Some of the files are like this and I will appreciate if you could solve this as well.
    I added this file to the original post as well (1534001.csv).
    Again thank you for the time.

  2. #2
    Forum Contributor
    Join Date
    01-14-2014
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    240

    Re: Changing the structure of the files

    Got the file - replicated the error....working on it. It is the problem I suspected....
    Last edited by Brendan_Floyde; 02-15-2015 at 04:03 PM.
    Please consider adding a * if I helped.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Changing structure of data
    By forrestgump1980 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-02-2014, 08:59 AM
  2. Replies: 4
    Last Post: 12-12-2013, 09:49 AM
  3. CHeck boxes structure is changing when grouped into rows
    By kammariarun in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-01-2013, 07:56 PM
  4. Cell style - changing ribbon structure
    By zlodiej in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-01-2013, 02:17 PM
  5. Open files within specific file structure
    By GregR in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-18-2005, 03:05 PM

Tags for this Thread

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