Help with WriteExcel

Getting started -basics for starting with WinTask

Help with WriteExcel

Postby Dowell on Tue Jan 22, 2013 10:15 am

Hi,
'I NEED THE WRITEEXCEL TO WRITE "NOT FOUND" as below:

Pause 3 secs until
Bitmap("P:\Scripts\VERIFICADOR\no.bmp")
InWindow("IEXPLORE.EXE|Internet Explorer_Server|Sistema - Windows Internet Explorer|1",1)
PauseTrue
msgbox ("Processo")
WriteExcel("verifxlsx", "B"+str$(i+1), "NOT FOUND")
EndPause

What is the syntax please?
Dowell
 
Posts: 19
Joined: Sun Jun 19, 2005 7:02 pm

Re: Help with WriteExcel

Postby TechSupport on Thu Jan 24, 2013 9:42 am

Hello,

WriteExcel can only write an array, so you need to put the text in the first element of an array, so:
Dim data$(2) 'at the very beginning of the script

data$(0)="NOT FOUND"
Pause 3 secs until
Bitmap("P:\Scripts\VERIFICADOR\no.bmp")
InWindow("IEXPLORE.EXE|Internet Explorer_Server|Sistema - Windows Internet Explorer|1",1)
PauseTrue
msgbox ("Processo")
WriteExcel("verifxlsx", "B"+str$(i+1), data$())
EndPause

Best regards.
WinTask Tech Support
TechSupport
 
Posts: 805
Joined: Thu Nov 16, 2006 9:58 am


Return to Getting started

Who is online

Users browsing this forum: No registered users and 1 guest

cron