Combine Excel Files

Joined
Jan 17, 2013
Messages
2
Reaction score
0
Hello all,

I am trying to create either a Workflow, Application, or Folder Action (haven't decided yet) that combines excel files. My problem is the Automator steps. I tried to have it "Get Specified Finder Items" (into which I drag the excel files) then "Combine Excel Files" but it just results in the Excel X showing up in the results that says "Sheet1" which is inaccessible and I cannot seem to locate it on my Mac. In the log it says everything was completed. But I not sure because I do not see the resulting excel file. I'm just not sure it's working.

Any help would be greatly appreciated.
 
Joined
Nov 26, 2010
Messages
3,558
Reaction score
52
You may need to use a Copy workflow the resulting file to somewhere you can find it.
 
Joined
Jan 17, 2013
Messages
2
Reaction score
0
Thanks for the reply. Oddly enough when I opened Excel I found all the combined results the workflow had created. But, it wasn't really what I needed. I needed the spreadsheets to be combined onto one sheet and it made as many sheets within the result as I had spreadsheets to initially combine.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top