Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    Visual Basic




VBA MODI Automation


I am creating a VBA macro in Excel 2003 which will print out .tif files using Microsoft Office Document Imaging.

I have found and successfully used code which creates a new tif file in MODI and prints this out. However all the code snippets which I have found using the Create method of MODI.Document all either create a new file or open an existing file using the filename as a reference. I need the macro to find the first open instance of MODI and then link to it, without using the filename as a reference, as this is not known.

I have tried the following, neither has worked but I'm guessing I'm on the right lines:


Code:
Dim obj as Object
Set obj = GetObject(,"MODI.Document")
or


Code:
Dim obj as Object
Set obj = GetObject(,"MSPVIEW.Application")
My aim is to connect to MODI and then use the MODI.PrintOut method.

I have spent 2 days now trying to get this working so I pretty desperate and would very very appreciate any help. Thanks.




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
Output To MODI ?
Hello,

I am trying to figure out how to out put a access report to a MODI file. I posted this in the Access VBA area but after 3 days no luck. Not sure if this area might work. I have a button on a form and want it to generate a .mdi file from a access report when you click on it. I dont want anything to pop up just output the report right to the file. I have tried using the code below and either get a corrupte .mdi file or and error saying cant file file. Not sure if this is even the correct direction below. Any help would be great !! Thanks

The Report_Rpt_ACF is the access report. I read that the .create has to be a .mdi or .tiff file so I know thats the problem. Just cant find any info anywhere on how to open a report to use at the source for the output. Thanks again.

Code:


Dim miDoc As MODI.Document

Set miDoc = New MODI.Document
miDoc.Create "Report_Rpt_ACF"
miDoc.SaveAs "C:document1.mdi", miFILE_FORMAT_MDI

Set miDoc = Nothing

How To View Tif With MODI
How can I view a .tif file using the Microsoft Office Document Imaging control? Does any have an example?

Example For Sending Print Job From MODI To Printer
in my code when i print anything it displayed on microsoft office document interface. I want to send the printing job direct to printer without loading MODI.

Programmering The MS Office Doc Imaging (MODI)
I'm trying to build a program to perform scanning, OCR and things like that using the MODI.

I've build in the MODI-viewer in a form and it shows the scanned file perfect. Then I want the user to be able to select a part of the document i the viewer and perform a OCR on it.

I've put the viewer in the right ActionState (3) and the selection is now possible, but I don't seem to be able to perform a OCR on. Mainly because when I ask for the BoundingRect Coordinates I get null-values.

I'm using the GetImageSelection on the viewer object to return a image, for which I want the OCR. The image i selected, because I can use the CopyToClipboard method and insert the selected part in f.x. Word. But when I use the selectableImage.getBoundingRect(pageNum, xLeft, yTop, xRight, yButtom) I get nothing in either parameters. Why?

By the way how is the GetTextSelection used. When I use that on the selected part of the document null is returned.

Thanx
Thomas

MODI Office Document Imaging Control
I am using the ocx of the Microsoft Office Document Imaging Control in a small application the scans documents.

The MODI ocx does not automate the scanning process but has the ability to load a file from memory.

I want to be able to scan a document and load that document in the MODI viewer directly from the scanner but I can't figure out how to do it. I have tried searching for an example and have not come across one. The only ones I have seen load an image from a file not scanner.

Any help is appreciated.

MODI Object Issue With Printing Large Number Of Files
The function below is printing TIFF images using the MODI object. Iím using it in Access to print 500-1000 tiff images at the time. I get the hyperlink to the image from the table and by looping down the recordset passing the links to the function. Problem is that it will pass several hundred links to the function in few seconds and there will be several hundred documents in printing queue waiting to be printed. I donít even want to test this; I know that printer or desktop will run out of memory at some point.


Code:
Public Function PrintTiff(strFileToPrint As String) As Boolean
'Function prints image files.
'Multi-pages documents being separated and printed by individual
'page due to the bug in the PrintOut Method.
'If printed at once, first page being printed in the actual size,
'however following pages being printed in the small size.

Dim modiDoc As MODI.Document
Dim modiTempDoc As MODI.Document
Dim i As Integer

On Error GoTo ErrHndler
Set modiDoc = New MODI.Document
modiDoc.Create strFileToPrint

If modiDoc.Images.Count = 1 Then
modiDoc.PrintOut
Else
For i = 0 To modiDoc.Images.Count - 1
Set modiTempDoc = New MODI.Document
modiTempDoc.Create
modiTempDoc.Images.Add modiDoc.Images(i), Nothing
modiTempDoc.PrintOut
Set modiTempDoc = Nothing
Next
End If
Set modiDoc = Nothing
PrintTiff = True

Exit Function
ErrHndler:
PrintTiff = False
End Function

I need something to slow down the process and after passing 10 links to the function, wait for the minute and continue. I thought I can use function below, but it takes 100 percent of the CPU.


Code:
Public Sub Pause(Duration)
Dim Current As Double
Current = Timer
Do Until Timer - Current >= (Duration / 1000)
DoEvents
Loop
End Sub
Is there a better way of doing this? Or maybe function itself can be modified where before exiting it can check if there is a file pending to be printed then it will wait for a minute and check again. Is there a way to see if there is a file in the printing queue? Thanks for help.

How Can Modify The Uninstallation Process Of A VB Application Like Setup1.vbp Project Modi
Hi,

How can modify the uninstallation process of a VB application like setup1.vbp project modification?

Regards
S. Muhilan

Webbrowser Control Automation And Annoying Pop Ups That Make Automation Diffcult.
Hi,

I am using webbrowser control to automate crawling the internet.

I also have 2 dial up connection as backup.

Sometimes my software has to surf internet address that does not exist, like http://fjsldjfdslfjdlsjflsdjflds

In that case, a window pop up and ask whether I want to connect to the internet using one of the dial up connection.

Looks like webbrowser must have thought that because I couldn't access http://sdflsflsjdsfljdslfjlsdf then internet must be down.

This is a night mare for automation. No body is there to say, no, just move on and access crawl the other sites.

Also sometimes I got message saying that some javascript need to be debugged. Setting internet explorer to have high security (disabling javascript) solves this problem. However, sometimes I stumbled upon url that contain pdf, csv, etc. Then another windows pop up telling me that my security setting disallow me to download this kind of file.

Is there a way so that webbrowser control just "move on" when things go wrong rather than displaying stupid windows?

Webbrowser1.silent=true doesn't help. It helps for some but not others.

So how?

MS Word Automation - How To Prevent Automation Server From Closing
I am using MS Word automation to create a measurement report.

After each measurement a template doc is opened, some text in the doc is replaced by the measurement results and finally the doc is saved under a unique filename. Because it takes some time to open the Word app object, it is done only once at the beginning of the program and closed when the program quits.

So far everything works fine. The Problem is, when the user manually open and close MS Word during my VB app is running, the automation server seems also to be closed and a runtime error occurs when accessing the MS Word object ("The remote server machine does not exist or is unavailable").

How can this be avoided? Is there a way to prevent the automation server from beeing manually closed? Or is there a way to assign my VB app 'it's own' instance of MS Word?

Service && WithEvents SHDocVw Automation - "automation Error" -2147220990 (80040202)
Hi.
I have a VB app that i run from a service (The app run at winsta0\default).
The app runs under the localsystem account.

In my app i have:
Private WithEvents winShell As SHDocVw.ShellWindows

and then in one of the functions:
set winShell = new SHDocVw.ShellWindows
When it came to that set line, i get this error in a popup dialog:
"automation error" -2147220990 (80040202)

Some points:
1)When i run the app not from the service, everything is working fine
2)When i remove the WithEvents, i do not get that error (but as you can understand it worthless without the Events).
3)When the app is not running under localsystem then everything is ok.

The problem is related to the combination of the app that runs under the system account, automation and the WithEvents keyword.

I tried to make the service interactive by going to the service manager, right click properties, and checking that box - it did not solve it.

Any suggestions?
(the app must stay running from the systemaccount - i can not change it)
I run it on XP pro.

Thanks

Service && WithEvents SHDocVw Automation - "automation Error" -2147220990 (80040202)
Hi.
I have a VB app that i run from a service (The app run at winsta0\default).
The app runs under the localsystem account.

In my app i have:
Private WithEvents winShell As SHDocVw.ShellWindows

and then in one of the functions:
set winShell = new SHDocVw.ShellWindows
When it came to that set line, i get this error in a popup dialog:
"automation error" -2147220990 (80040202)

Some points:
1)When i run the app not from the service, everything is working fine
2)When i remove the WithEvents, i do not get that error (but as you can understand it worthless without the Events).
3)When the app is not running under localsystem then everything is ok.

The problem is related to the combination of the app that runs under the system account, automation and the WithEvents keyword.

I tried to make the service interactive by going to the service manager, right click properties, and checking that box - it did not solve it.

Any suggestions?
(the app must stay running from the systemaccount - i can not change it)
I run it on XP pro.

Thanks

VB Automation - How To Check If VB Automation Possible ?
I created a programme that vb automation to autocad and excel.
However my question is if my programme is being used in a computer which dont have either one of autocad or excel. What will happen when i try to contact that software ?

How can I create a query line to ask the computer if its install with autocad or excel?

I worry the programme will hang when i try to execute a command to autocad or excel in the computer which dont have that software.

Thank you.

Pop Automation
I have searched here and can find many smtp automation threads, but no pop automation threads.

I run a very basic alumni site for my old Military Unit. Somehow, the link got associated with a popular Military alumni site and now I am getting quite a few emails a week. I have a mail form on my site where the members of this unit can fill out their information and it emails this to me along with a subject: alumni_information

I know how to write an app that will automatically create an html page based on a few variables. I even know how to automate ftp'ing this page up to my site using vb.

The part I am having problems with is this. I want to use UNIX mail commands (I think they are called smtp commands) and winsock. I have tried to connect to mail.comcast.net to access my pop server. I cannot get this to work. After I get this to work I need to dot he following:

1) Use commands to get all email.
2) Check if any have this subject.
3) If so, get the message body.
4) save this message body to my hd with date/timestamp used as filename.
5) open this file and parse (I can do this in VB)
6) create the new page based on parsed data (I can do this)
7) ftp page (I can do this)

I found a mail client ocx once that had the source code for a full client. I tried to disect the pop portion of this and have it do what I need, but it was just too involved. I think using the unix commands with winsock is much easier. Can anyone get me started with items 1) through 4) above?

Thank you,
Joe

Help With Automation
I need to write an application that can retrive data from a web site in a saveable format and manipulate the web page controls (Automated login basically)

So how would I be able to have my program populate datafields and interact with controls on a website?

How can I have it select certain datafields and save the information?

Should I Use Ole For Automation??
hi
I am looking for suggestions on which method u guys think might be best for opening Word documents from templates and saving the resulting document in a seperate location using VB6.
If ole automation does any one know where i can find a listing of all the possible commands. ie set objWDApp= CreateObject("Word.Application")
and so on
any help gratefully received
Peadar

API Or Automation ?
Hi friends!
Can I use "GetSaveFileName" API to save an application automatically without clicking the "Save" button in the dialog box?

I want to save MS Wrod document with this API automatically i.e if I run my VB application it will identify MS Word and save and close it.Following is the code.The code is compiling and identifying MS Word , but it doesn't save to the directory even if I click the "Yes" botton.
------------------------------------------------------
Dim OFN As openfilename
Dim WinWnd1 as long
Static i As Integer

If (FindWindow("OpusApp", vbNullString)) <> 0 Then
WinWnd1 = FindWindow("OpusApp", vbNullString)
ShowWindow WinWnd1, SW_SHOWNORMAL

OFN.lStructSize = Len(OFName)
OFN.hwndOwner = WinWnd1
OFN.hInstance = App.hInstance
OFN.lpstrFilter = ".doc" + Chr$(0) + "*.doc" + Chr$(0)
OFN.lpstrFile = "Word" & i & ""
OFN.nMaxFile = 255
OFN.lpstrFileTitle = OFName.lpstrFile
OFN.nMaxFileTitle = 255
OFN.nMaxFileTitle = Len(OFName.lpstrFile)
OFN.lpstrInitialDir = "C:Backup"
OFN.lpstrTitle = "Saving..."
OFN.flags = 0

GetSaveFileName OFN
SendKeys "{ENTER}", True
i = i + 1
End if
----------------------------------------------------
Someone told me that Automation is easy to do it. I tried it, but it gives an error of "Run-time error 224, object required". I have used "OpusApp" as the class to identify the object like follows:-
Dim x As Object
Set x = GetObject("", OpusApp)
x.SaveAs "C:BackupWord1.doc"

Can anyone help me please............

Automation
Can someone tell me what automation means in VBA please? Is that like running in a silent mode?

Edit:
Okay, from what I'm reading it's controlling a program from another program. Like ...

Dim xlApp As Excel.Application
Set xlApp = New Excel.Application

Is that all there is too it? Using the xlApp object in say word would be automationn

IE Automation - Vba
Hello XtremeVBTalk,
There are a couple of things I need to understand for automating IE using a Macro/VBScript.
I am a semi-beginner user of vba codes and I only got as far as the codes below as an exercise for IE automations.
Essentially, I would like to do the following:

1. click on a hyperlink on 1st IE window to open 2nd window
2. click on a couple of buttons on the second IE window, close 2nd IE window and move back to the 1st IE window.

(I understand this involves knowing the "handle" / Names of the windows and being able to switch from each other?)

I would be grateful if anyone can assist me on this, many thanks.

regards,
Ed

Please understand that the below is only an exercise

Code:
Function Search_Google()
Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")

IE.Navigate "http://www.google.com" 'load web page google.com

While IE.Busy
DoEvents 'wait until IE is done loading page.
Wend

IE.Document.all("q").Value = "what you want to put in text box"
ie.Document.all("btnG").Click
'clicks the button named "btng" which is google's "google search" button

While ie.Busy
DoEvents 'wait until IE is done loading page.
Wend

End Function

Automation
I haven't programmed VB in a year so I've forgotten next to everything. Anyway, I'm just trying to build a small program that would automate the login process of other applications. So for example it would switch to the other application, type a username in the first textbox, tab to the other textbox and type a password, and finally press ENTER.

How would I go about programming this? Any tutorials available?

Automation
hallo,
ich habe probleme mit einem sortieralgorithmus.
Ich arbeite mit einem excel sheet. In diesem excelsheet gibt es nun Zellen die in einer Spalte B absteigend(unsortiert) aufgereit sind.
Bei diesen Zellen gibt es nun eine spezifikation. sie sind eingeteilt in 3 Gruppen A, B und C.
Die Definition der einzelnen Zelle zu einer gruppe steht in der selben reihe allerings in Spalte A.
Ein anderes VB Prog von mir soll jetzt auf diese Zellen zugreifen(was es genau macht ist jetzt nicht so wichtig da es ja eigentlich um die sortierung geht)
Bisher geht das Programm die Zellen von oben nach unten durch. Die Sortierung sollte nun so funktionieren (šhnlich wie ein Filter), dass das Prog von oben nach unten zuerst alle von A durchgeht dann B und dann C
ich habe das sheet so definiert unter einer public cons
Code:
1:
Public Const sheet1 As String = "sheet1"


so greif ich dann darauf zu:
Code:
1:
Worksheets(sheet1).Cells(sheet1_row + test_nr, sheet_col) <> "")

VB Automation -&gt; I.E.
I need to know how I can call an event from VB to IE and then close the web site.

For example: click on SAVE on the Adobe File -> click yes on SAVE -> close the web browser.

Is there anyway I could do it?

A Bit Of Automation??
I am fairly good at program in visual basic. I ain't no guru but I can get around .

For several days now I have been trying to automate tests on several of my web pages with visual basic. I was wondering if anyone could refer me to a web page where they discuss automation with visual basic or maybe if anyone could tell of a good book they read on automation again wiht visual basic?

I have tried programs that were built specifically toward automation like visual test, winrunner and doctor html . These programs are fine if yoru testing desktops but when it comes to playing with applets, javascript, dhtml, flash or even frames in html they leave alot to be desired!

Well thank you very much for your time and help!

Fraggy

OLE, COM Or Automation
I am integrating my application into MSWord and Excel. I need to merge varying user information, decided at run time, into pre-created merge templates. I have managed to do this but it is extremely slow. Does anybody know of a good book or, better still, a quick way to inteface. Also, when I view a, non merge, document it is very quick. However if I want to view a template it takes a long time. I can see that Access is being loaded, and probably data retrieval takes place, which I don't need when just viewing the template. If Word is already loaded, can I use that version rather than load another copy ?

I have tried to find information on this but every, I mean every, example of using the Word Object shows me how to use the spell checker, I don't want to use the spell checker. Help Please.

Thanks, in anticipation

OLE Automation
Since the minimum search criteria is 4 char's, and OLE is only 3, nothing would come back.

This is my dilema.

I have a program "mplayer.exe" - NO not windowsmedia player

and I want to embed that into my form, and pass it a file to play so I can control where it is on the screen, and maybe put a graphic around the video (home made tv skin stuff)

However, I cannot get the mplayer.exe into the form and tell it to play with an ole.activate or ole.setfocus etc.

please help

SQL In Automation
Hi,

I have a database file in CSV format which generates by a SCADA program every 3 minutes.

I want to automate my Ms SQL script to read in the data every few minutes. But not sure how.....

Firstly, do I use Trigger or Stored Procedure to write the script.
and what do I need to do to place the script in automation.

thxs
Jason

IE Automation - Vba
Hello VB Forums,

I have been trying to get some help regarding this topic from other forums they have proven to be very unhelpful.
I shouldnt think this will be too difficult for any experienced programmer so I hope I am able to find some help on this forum.

There are a couple of things I need to understand for automating IE using a Macro/VBScript.
I am a semi-beginner user of vba codes and I only got as far as the codes below as an exercise for IE automations.
Essentially, I would like to do the following:

1. click on a hyperlink on 1st IE window to open 2nd window
2. click on a couple of buttons on the second IE window, close 2nd IE window and move back to the 1st IE window.

(I understand this involves knowing the "handle" / Names of the windows and being able to switch from each other?)

I would be grateful if anyone can assist me on this, many thanks.

regards,
Ed

Please understand that the below is only an exercise


Code:

Sub Search_Google()
Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")

IE.Navigate "http://www.google.com" 'load web page google.com

While IE.Busy
DoEvents 'wait until IE is done loading page.
Wend

IE.Document.all("q").Value = "what you want to put in text box"
ie.Document.all("btnG").Click
'clicks the button named "btng" which is google's "google search" button

While ie.Busy
DoEvents 'wait until IE is done loading page.
Wend

End Sub

VSS Automation -- Get
I'm just getting started with VB, so please forgive my lack of knowledge. I need to create a tool using VSS automation to perform gets on specific version of VSS files. Would this be possible?

Regarding Automation
Hi,
Is there anyway to automate a flash application using VB?

Thanks
vivek

IE Automation.. DOM
I am automating Internet Explorer using VB in order to download a file. I cannot use the DownloadFile function becuase I have to simulate various button clicks and logins before I can get the link to the proper file. When I finally reach the page, I have to emulate clicking a submit button on a form to get the "real" document I want. The problem is the real document is spawed in a new instance of IE, different from the one I am automating.

How can I "Pickup" automation on an IE instance that was created from an instance I created originally?

Web Automation
i am working on automating populating a web page with values from a database - any suggestions on how to resolve this would be appreciated

=======================================
==== THE PROBLEM:
=======================================

i can successfully navigate to the page using
wb.Navigate2 <some_page_with_frames>
but when i attempt to focus on known elements on the visible page, the "set hInp = hDoc.getElementById(element_id)" command results in "hInp = nothing" because i am focusing on the parent frame.... i've tried numerous ways to resolve this but no success

=======================================
==== the general structure of the project is this:
=======================================

wb = webbrowser control
hDoc = mshtml.HTMLDocument
hInp = mshtml.HTMLInputElement
.
wb.Navigate2 <some_page_with_frames>
.
Set hInp = hDoc.getElementById(element_id)
hInp.focus
hInp.value = pvalue

=======================================
==== web page structure:
=======================================

<html>
<head>
<title>sometitle</title>
</head>
<frameset rows="20,*" border="0" framespacing="0" cols="*">
<frame name="navigation_frame" src="locationx" scrolling="no" noresize frameborder="NO">
<frame name="main_frame" src="locationx" noresize>
</frameset>
<noframes>
</noframes>
</html>

OLE Automation With VB6
How can I pass a string variable to an MSAccess macro when I activate the macro using VB6?

eg:

Dim objAccess As Object
Dim Str_Macro As String
Str_Macro = "Weekly_report"

Set objAccess = CreateObject("Access.Application")


objAccess.OpencurrentDatabase Database, True
objAccess.Visible = True
objAccess.docmd.runmacro Str_Macro

End Sub

IE Automation Via DLL
A few years ago I made a DLL that automated Internet Explorer as a work around to send email. I had an ASP page that sent email using CDONTS. I would call my DLL and have it pass parameters via the querystring to the ASP page from reference to shdocvw.dll Then that page sent email and all was good.

Now, I am doing just about the same thing to use a PDF printer to make a PDF of a web page, but I am getting some strange errors. Sometimes I get an Automation Error when I tell IE to navigate to the page. Here is the really stange part, it only happens sometimes. If I get rid of my DLL and run the project in the VB IDE it works fine everytime. But, it only works compiled if I run it from the actual user that will be calling the DLL. What I mean is, I have to make like a VBS file to call the DLL logged in as the user that will be doing the calling when it is called from an ASP page. I am using the DLL in COM+ so that I can have a different user other than the IUSR_ account run it. For my purposes the user is COMPlusUser. I login to the server as this user. Then run the .vbs file which just calls the DLL exactly like the .asp page would. Then I log off the server, and run the asp page from a remote computer. Everything is fine. However, if I reboot the server and try to run the .asp page from anywhere, a remote computer or even the server, I get an Automation error in the routine that I use to navigate the IE object to a web page.

This is driving me crazy, my first thought is to run that .vbs file in the task scheduler on windows startup, but I would rather IE just work

IE Automation
Hello,

What I am trying to do is automate a login to a website for users, so they click a button and then it takes them to the webpage, automatically logs them in and puts them on the page they need.

However, I am having trouble with the login part. After I click the link a Popup box shows up and it wants me to enter the username and password into the popup box. Does anyone know how to get control of the popup box so that I can enter the values and hit okay?

Thanks,

Ryan

Ole Automation
Hello Friends.,

When I use Ole automation and use get object to open a document file , it does not work in all the machines.

∑I used Getobject to create a new document at run time
∑I selected Microsoft word 9.0 object library from the references.
∑So only if an other system has this same version 9.0 , it works.
∑Can I create a cab file and select msword9.olb (the corresponding file for Microsoft word 9.0 object library) to the files needed for installation so that every thing works perfect irrespective of the machines.
∑Please help me out.

Thank you
shoba

Anyone Here Use Automation???
Anyone use automation in their apps/
Any examples?

Woka

A Bit Of Automation?
I am fairly good at program in visual basic. I ain't no guru but I can get around .

For several days now I have been trying to automate tests on several of my web pages with visual basic. I was wondering if anyone could refer me to a web page where they discuss automation with visual basic or maybe if anyone could tell of a good book they read on automation again wiht visual basic?

I have tried programs that were built specifically toward automation like visual test, winrunner and doctor html . These programs are fine if yoru testing desktops but when it comes to playing with applets, javascript, dhtml, flash or even frames in html they leave alot to be desired!

Well thank you very much for your time and help!

Fraggy

)

PDF Automation
I would like to know if it is possible to create a table of contents in a PDF file using Visual Basic. I have a DB that prints reports and the reports are saved in PDF files, there is a lot of files now and i would like to create a VB program that will i would create the table of contents as each new file is made.

Second if this is possible, how would i go about doing this? Where can i go to find additional information on how to do this?

Thanks to all that reply.

OLE Automation
Whats OLE Automation???

Automation. .
Hi vb experts,
Can anybody give me ideas about how to automate the process of hotcash lotto game on the web. . .so that the application plays the game every hour on its own. . without my interfearence. .

thanks. .
fanatic lotto player. . .

MSN Automation
I was just wondering how I can make my app automate MSN messanger. Kind of like a chat bot.


Thanks ahead,
The Unknown

Automation
VB Code:
objExcel.Selection.Characters(Start:=1, length:=9).Font.FontStyle = "Bold Italic"
This code works if Excel is in English... but it needs to be:
VB Code:
objExcel.Selection.Characters(Start:=1, length:=9).Font.FontStyle = "Negrita Cursiva"
Does anybody has a wat to work around this, regardless of the Excel's language?

Automation
When I try to add a components, the OCX I get a Automation error. What gives?????????

Automation
Hey all,
I am currently writing an app that will take an existing "setup.exe" for a particular software and automate the installation process with little to no user input. Basically I am trying to send well timed keystrokes in order to so that user need not even be there during the installation. I tried writing this in vbScript but I was not able to time the keystrokes without using the sleep(intTime) method. I could do it this way and just estimate the amount of time in between each successive keystroke but each computer that this may be running on may not be the same. Thus, (finally) my question is- Does anyone know of a way in which I can time the keystrokes independent of realtime in either vb or vbscript?

thanks shaun

Automation Through API?
Hi,

I have a large and tedious task I need to complete. It goes as follows:

I have about 1200 folders in a directory on my computer. Each of these folders contains numerous files. I need to create a seperate zip file for each of these 1200 folders. I am using WinZip to create the zip files.

However, as you can probably guess, this is extremely time consuming doing this manually 1 by 1. I would like to automate it with VB if possible.

My thought is that I could some how call WinZip, add the files in a particular folder to the zip, and save the zip with a particular name and do it all over again for each of the 1200 folders.

Any ideas or examples on how to do this would be extremely appreciated..

Dan

Automation
i wil make wish automation a link to words. That i can But i want to make't so that my vb6.0 prog can put informatie to this words doc. every time i want that so long my vb prog is working.

i cant make that, ervery time i get a error. i cant find the link too my words document.

OLE Automation
Hello

I'd like to open inbox folder of outlook and print it. How did y do?
Thanks

OLE Automation
Very specific question this:

In 2 weeks I am to automate from VB6 a terminal emulator called Attachment. I have never used it before (but have lots of experience with other emulatore such as Reflections etc). Has anyone out there used this program before so I can start a thread of questions?

First to answer wins a coach trip to Tamworth

Automation- How?
i have never written a automation bot or program.. but finally i have to

whats the best way to do this?

this bot/program is going to transfer info from one access table to another...
and i believe a good way is to schedule this with windows scheduler (we are running NT4)

if anyone can direct me to a good tutorial
i would greatly appreciate it
thank you

Ftp && Automation
Hi every 1

I' attempting to automate a program I've written but I've never covered anything like this before.
My program picks up a text file reads each line, splits the line using commas as delimiters andthen inserts the substrings into fields in my database - everything fine up to this point. The problem is, I tested the program by picking up files from a local directory on my PC, but I'm required to retrieve the files in practice from a private ftp site ( with a username and password). I've got various examples from text books but I can't get anything to work.

ie
Inet1,OpenURL("http://www.url.co.uk")

and

With Inet1
.URL = "ftp://www.someFTPsite.com"
.UserName = "John Smith"
.Password = "somePASSword"
.Execute , "DIR"
.Execute , "CLOSE"
End With

The problem is, my books ae very brief regarding ftp controls (4-5 Pages), and I'm at bit of a loss. Can anyone point me in the right direction?

Cheers 'n' beers

Skeen

Copyright © 2005-08 www.BigResource.com, All rights reserved