Menu

setting constant path

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.programming

Don Guillett Don Guillett is offline

Don Guillett is offline

external usenet poster

Posts: 10,124

Default

setting constant path

FormulasDefine name

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jayen" wrote in message
...
Don,

I am using excel 2007 and under the insert menu, there is no option for
defining name as you suggested.
--
Jayen

"Jayen" wrote:

Help please.
I have one workbook which is a csv file lets call it source1.xls from a
banking system. I also have 28 workbooks (reports) which derive data
from
the csv file. Some of the cells in the 28 books do calculations based on
values from source1.xls. Is there a way that I can specify, in an add in
or
macro or whatever, a constant path for the file so that when cell A2 of
a
report looks at a cell in the source, it doesn't have lets say path like
=SUMPRODUCT(--('T:\Operational\BQC\BNA_Reports\BNA\Source
files\[fdbpre.xls]fdbpre'!$DK$1:$DK$65536="230"),
--('T:\Operational\BQC\BNA_Reports\BNA\Source
files\[fdbpre.xls]fdbpre'!$D$1:$D$65536="973"),
--('T:\Operational\BQC\BNA_Reports\BNA\Source
files\[fdbpre.xls]fdbpre'!$DL$1:$DL$65536="024"),
'T:\Operational\BQC\BNA_Reports\BNA\Source
files\[fdbpre.xls]fdbpre'!$CB$1:$CB$65536)--

This is rather long and if the source file changes location it becomes
difficult to change every cell in the reports that references the source.
Would prefer just to refer to a path variable just dont know how to do
it.
Thank you.
Jayen

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What happened to setting up a constant using F4?	Stan	Excel Worksheet Functions	2	April 18th 10 07:07 AM
Setting a path to a folder	Boots	Excel Discussion (Misc queries)	2	August 10th 06 02:14 PM
setting transferred text as constant	Tonto	Excel Discussion (Misc queries)	1	October 26th 05 11:01 PM
Setting a Constant when creating a new file from a template?	Conan Kelly	Excel Programming	1	July 15th 05 06:10 AM
filename and path as constant	mark kubicki	Excel Programming	1	January 10th 04 09:38 PM

All times are GMT +1. The time now is 05:32 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement