Opening a file within Excel to populate another excel file

[dplatten01]

Good Afternoon,

I am looking for a bit of assistance.

We have a parts order form that we use to keep a record of parts ordered on a job.

We also have a delivery note, which said parts are then typed out again.

All the parts order excel files are saved within a separate job file for each job, which is ever increasing daily.

What I have though about it having a macro/vba etc within a delivery note template, which I can then open a file within this and it auto populate the fields with part description, quantity etc etc.

Is this possible? If so can you please point me in the right direction.

Thanks!

Daniel

[JOHN H. DAVIS]

Maybe:

Sub dplatten01()
Dim wb As Workbook
Set wb = Workbooks.Open(Filename:="D:\YOUR\PATH\GOES\HERE\WORKBOOK TO OPEN.xls")
End Sub

[dplatten01]

Thanks for the swift response...

However, I need to be able to choose the file name upon opening, or from the delivery note work book.

As it would mean going in and changing all the code when I do every note and this is beyond all the other people capabilities.

[JOHN H. DAVIS]

Maybe:

This?

http://analysistabs.com/vba/open-fil...s-example-code

Or this?

Sub dplatten01()
Dim x As String
Dim wb As Workbook
x = InputBox("Please Enter The File Name")
Set wb = Workbooks.Open(Filename:="D:\YOUR\PATH\GOES\HERE\" & x & ".xlsx")
End Sub

[dplatten01]

Thanks,

I have found similar code which now when I open my spreadsheet, it opens the browse box and I can choose the file I want to open. How do I now use this once open to populate my cells?

Any pointers greatly appreciatied!

[JOHN H. DAVIS]

Care to share the code that you are using? Don't forget too use code tags.

http://www.excelforum.com/forum-rule...rum-rules.html

[dplatten01]

At the moment, im at home, and the code is at work

Im just trying to find some info while relaxing ready for work tomorrow

I will update upon return to work

[MedOpsManZA]

Hi Im am looking for a similar code. I have a Sheet Input form which I have created, it adds medical cases to a data base. What I need to be able to do is from the Sheet input form is search a specific case number to pull that record up into the Sheet Input form so that I can edit it.

Any advice will be helpful. Thanks