extract certain values from multiple workbooks into a new file

  • Thread starter boris.radosavljevic
  • Start date
B

boris.radosavljevic

Hi, I'm hoping somebody could help me with this problem. It's pretty
simple, but an Excel script would be the first for me, although I'm
not a complete newbie to scripting. I could use some reverse
engineering insight.

Ok, here is my problem. I have multiple files, all based on the same
template. I'd like to create a new file with values from I39 and I40,
which would include the file name, and these two values in rows.

If it makes it any easier, I've extracted the file names by piping DIR
into a file, so the script could use those as file name index.

A big thanks for all help.
 

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