Hello everybody.
I was hoping to get assistance on writing code within a macro to do a two step process. My macro works well in gathering the data but I need to do two more steps which I am unclear on.
The workbook after the macro runs has two sheets 1 = “Combine Sheet” and 2 = “Logged Data”.
On the logged data sheet I have the following file path in cell A8.
C:\raw_data\businessdocument.new\businessfinancemodel.new_Matrix_Insurance.csv
I would like to leave this data in place but copy the info between the 2nd backslash and the third backslash to read “businessdocument.new” and place that in cell B2.
My issue is I cannot figure out the code to extract this piece of data.
And my second step is I would now like to save this document as “c:\installer\newbusiness\businessdocument.new.csv”
So basically add a string to the beginning of what is in sheet “Logged Data” cell B2 and then save it as a .csv file and not an xlsx file. I am using Excel 2007.
Is there a possibility of doing this automatically without me having to click on the saveas file browse window.
I have to do a lot of these sheets and if I can just fly though these it would be great.
I appreciate in advance all your assistance.
I was hoping to get assistance on writing code within a macro to do a two step process. My macro works well in gathering the data but I need to do two more steps which I am unclear on.
The workbook after the macro runs has two sheets 1 = “Combine Sheet” and 2 = “Logged Data”.
On the logged data sheet I have the following file path in cell A8.
C:\raw_data\businessdocument.new\businessfinancemodel.new_Matrix_Insurance.csv
I would like to leave this data in place but copy the info between the 2nd backslash and the third backslash to read “businessdocument.new” and place that in cell B2.
My issue is I cannot figure out the code to extract this piece of data.
And my second step is I would now like to save this document as “c:\installer\newbusiness\businessdocument.new.csv”
So basically add a string to the beginning of what is in sheet “Logged Data” cell B2 and then save it as a .csv file and not an xlsx file. I am using Excel 2007.
Is there a possibility of doing this automatically without me having to click on the saveas file browse window.
I have to do a lot of these sheets and if I can just fly though these it would be great.
I appreciate in advance all your assistance.
