How to create macro to browse a file and alter column?

Question

i need to browse file in the particular path and pick the file after that change the column.

Madhanmohan Devarajan · Answer

Raja, First you need to open the excel sheet where you need to write macro. After that to add button you need to select "Developer" tab -> Insert Icon-> button Now it will show you a pop with click event for the newly added button. Copy and Paste the below code in the Editor. // Button click event Dim my_FileName As Variant my_FileName = Application.GetOpenFilename(FileFilter:=”Excel Files,*.xl*;*.xm*”) If my_FileName False Then Workbooks.Open FileName:=my_FileName End If Note: The above code should be copied in the button click () event. This only to show the File open dialog box on clicking the button. You need to create function for deleting the columns in the sas production details.xlsx using below macro. Sub Macro1() ' ' Macro1 Macro ' ' Range("B1").Select Range(Selection, Selection.End(xlDown)).Select Columns("B:B").Select Application.CutCopyMode = False Selection.ClearContents Selection.Delete Shift:=xlToLeft Columns("C:C").Select Selection.Delete Shift:=xlToLeft End Sub You have to change the macro according to your need. Hope it will be helpful for you.

Madhanmohan Devarajan · Answer

Raja, Please be specific about the requirement. 1. Are you having list of filenames in Excel sheet? 2. Are you trying to open the files one after the other from the list in Excel? 3. After completing the process with one file you are going to change the color of the filename (cell) in the list to mark it as "File already visited"? Please answer all the above queries, so that it will be easy for me to understand your requirement and to provide solution.

Raja · Answer

Madhanmohan Devarajan sorry for late reply sir. Thank you so much!

Raja · Answer

hi, i expect that the excel sheet has set one click option after that i click that option it shows browse a file option in computer. ex : E:\software\DRIVER\driver now i will select the file name sas production details.xlsx select the file and click ok need to re order the column if i have the a to z column then i need to set like b,f,g,h,d,l and delect the other column

How to create macro to browse a file and alter column?

Answers (4)