newbie in VBA Drag and drop

[den 2005]

Hi,

Do not know how can this be done if it is possible, the task is to import
and export data from and to database, but user can select from a list columns
what they want to add, there will be a dialog will appear and allow user to
select data to be included in a word document- "drag and drop" effect, how
can this be done or it is possible using VBA?

Thanks in advanced.

den2005

 

[Doug Robbins - Word MVP]

The following code in the initialize event of a userform will populate a
listbox on that form with data from a table in an Access database. Your
user could then select the record containing the data that they want to
insert into the document and you could have a command button on the userform
that executed the necessary code to do that.

To get started with userforms, see the article "How to create a Userform"
at:

http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[den 2005]

Hi Doug,

Are we talking about using VB6 or .net languages in doing this? Not quite
familar with any visual studio version 6 languages, I know a little about
vb6, so don't know what you are referring to, so you are saying it is
possible to do this drag and drop effect in vb6 w/ VBA?

Dennis

 

[Doug Robbins - Word MVP]

I'm talking VBA (Visual Basic for Applications) though VB6 may be very
similar. We don't do no dot net here. (At least I don't)

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP