I am unable to write formulas in the attached .csv file?

[mteas]

Good Morning ,

I am unable to write any formulas in the attached excel sheet 1. How can i write macros for this excel file. Can anybody guide me, how to manipulate the data in the attached file. Even i am unable to copy the sheet to another excel workbook.

Thanks in Advance.

 

[AlanSidman]

Option Explicit

Sub copysheetstonewbook()
'Macro to open worksbooks in folder and copy first sheet to new workbook.
'only one sheet per workbook.

    Dim myFile As String, myPath As String
    Dim wkb As Workbook, mainWkb As Workbook
    Dim sht As Worksheet

    Set mainWkb = ThisWorkbook
    'change path as necessary
    myPath = "C:\Users\Alan\Desktop\"
    myFile = Dir(myPath & "*.xls?")

    Application.ScreenUpdating = False
    Do While myFile <> ""
        Set wkb = Workbooks.Open(myPath & myFile)
        wkb.Sheets("Sheet1").Copy mainWkb.Sheets(Sheets.Count)
        wkb.Close True
        myFile = Dir
    Loop
    Application.ScreenUpdating = True
End Sub

 

[shrivallabha]

CSV is flat file format so in principle you need to save the file in native Excel format (.xls, xlsx, xlsm, xlsb etc).

 

[mteas]

CSV is flat file format so in principle you need to save the file in native Excel format (.xls, xlsx, xlsm, xlsb etc).

I save the file as .xls and input conditions but no use . formula out put showing blank excel though condition is true, please help.Please check the attached file.

 

[Marc L]

Hi,​

​

as the condition is FALSE so the result is obviously blank so just check the formula ‼​

Check also accordingly column B as it does not contain "EQ" but " EQ" with a leading space ! …​

​

 

[mteas]

Yes , i removed all the blank space prefix in entire work book.Now, working fine . Thank you.