# Excel macro question

**URL:** <https://boards.straightdope.com/t/excel-macro-question/834244>\
**Category:** Factual Questions\
**Created:** [May 20, 2019, 6:47pm UTC](https://boards.straightdope.com/t/excel-macro-question/834244 "2019-05-20T18:47:14Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![StGermain](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/stgermain/32/2868_2.png) [@StGermain](https://boards.straightdope.com/u/StGermain)\
**Post date:** [May 20, 2019, 6:47pm UTC](https://boards.straightdope.com/t/excel-macro-question/834244/1 "2019-05-20T18:47:14Z")

</div>

If I’m recording a macro, one of the steps I’d like followed is to open an add-in that then opens a .dtf data transfer file extension. I use these regularly without a macro. I’ve written the IBM system i query using an interactive form that pops up and asks for a date range, for example.

So if I record the macro doing the steps above (including opening the add-in tab, choosing the query fro a file, completing the asked-for questions from the query and hitting enter, the macro will do the other steps I’ve recorded, but not the part with the .dtf query.

Thanks.

StG