Hi there, One of our users here is having an issue with an Excel spreadsheet. He receives an automated email with an Excel spreadsheet attached from SAP but when he tries to open it it comes up with this error 'Cannot create file: OOS_9229.xls. Right-click the folder you want to create the file in, and then click Properties on the shortcut menu to check your permissions for the folder'.

Export or Save Excel Files with Pipe (or Other) Delimiters Instead of Commas. By Lowell Heddings on July 8th, 2010. Exporting Excel Files as Pipe Delimited. 3 How to Convert a Spreadsheet Into a Comma-Delimited String. You can export Excel data in the text-based. You might have to save the file in a pipe-delimited. Recently I was tasked to create a pipe delimited file from. File to pipe delimited file rather than comma. Then open the.csv file in a text editor. Hi, I am little new to macros, i am trying to convert around 500 pipe delimited text file into excel so that in excel they appear in different columns. Example; text.

Normally this refers to them needing to empty their temp internet files, which I tried but it didnt resolve the issue. I had him send me the file and I received this error when trying to open it 'The file you are trying to open, 'OOS_9229.xls', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?' To which I select Yes. Once it opens, I try to save the file and it comes up saying the extension is 'Text (tab delimited)'. I've researched this but cant seem to come across anything that tells me how to run a script or something similar so the excel document opens properly every time.

Is there any way to do this? I dont want to have to do it for each time he receives the file which is once a week.

I'm still new to the IT world so i'm a bit stumped! Please help me if you can! Cheers, Alana. Hi, Based on my research, I think the error message occurs in your users’ computer doesn’t indicate to empty the temp internet files, instead, I think that this issue will occur when the Temporary Internet Files folder is stored on a server on which you do not have sufficient permissions. To resolve this, please refer to the following link to install the fix or modify the registry. As the error message you received in your computer, which version of Excel do you use? If it is Excel 2007, then refer to the following link: Jaynet Zhang TechNet Community Support.

Hi, Based on my research, I think the error message occurs in your users’ computer doesn’t indicate to empty the temp internet files, instead, I think that this issue will occur when the Temporary Internet Files folder is stored on a server on which you do not have sufficient permissions. To resolve this, please refer to the following link to install the fix or modify the registry. As the error message you received in your computer, which version of Excel do you use?

If it is Excel 2007, then refer to the following link: Jaynet Zhang TechNet Community Support.

You can save an Excel file as comma delimited or tab delimited but not pipe delimited. Here is how you can achieve pipe delimited export. Basic Sample Just to show here the fundamentals.

Sub Writing_to_a_text_file() Dim N As Integer Dim FileName As String 'Define where to save the output file. FileName = Environ('USERPROFILE') & ' Desktop ' & 'Sample1.csv' 'Get a free file number N = FreeFile Open FileName For Output As #N 'Print' print data into the file. Another method is 'Write'.

'Both do the same job but behave slightly differently. Try Google it. Print #N, 'This is a test' Print #N, 'Writing another line here' Print #N, Join(Array('Pipe', 'delimited', 'line', 'here'), ' ') Print #N, vbNullString '. If you just want to save a sheet out as a pipe delimited file then this should work for you: Sub DelimFile() Open 'C: output.txt' For Output As 1 'Change this path rowno = 1 colcount = Application.CountA(ActiveSheet.Rows(1)) While activesheet.Cells(rowno, 1) ' dataout = ' For c = 1 To colcount If c colcount Then dataout = dataout & '' & Trim(activesheet.Cells(rowno, c)) & '' ' Else dataout = dataout & '' & Trim(activesheet.Cells(rowno, c)) & '' End If Next c Print #1, dataout rowno = rowno + 1 Wend Close #1 End Sub. Bitlord 1.1 For Mac there.