<div>
You can use e.g. <b>System = [B1].Value</b> or <b>System = Range(&quot;B1&quot;).Value</b> if you are in Sheet1, or <b>System = [Sheet1!B1].Value</b> if in another sheet. Even better, name your field, and use that name instead of B1.
</div>


You can use e.g. System = [B1].Value or System = Range("B1").Value if you are in Sheet1, or System = [Sheet1!B1].Value if in another sheet. Even better, name your field, and use that name instead of B1.

<div>
Thanks CvD, your comment was the most complete solution and worked for me!<br />
<br />
cheers
</div>


Thanks CvD, your comment was the most complete solution and worked for me!

cheers

<div>
<div class="content wysiwyg-content">
folks<br />
<br />
how can i make my output file name exported from excel (using a macro) be named after a field in the excel sheet itself?<br />
<br />
i.e. the value from B1 from sheet 1<br />
<br />
<br />
strDefFolder = Trim(InputBox(&quot; Enter path to save file&quot;, &quot;File Location&quot;, &quot;&quot;))<br />
system = <i>field B1</i><br />
<br />
strFileName = system &amp;&nbsp;Day<br />
<br />
All help will do
</div>
</div>


folks

how can i make my output file name exported from excel (using a macro) be named after a field in the excel sheet itself?

i.e. the value from B1 from sheet 1


strDefFolder = Trim(InputBox(" Enter path to save file", "File Location", ""))
system = field B1

strFileName = system & Day

All help will do

vb macro strFileName based in field in excel sheet

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.