Changing filename as variable

mtrumbull · mtrumbull's Computer Specifications

I'm not sure if my title is really clear on what I need help with. If not, I apologize.

I have a file that when a user submits it via a selection button, it gets saved with a new name. The issue is that I have some VBA code that needs to use the file name as part of a formula. Maybe this will explain it:

Range("F10").Select 'Project Budget
ActiveCell.FormulaR1C1 = "='[fname]Budget Estimate'!R288C7"

The file name "fname" is equal to "ThisWorkBook.Name" but the above formula gives me a #REF! error in the sheet in another open work book that I'm trying to pass the values to.

Any idea on what I'm doing wrong. Thanks for any help in advance.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Variable Filename	Berj	Microsoft Excel Programming	1	26th Aug 2008 08:54 AM
filename as variable	sck352@gmail.com	Microsoft Excel Programming	1	5th Dec 2007 08:47 PM
Filename variable	starke1120@hotmail.com	Microsoft Excel Programming	17	4th Sep 2006 02:47 PM
Converting a Variable Filename to a Constant Filename	=?Utf-8?B?TWFnbml2eQ==?=	Microsoft Excel Programming	2	15th Aug 2006 06:13 PM
if i use the filename as variable name	DotNetMania	Microsoft C# .NET	1	23rd May 2004 10:16 PM