Does VBA have an equivalent of "Text To" from Visual FoxPro

Posted by David Stein on Stack Overflow See other posts from Stack Overflow or by David Stein
Published on 2010-03-30T18:06:45Z Indexed on 2010/03/30 18:13 UTC
Read the original article Hit count: 1055

Filed under:

vba

|

visual-basic

|

vfp

|

visual-foxpro

Visual FoxPro supports syntax such as the following:

Text To VariableName TEXTMERGE noshow
select * from.....
EndText

This assigns the value of all text between "Text To" and "EndText" to the variable. It eliminates the need for multi line statements separateed by "+ ;"

Does VBA have something similar?

© Stack Overflow or respective owner

Related posts about vba

Tutoriel VBA/VB6 : Les extensions OpenGL en VBA et VB6, par Thierry Gasperment (Arkham46)

as seen on Developper.com - Search for 'Developper.com'
Bonjour à tous! Voici un article sur la programmation des extensions OpenGL, en VB6/VBA Cet article décrit l'utilisation de quelques extensions fréquemment utilisées : - Les VBO (vertex buffer objects) pour améliorer les performances - Les textures 3D pour réaliser des textures continue sur… >>> More
VBA : Obliger une saisie numérique dans une TextBox - Approche d'une résolution de besoin en VBA niv

as seen on Developper.com - Search for 'Developper.com'
Bonjour, Ci-dessous, le lien vers un nouveau tutoriel : « Approche d'une résolution de besoin en VBA - niveau débutant - Obliger une saisie numérique dans une TextBox » Le but de ce tutoriel est : De présenter une bonne approche de la résolution d'un problème simple en VBA. D'expliciter en… >>> More
Run VBA macro when condition is met

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello all, I'm creating a spreadsheet to train my numerical skills. Now, I use VBA macros to generate a new problem once the current one has been correctly solved. To do so, I still have to press a button in the worksheet, which costs time and is annoying. Is there a way that I can execute a… >>> More
Offset the tickmarks of a secondary axis

as seen on Super User - Search for 'Super User'
I would like to offset the tickmarks of a secondary axis in excel WITHOUT changing the minimum. Here is a very complicated VBA class that apparently solves the issue but I would like a solution that doesn't require me to construct my entire chart in VBA. Here is an example of what I mean (I removed… >>> More
Excel 2007 VBA macros don't work in Parallels

as seen on Super User - Search for 'Super User'
I've got a complex Excel spreadsheet I need to use at work. My colleagues use the spreadsheet on Windows PC's, with no special configuration required. I want to run it on a MacBook Pro running Snow Leopard. The spreadsheet contains VBA macros which connect to external Oracle db's over the Internet… >>> More

Related posts about visual-basic

how do i run visual basic script from visual basic

as seen on Stack Overflow - Search for 'Stack Overflow'
The script is used to enable or disable lan. Id like to run it from a vb appln by integrating it could someone help plz. >>> More
Decimal data type in Visual Basic 6.0

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to do calculations (division or multiplication) with very large numbers. Currently I am using Double and getting the value round off problems. I can do the same calculations accurately on C# using Decimal type. I am looking for a method to do accurate calculations in VB6.0 and I couldn't find… >>> More
Microsoft Visual Studio Release History/Timelines/Milestones

as seen on Microsoft .NET Support Team - Search for 'Microsoft .NET Support Team'
1975 – Bill Gates and Paul Allen write a version of Basic for Altair 8080 1982 – IBM releases BASCOM 1.0 (developed by Microsoft) 1983 – Microsoft Basic Compiler System v5.35 for MS-DOS release 1984 - Microsoft Basic Compiler System v5.36 release 1985 – Microsoft QuickBASIC 1.0 1986 – Microsoft… >>> More
Visual Basic 2010 Language Enhancements

as seen on 4 Guys From Rolla - Search for '4 Guys From Rolla'
Earlier this month Microsoft released Visual Studio 2010, the .NET Framework 4.0 (which includes ASP.NET 4.0), and new versions of their core programming languages: C# 4.0 and Visual Basic 10 (also referred to as Visual Basic 2010). Previously, the C# and Visual Basic programming languages were managed… >>> More
This Week's Developer Reading List

as seen on Dr Dobbs - Search for 'Dr Dobbs'
Design, Visual Basic, and Google AppEngine Google AppEngine - Visual Basic - Google - Tools - Chats and Forums >>> More