<div>
can give more details, perhaps an example file?
</div>


can give more details, perhaps an example file?

<div>
@ElrondCT...yes, that is what I am aiming for
</div>


@ElrondCT...yes, that is what I am aiming for

<div>
Thank you, this put me on the right path
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I have some script that I have copied from textpad and pasted into excel. &nbsp;I need to update the script incrementally where it says &quot;samp1&quot; below and I need to change the select statement in that script as well. &nbsp;I have all of the field names pasted in one column in sheet2 of my excel workbook and the script is pasted on sheet1. &nbsp;See example below:<br />
<br />
Sheet 1<br />
<br />
samp1.abc<br />
samp1.123<br />
samp1.nowIknow<br />
samp1.sql=select * from &quot;the first name in cell a1 on sheet2&quot;<br />
<br />
samp2.abc<br />
samp2.123<br />
samp2.nowIknow<br />
samp2.sql=select * from &quot;the first name in cell a2 on sheet2&quot;<br />
<br />
samp3.abc<br />
samp3.123<br />
samp3.nowIknow<br />
samp3.sql=select * from &quot;the first name in cell a3 on sheet2&quot;
</div>
</div>


Hi Experts,

I have some script that I have copied from textpad and pasted into excel.  I need to update the script incrementally where it says "samp1" below and I need to change the select statement in that script as well.  I have all of the field names pasted in one column in sheet2 of my excel workbook and the script is pasted on sheet1.  See example below:

Sheet 1

samp1.abc
samp1.123
samp1.nowIknow
samp1.sql=select * from "the first name in cell a1 on sheet2"

samp2.abc
samp2.123
samp2.nowIknow
samp2.sql=select * from "the first name in cell a2 on sheet2"

samp3.abc
samp3.123
samp3.nowIknow
samp3.sql=select * from "the first name in cell a3 on sheet2"

Excel vba to place field name from another worksheet into a different cell/worksheet

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

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

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.