Reformat Spreedsheet driven by existing spreedsheet formating RRS feed

  • Question

  • New to VBA and not certain this is a VBA thing, thus the question.

    I have a situation where I get a formatted excel spreadsheet as output from another application.    The output has fixed columns, but a variable number of rows where the content and formatting change in a predictive but variable way.

    I presently get the initial spreadsheet and then manually reformat as needed, but would much like to do this automatically.

    My question at this point is whether VBA is the right solution for this task, or are there other solutions better suited to such a task?   

    I want to get started in the right direction to avoid wasting a lot of time.


    Sunday, April 26, 2015 5:31 PM


All replies