About 50 results
Open links in new tab
  1. Workbooks.OpenText Error "Expected function or variable"

    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 …

  2. How to programatically define FieldInfo parameter on Workbooks ...

    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 …

  3. Workbooks.OpenText not parsing csv files properly Excel 2016

    Feb 13, 2017 · Workbooks.OpenText not parsing csv files properly Excel 2016 Asked 8 years, 11 months ago Modified 5 years, 4 months ago Viewed 16k times

  4. Opentext content server unable to create/connect to database

    Jan 31, 2021 · Opentext content server unable to create/connect to database Asked 4 years, 11 months ago Modified 4 years, 11 months ago Viewed 2k times

  5. Powershell - Workbook.OpenText with parameter FieldInfo

    Nov 25, 2022 · 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 …

  6. Read and parse a Json File in C# - Stack Overflow

    How does one read a very large JSON file into an array in c# to be split up for later processing? I have managed to get something working that will: Read the file Miss out headers and only read v...

  7. .net - Unable to open a file using System.IO.File.OpenText (file path ...

    Dec 8, 2016 · Unable to open a file using System.IO.File.OpenText (file path) in C# Asked 9 years ago Modified 9 years ago Viewed 5k times

  8. Convert .csv file into Excel in VBScript - Stack Overflow

    Apr 3, 2013 · Set xl = CreateObject("Excel.Application") Set wb = xl.Workbooks.OpenText "input.csv", , , xlDelimited, xlDoubleQuote, _ False, False, True, , , , dataTypes from Vbscript to import csv into …

  9. FileStream StreamReader problem in C# - Stack Overflow

    Dec 7, 2010 · public static IEnumerable<string> ReadLines(string path) { using (StreamReader reader = File.OpenText(path)) { string line; while ((line = reader.ReadLine()) != null) { yield return line; } } } …

  10. Upload documents with OPENTEXT REST API not working

    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 …