Is it possible to code a twain interface with vba?

Microsoft OFFICE


  • 1. Access Runtime Problems
    Good Day I have a report in Access 2002 program that goes and gets the hyperlinks with in a form and past the photos into the report. I do this with the following code "On Page" and all works well. When I generate a runtime version and put it on a client computer the photos and hyperlinks will not show up. In other words the program does not work in Run Time. Any idea what DLL might be the problem. Thanks Wayne Here is the code I am using Dim hyp1 As String Dim hyp2 As String Dim hyp3 As String Dim hyp4 As String Dim hyp5 As String On Error Resume Next hyp1 = Photo.HyperLink.Address Image42.Picture = hyp1 On Error Resume Next hyp2 = Photo2.HyperLink.Address Image43.Picture = hyp2 On Error Resume Next hyp3 = Photo3.HyperLink.Address Image44.Picture = hyp3 On Error Resume Next hyp4 = Photo4.HyperLink.Address Image45.Picture = hyp4 On Error Resume Next hyp5 = Photo5.HyperLink.Address Image46.Picture = hyp5
  • 2. unviewable projects
    (winXP, wordXP, [word-]vba) I would make a Reference from File A to File B. (Tools | Reference | Browse..) but every file ive added throws "Project is Unviewable". but i have not locked them! why these files are protected? any suggestion? thx! Chris
  • 3. Application FileSearch Object
    The code below works on Windows 2000 or XP home machines, but not on a XP Professional machine. With XP Pro no files are found even though they are in the directory. Can anyone help? Set fs = Application.FileSearch With fs .NewSearch .lookin = "C:\WCReportCreator\ImportFiles" .FileName = "*.xls" If .Execute > 0 Then For i = 1 To .foundfiles.Count lstSpreadSheets.AddItem .foundfiles(i) Next i Else MsgBox "There are no files found to import." End If End With Thanks Rick

Is it possible to code a twain interface with vba?

Postby QWxleGFuZHJl » Wed, 12 May 2004 06:01:03 GMT


1. I am hoping to code a macro with vba (that stands for visual basic editor right?) that will allow me to get documents from a scanner (twain interface) programaticaly. Can vba allow me to do this

2. If not, is it possible to code a c/c++ program that will work "embedded" with infopath. (like a dll that gets executed by infopath

thanks for informatio

Alexandre Harvey-Tremblay.

Re: Is it possible to code a twain interface with vba?

Postby Mike Walker » Sun, 16 May 2004 08:06:22 GMT

Hi Alexandre
editor right?) that will allow me to get documents from a scanner (twain
interface) programaticaly. Can vba allow me to do this?

vba stands for Visual Basic for Applications edition which is a subset of
the VB language - There are a lot of third party controls that would allow
you to manipulate through a control twain controls
sell these type of things

"embedded" with infopath. (like a dll that gets executed by infopath)

Infopath has vb script interfaces I think that is not as rich but could
shell an external application I suppose but i am not quite sure what you are
trying to achieve, I know there is a new sp1 with some enhancements to the
programming interfaces for infopath which is a good thing but not worked
that heavily in infopath and not sure on your complete solution requirements


Mike Walker
(Reply via NG)

Similar Threads:

1.vbdot net and Twain interfacing ?

Is anybody familiar with the idea of TWAIN programming. I need to interface
a TV card with my vb/ application.

Any comments are welcome.

2.twain interface

Hey :)

I need to interface a VB.NET desktop app with TWAIN to capture from generic
software devices.

Anyone done this before or have a good tutorial?


Liddle Feesh
*fap fap fap fap*
<><   <><    <><  <><    ><>
         <><    <><     <><    <><  <><  <><

3.Twain Interface

Is there a way to access and scan an image using a twain interface. Is
there a way to take that image and cut it into sections and have VB
automatically save it?

4.VBA code to run & wait for cmd line interface application

I want to get started with the shell command to run my process below under 1 
VBA subroutine. I've just started looking at methods to wait for the external 
application to complete. Any pointers would be very welcome.
Here are the broad steps in my current process:
Excel sub1
get list of external app1 filenames from directory1 according to inputbox
transcribe files in list from .txt1 to .txt2 structure
write command file com.txt for external app2 to run with .txt2 files as input
end sub
Command line
run external app2.exe<com.txt (output is .txt3 files)
exit Batch file 
Excel sub2
read & process .txt3 files
update worksheet database
end sub

5.Interfacing with Excel from Inside Project VBA code

Okay... not sure if this question rightly belongs here or in the Excel
VBA group...

I have some VBA code in Project where I'm writing some data from my
Project file to an Excel spreadsheet.

so I do the following

Set xlApp = CreateObject("Excel.Application")

If xlApp Is Nothing Then
    Set xlApp = New Excel.Application
    xlApp.Visible = True
    xlApp.Workbooks.Open ("C:\test.xls")
    xlApp.Visible = True
End If

Set xlSheet = xlApp.Worksheets("Sheet1")

and then via incrementing a couple of counters, say i and j, I cycle
through my Project using "xlsheet.cells(i, j).Value =" to write the
desired data to my spreadsheet (in this case test.xls).

I then successfully save and close the spreadsheet, e.g...


My primary problem is that the code snippet expects the file "test.xls"
to already exist... but I don't want that.

Initially it will be fine to keep the hard-coded pathname and if it
doesn't exist, create it.  Long-term, I'll modify this to have a
user-form to query for a file-name to use for the Excel spreadsheet.

I haven't been able to figure out from any examples, either via links
from here or MSDN or the SDK how to get the file created if it doesn't
already exist.  Once I can figure this out, it's easy to set a flag so
that the code will correctly do .Save vs. .SaveAs

Any suggestions?


6. Insert VBA Code With VBA Code

7. I am new to VBA and am stuck

8. Is absolute security for Excel VBA code possible?

Return to Microsoft OFFICE


Who is online

Users browsing this forum: No registered users and 13 guest