+ Reply to Thread
Results 1 to 2 of 2

opentext, array parameter

  1. #1
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Budapest, Hungary
    MS-Off Ver
    Excel 2016
    Posts
    187

    opentext, array parameter

    I would like to create a macro,which imports a txt file and saves it as xlsx.
    I used the macro-recorder and after that found this code

    Please Login or Register  to view this content.
    The problem is, that the 2nd field, which has 24 digits is imported on an incorrect way, the last digits are converted into zeros.
    I guess, the array-parameters should be changed, but I cannot find any source, which describe the correct way of it.
    Can someone help in it?

    Thanks

  2. #2
    Forum Contributor
    Join Date
    12-28-2011
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    280

    Re: opentext, array parameter

    VBA Halp for OpenText lists how the FieldArray should be structured.

    Note that you already have it specified to import the 2nd column in Text format, so i'm not sure that changing the FieldInfo argument is going to improve things

+ 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