Value from another open workbook in filename

**biznez** · 06-19-2015, 04:44 PM

Hi, I have this code below but i would like to take the value from "I2" and put that value in the file name if possible. Only issue im having is that, that value in I2 is on another workbook. Workbook 'Test', sheet 'Report'

Please Login or Register  to view this content.

**yay_excel** · 06-19-2015, 04:50 PM

Is the other workbook open when you run this code?

**biznez** · 06-19-2015, 04:51 PM

Originally Posted by yay_excel

Is the other workbook open when you run this code?

yes its open

**biznez** · 06-19-2015, 05:50 PM

any ideas anyone?

**yay_excel** · 06-23-2015, 03:40 PM

Workbooks("Name of open workbook.xlsx").Sheets("Name of Sheet Data is On").Range("I2").Value

Value from another open workbook in filename

LinkBack

Thread Tools

Rate This Thread

Display

Value from another open workbook in filename

Re: Value from another open workbook in filename

Re: Value from another open workbook in filename

Re: Value from another open workbook in filename

Re: Value from another open workbook in filename

Thread Information

Users Browsing this Thread

Similar Threads

Using Workbook.Open Filename to Open a Cell Reference Filename

Workbook.Open Filename procedure

Activating an Open Workbook without using the whole filename as a reference

Open filename using workbook property

[SOLVED] Copy from one workbook to another-Workbooks.Open Filename

Bookmarks

Bookmarks

Posting Permissions