locked
Power Query and VBA RRS feed

  • Question

  • Can you use Power Query for something like this (that you would typically use vba for): You have three files in a folder, you open each one, create copies of 1st worksheet and perform formatting/calculations to each one. The process is consistent each time. Thanks. 
    Wednesday, August 24, 2016 4:38 PM

Answers

All replies

  • Can you use Power Query for something like this (that you would typically use vba for): You have three files in a folder, you open each one, create copies of 1st worksheet and perform formatting/calculations to each one. The process is consistent each time. Thanks. 
    • Merged by Olaf HelperMVP Wednesday, August 24, 2016 5:00 PM Same question from same OP
    Wednesday, August 24, 2016 4:38 PM
  • Hello Alex,

    Power Query do have an own script language to automate such imports, see Power Query (informally known as "M") Formula reference

    And please avoid double posts.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by Charlie Liao Thursday, September 8, 2016 9:36 AM
    Wednesday, August 24, 2016 5:45 PM
  • >Can you use Power Query for something like this (that you would typically use vba for):

    That is _exactly_ what Power Query is for. 

    David


    David http://blogs.msdn.com/b/dbrowne/

    Wednesday, August 24, 2016 5:52 PM