| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting a Filename
This was great..
Thanks !! Boss "AlwaysFroosh!" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Are there any NON-Visual Basic solutions for inserting a picture based a derived or called filename? | Excel Worksheet Functions | |||
| Converting a Variable Filename to a Constant Filename | Excel Programming | |||
| Inserting a filename into a cell | Excel Programming | |||
| Saving filename same as import filename | Excel Programming | |||
| Inserting Date In Filename Using Macro | Excel Programming | |||
Hybrid Mode
