Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel VBA links to other files

Status
Not open for further replies.
ChristianDK

ChristianDK

Programmer
May 31, 2007
18
DK
Hello

Im trying to link to 125 other Excel files based on input from cells

Sub Link()
For i = 1 To ActiveWorkbook.Sheet.Rows.Count
Range("Sheet1!B(i)") = "D:\Documents and Settings\New Folder\Range" & ("Sheet1!B1") & Range("Udtrækrapportpakker!B1")
Next
End Sub

Im i totally off?
Hope someone can help me out
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Filter vba problem
Replies
1
Views
514
Andrzejek
Andrzejek
Omarahmed22
  • Locked
  • Question
VBA Formating
Replies
1
Views
463
Andrzejek
Andrzejek
Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
370
Viswa.R
Viswa.R
FrankMars
  • Locked
  • Question
Exporting Records to Excel 1
Replies
6
Views
485
Andrzejek
Andrzejek
Knicks
  • Locked
  • Question
Microsoft Access VBA Coding to Excel (early binding) 1
Replies
2
Views
791
Knicks
Knicks

Part and Inventory Search

Sponsor

Back
Top