Why does my code below not work? It highlights the .OpenText part and states: Expected function or variable Dim Indata As Excel.Workbook Set Indata = Workbooks.OpenText (Filename:="C:\Users\theP...
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 f...
Dim excelApp Set excelApp = CreateObject("Excel.Application") excelApp.Workbooks.OpenText txtFilePath, , , 1, , , , True Dim workbook Set workbook = excelApp.ActiveWorkbook EDIT EDIT: The reason I was trying to use OpenText was because I read somewhere that Excel couldn't Open a CSV with semicolon options or something like that.
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". Here is the article from MS so you ...
I'm trying to use the Workbook.OpenText passing the parameter FieldInfo but with no success I want to open a recent created csv file(I also tried with txt extension) with the fieldinfo parameter so...
Workbooks.OpenText filepath, DataType:=xlDelimited, comma:=True, local:=True Windows(filename).Actvate df = Range("A2", Range("A2").End(xlDown).End(xlToRight)) And then leaving df where I want in my worksheet. This works fine when working on my local computer but the problem comes when i want to run this macro in the server. Where it opens the file incorrectly (It separates the columns by the ...
How to return the links objects in the content of result of dql endpoint call for OpenText Documentum Asked 6 months ago Modified 5 months ago Viewed 78 times
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 attributes to that with the categories/attributes in Open Text and upload the same to CS.
