I have .csv file with this... name,package,start,end,state Bobby the guru,Some text,08/04/2024,08/09/2024,Lapsed and I'm opening it with Function GetData() Workbooks.OpenText filename:="c:\MemberHistory.csv", _ FieldInfo:=Array(Array(...
With Excel 365 for MAC/OS I get error 1004 when trying to open a *.csv file using VBA OpenText. I receive .csv files (semicolon delimiter) from my bank and want to automate importing the data into worksheets. To that end, I recorded a macro while imp...
I want to iterate through the files in a given folder in Enterprise Connect to check, if file exists, delete or add files. I am able to access the folders, but can't iterate through the items: Sub IterateEnterpriseConnect() Dim FP As MAPIFolder Dim f...
Deploy and tailor OpenText Content Server to meet unique business needs.
Seamlessly connect OpenText with SAP, Salesforce, Microsoft 365, and more.
Smooth transitions from legacy systems to the latest OpenText versions.