Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Ferenc Richard
  Where is Ferenc Richard?
 warsaw
 Poland
 Ferenc Richard
 To: Yuri Rubinov
  Where is Yuri Rubinov?
 Philadelphia
 Pennsylvania - United States
 Yuri Rubinov
 Tags
Subject: RE: Printing HTML document
Thread ID: 232596 Message ID: 232873 # Views: 22 # Ratings: 0
Version: Visual FoxPro 9 Category: Reports and Printers
Date: Friday, June 26, 2009 4:37:26 PM         
   


> > I have another problem with HTML documents.
> > Before printing these documents I have to save them in another directory.
> > I found in Your posts pieces of code related to this problem.
> > I wrote and executed the following code:
> >
> > lcURL="d:\xml\test1.html"
> > bfile="d:\xml\tempor.html"
> > oIE = CreateObject("InternetExplorer.Application")
> > oIE.Visible = .F.
> > oIE.navigate(lcURL)
> > LOCAL err
> > err = 0
> > t0 = SECONDS()
> > DO WHILE oIE.busy OR oIE.readystate != 4
> > WAIT WINDOW TIME 1.0 ""
> > IF SECONDS() - t0 > 60 && loading limited to 60 seconds..adapt
> > err = 1
> > EXIT
> > ENDIF
> > ENDDO
> > IF err = 1
> > = MESSAGEBOX("Connection problem", 16)
> > ELSE
> > oIE.Execwb(4,2,bfile,NULL) && save as html
> > ENDIF
> > oie = NULL
> > RELEASE oIE
> >
> > Unfortunately, the program stopped at the following instruction:
> > oIE.Execwb(4,2,bfile,NULL)
> > and at exiting the program another message appeared:
> > "Cannot continue, as another is used. Press "switch to" to activate the used programm
> > and solve the problem" (this is the translation from Polish version of FOX so it may be
> > not fully accurate)
> >
> > I would appreciate your help.
> > Best regards
> >
>
> I am not sure that I understand what you are doing. As I can see from your code, you copy html file from one location on your network drive to another location inside the network. Then what is a purpose of using oIE ?
> Why do not you use just plain COPY FILE foxpro command?
>
> In any case, there is no native way to bypass the user dialog with OIE when SAVEAS. You may use external exe with timer to get the window "Saveas HTML document", and send keys there.
> You may also try another approach without oie class in http://support.microsoft.com/default.aspx?scid=174524
> You may use MS Word instead, etc...
>
> Best Wishes,
>
> Yuri Rubinov


Dear Yuri,

I used lcURL="d:\xml\test1.html" in my code as a testing example. In production mode I will use lcURL as addresses of HTML documents from different network locations.
And therefore I have to use oIE to copy HTML documents in one directory on my server.

Best regards



COMPLETE THREAD
Printing HTML document Posted by Ferenc Richard @ 6/24/2009 4:40:00 PM
RE: Printing HTML document Posted by Bilal Budhani @ 6/24/2009 5:08:08 PM
RE: Printing HTML document Posted by Yuri Rubinov @ 6/24/2009 5:44:19 PM
RE: Printing HTML document Posted by Ferenc Richard @ 6/26/2009 3:28:23 PM
RE: Printing HTML document Posted by Yuri Rubinov @ 6/26/2009 3:40:17 PM
RE: Printing HTML document Posted by Ferenc Richard @ 6/26/2009 4:37:26 PM
RE: Printing HTML document Posted by Yuri Rubinov @ 6/26/2009 5:03:34 PM
RE: Printing HTML document Posted by Yuri Rubinov @ 6/26/2009 5:33:35 PM