Macro to reformat tab after importing data

%3CLINGO-SUB%20id%3D%22lingo-sub-380708%22%20slang%3D%22en-US%22%3EMacro%20to%20reformat%20tab%20after%20importing%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-380708%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20repetitive%20task%20where%20I%20import%20XML%20data%20into%20an%20excel%2C%20and%20then%20hide%20certain%20columns%2C%20reformat%20other%20columns%2C%20sort%20the%20data.%26nbsp%3B%20When%20I%20try%20to%20record%20the%20macro%20to%20do%20all%20of%20this%2C%20no%20steps%20seem%20to%20be%20saved...%20(using%20Developer%20-%20RecordMacro%2C%20(execute%20reformatting%20steps)%20then%2C%20StopMacro.%26nbsp%3B%20Any%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-380708%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I have a repetitive task where I import XML data into an excel, and then hide certain columns, reformat other columns, sort the data.  When I try to record the macro to do all of this, no steps seem to be saved... (using Developer - RecordMacro, (execute reformatting steps) then, StopMacro.  Any ideas?

0 Replies