Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transferring Reports - HTML V/S Word/Excel
Message
From
05/07/1999 04:09:10
Vinod Parwani
United Creations L.L.C.
Ad-Dulayl, Jordan
 
 
To
04/07/1999 11:18:17
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00237139
Message ID:
00237418
Views:
11
>>Pls note that as my code is currently creating files of office 95, it is creating word.basic object...
>>
>>but when I try to run the same program in Office 97, it starts giving error...
>>
>
>What code is causing an error, and what is the error message? In my experience, WordBasic has been 100% compatible with Office97...

i guess U r right !! Very sorry... i got mixed up in 2 projects... It was not word, it was Excel...(actually i'm transferring in both depending on req.)..

I don't remember the exact error message, but this is the code which i'm trying..(i'm not posting the whole code, but this is how i was writing..)

***************

x=crea("Excel.Sheet")

if x.application.version="8" && This was added afterwards when i got the err

Wait window "Cannot Create Excel sheet in Office 97"
release x
return

Endif

Wait Window "Setting Headings & Paper size..." Nowait

WITH X.PageSetup

.PaperSize = 9
.Orientation = 2
.FitToPagesWide = 1
.FitToPagesTall = 10
.Zoom=.f.
.LeftHeader = '&"Arial,Bold"&14'+allt(uppe(config->heading))+;
' ALPINE PRODUCTION CALENDAR'
.RightHeader = '&"Arial,Bold"&14UPDATED ON &D'
.centerheader=''
.CenterFooter="Page &P of &N"
.centerhorizontally=.t.
.centervertically=.t.
.printTitleRows="$1:$2"
.PrintGridlines=.f.

ENDWITH
Previous
Reply
Map
View

Click here to load this message in the networking platform