Inserting a Filename

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to write a macro that will consolidate data from a bunch of different
files, but the files are pretty badly formatted, so I want to insert the
original filename into an extra column before I copy the data out of the
spreadsheet and paste it into the new, large spreadsheet. I was going to just
use the Cell function to get the filename, then paste values so it didn't
change when I pasted them into the new spreadsheet, but that produces errors
in my code.

Any suggestions?
 
I'm not exactly sure what your question is, but you can insert the file name
into a cell with code like

Range("A1").Value = ActiveWorkbook.FullName


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)
 
Yeah, not worded the best, but you got the answer perfect! That's exactly
what I was looking for. Thanks!
 
You must log in or register to reply here.

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

Similar Threads

Alt codes 4
inserting graphs into word 0
Problems with a Run-time error of 1004.... 7
VBA - retrieve data on last create named range from previous inserted named range 0
Excel Unable to insert cut rows into Excel online anymore? 0
searching filenames 1
Text To Columns then insert rows 9
Filename Problems 6

Back
Top