May 25, 2020 · You're trying to set the workbook variable while using the OpenText method but OpenText doesn't return a workbook reference. Do this instead. Dim Indata As Excel.Workbook Workbooks.OpenText(Filename:="C:\Users\thePunter\Desktop\Count_Types_062016.txt", DataType:=xlDelimited, Tab:=True) Set Indata = ActiveWorkBook

Feb 13, 2017 · OpenText ignores all format options with a CSV file having a .csv extension. With a CSV file having a .txt extension and using the xlDelimited option, OpenText takes account of the FileInfo parameter, but the column numbers are ignored, so an array element must be present for each column starting from 1 until all columns with non-default ...

Dec 8, 2016 · Please find the updated code. Here i am trying to open a file which exists. Here is the code snippet. sample.txt is to get the complete file path. I am manually using that path and able to open th...

Apr 6, 2017 · I want to upload some documents to Open Text via the REST API's. I have an Open Text CS set up, but I am not able to hit any of the REST API's. Also, I need to know how to map my document attribu...

I've come across a nasty little bug in Excel VBA's .OpenText method.. It errors on opening any text or CSV file when the first two letters are upper-case "ID". It errors on opening any text or CSV file when the first two letters are upper-case "ID".

Dec 19, 2018 · I'm new to the OPENTEXT Rest API and while I'm able to authenticate/create folders using it, I can't get the document upload to work. The following is the code I've been using: import java.io.

Jul 20, 2018 · The Workbooks.OpenText method takes a parameter called FieldInfo to determine the format types in each column. For example the following code will open a text file and give Columns 1 and 2 a Text format, and Column 3 a General format. Workbooks.OpenText fileName:="C:\somefile.txt", _ FieldInfo:=Array(Array(1, 2), Array(2, 2), Array(3, 1))

Workbooks.OpenText Filename:=filetoopen, Origin:=65001 Set wbDownload = ActiveWorkbook However this opens the file with the substituted ascii characters still with the Origin 65001 - UTF-8 specified seemingly being ignored / not working.

We need to write a report to find the number of below categories of users on our OpenText Content Suite Platform installation: Content Suite Platform Read-Only Named Users Content Suite Platform Standard Named Users SAP Extended ECM by OpenText Professional Users

Mar 15, 2018 · Version 16, Beginning with the OpenText Acquire of Exstream Suite products from HP and their so called first release of the product Hence buying it all from HP in 2016. Can do this as well v16+. Share