Userform with a scan document function

[chichaspowa]

Hi everyone,

I wanna have a userform with 2 buttons and a textbox one of the buttons would prompt the user to insert document in scanner and by clicking go would scan the document and automatically save under the value thats in the textbox in jpg.

then the other button would open the file that was saved.

I think i would have to use a cmdtwain or something in order to do this.

Would it be possible if someone could help me?

Thanks

 

[Andrew Poulsom]

This might help you:

http://lmik.sweb.cz/

 

[chichaspowa]

thanks andrew will have a look

 

[chichaspowa]

hi andrew,

i inserted that module into excel, and created a button with the following code

Private Sub CommandButton11_Click()
Dim lRtn As Long
lRtn = mdlTwain.TransferWithoutUI(200, GREY, 0, 0, 0, 0, _
 ChequeBox.Value & ".bmp")

End Sub

the document wont scan and excel justs blocks.. can u help me out on this please, im struggling here for the past 24 hours.

Thanks

 

[Andrew Poulsom]

I know as much about it as you do, but did you select a data source first (PopupSelectSourceDialog).