Import File Name With Out Full Path Into Header

[mkelsay91]

Hi All!

So here is a challenging one that has had me going for a solid week and I can't seem to wrap my mind around it.

So what I have is a simple spreed sheet with a macro, I click import to active a pop of file directory, to select file to import. That seems to all go fine but what I am struggling with is I need to import the name of the file as well into my header. Can this be done or is it pretty much hopeless.

This is for my job site where we do trailer inspections, and I was hoping to cut the time we spend copying and pasting this information. I have attached my excel with macro (Trailer Inspections) and a mach up (YardHoundReport) of what the sheets look like that I am importing.

Also if you know of a way to insert blacked out rows between the different parking areas that be sweet too, but it's no biggy.

Thank You for any feedback you can give.

[JBeaucaire]

1) where in the master file does the file name go?
2) When you run the macro it inserts an "Actual Temp" column F each time causing multiples to appear. That's not right is it? Shouldn't your master have all the columns already laid out and you copy the data from the source file into the correct columns that already exist? We can fix that.

[mkelsay91]

Ooops! I goofed and add the one I was tampering with instead of the orginal. I have resubmitted the correct one labeled "Copy of Trailer Inspection.

Apologize.

[JBeaucaire]

Oops, you didn't answer any of my questions from post #2. Answer those, as well as :

3) When you run this macro, doesn't it need to add to the bottom of the existing data already on this master?

[mkelsay91]

The master should not have any date, except for what is listed at the top.

What I am trying to accomplish is Importing the file name "YardHoundReport 10_23_13_-_11:23" into the header of the Master Copy.

I was hoping there is a way to add something into my script so when I click Import and I get the File Browser, when I click on that file I am importing data from it pulls the file name as well into the Right Header.

3) Its not intended for compiling data, it's a simply import and format set-up I was aiming for because I tend to prevent any saving.
2) Due to nature of the way I have the import set up, the macro should insert a column and name it "Actual Temp".
1) I believe I answered that at the start of the post of this.

[JBeaucaire]

Insert something like this where you'd like:

Please Login or Register  to view this content.

[mkelsay91]

Doesn't seem to work, I keep getting error (800401a8).

[JBeaucaire]

When you debug and hover your mouse over the highlighted code, what is the value of wkbSourceBook?

[mkelsay91]

Range ("Z1").Value = Empty

wkbSourceBook.Name = <Automation error>

I am unsure which you wanted.