Discussion Locked

Open Excel 2K files & Link Cond Data

0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to dynamically open a secondary Excel 2000 file & link data conditionally to the primary Excel file.

This is the scenario: I need to open an Excel file whose name changes daily (i.e. Reportyyyymmdd.xls-based on current date) and link datain that worksheet. Each row's data layout (item, cost, qty, etc) are always the same but every row may not always be in the file. So Cell 1 needs to link to the Item A's cost if Item A exists, Cell 2 links to Item B's cost if Item B exists, etc.

I know Access VBA, but no experience with Excel VBA. Can anyone help??!! You would be a lifesaver and it would be greatly appreciated. Thanx!

0 replies

No replies were posted before this discussion closed.

This discussion is closed to new replies.