Hi,
I'm hoping someone can help. I need an excel template macro to be able to pop up an input box where i can select either an excel or a text file to open (preferably where i can search the file). Once an excel file is open to be able to pop up another input box to select which row to delete starting from row 1, so if i select 4, the macro will delete starting from row one to row 4. Once deleted to be able to pop another input box where i can select which column to trim (deleting hidden spaces) and finally copying only that column and saving it as a csv file on the desktop. Same goes for a text file where it can open as a fixed width so columns will be aligned with data when populated in excel. Any help is much appreciated. Thank you!
I'm hoping someone can help. I need an excel template macro to be able to pop up an input box where i can select either an excel or a text file to open (preferably where i can search the file). Once an excel file is open to be able to pop up another input box to select which row to delete starting from row 1, so if i select 4, the macro will delete starting from row one to row 4. Once deleted to be able to pop another input box where i can select which column to trim (deleting hidden spaces) and finally copying only that column and saving it as a csv file on the desktop. Same goes for a text file where it can open as a fixed width so columns will be aligned with data when populated in excel. Any help is much appreciated. Thank you!