Applying a macro on an open CSV file

[angelo328]

Dear all
Having received help already so please could some one indulge me one last time.
I have Workbook A in which I have a series of macros that will cleanse a downloaded CSV file from my bank that I have imported into my main spreadsheet. However I would prefer to run the macro without importing the CSV file.
How can I achieve this?
To reiterate I have a Main workbook let's call it Workbook A and another downloaded csv file called TransHist.csv. Workbook A contains all the necessary macros.

Thank you in Advance

Angelo

 

[mole999]

i could be wrong, but i've never heard of csv being manipulated from excel.

you could automate an import, manipulation and subsequent saving from a stored bas file

 

[angelo328]

i could be wrong, but i've never heard of csv being manipulated from excel.

you could automate an import, manipulation and subsequent saving from a stored bas file

Thank you for responding Mole999.
This may explain why I couldn't get my code to work. I therefore saved the file as an xlsx file and was succesful.
You will see from my code (cannibalised from another post) that I used the "open" command. What would be the code for a file that is already opened? This is to save picking up an older file in error. I will look into importing the csv file though finding suitable code takes me ages as I am not to clever in creating it myself.

Sub Button()
'Opens and applies macros
Dim ThisWkbkNm As String
ThisWkbkNm = ActiveWorkbook.Name

'Open/Close "WorkbookA.xls"
Workbooks.Open Filename:="C:\DOWNLOADS\TransHist.xlsx"
Application.Run "'HSBC'!Main"
On Error Resume Next

Workbooks(ThisWkbkNm).Activate                             'Reactivate this workbook

End Sub