• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

mteas

New Member
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.
 

Attachments

  • sec_bhavdata_full.csv
    176.2 KB · Views: 2
Code:
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
 
CSV is flat file format so in principle you need to save the file in native Excel format (.xls, xlsx, xlsm, xlsb etc).
 
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.
 

Attachments

  • test.xls
    371.5 KB · Views: 2
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 ! …​
 
Yes , i removed all the blank space prefix in entire work book.Now, working fine . Thank you.
 
Last edited by a moderator:
Back
Top