Experiences of VFP 8.0 running in Vista

Good day everybody,

I have a few applications developed using VFP 8.0 running on XP.

My company is going to change from XP to Vista, therefore I have to make
sure that my applications still work well in Vista.

I have checked the discussion thread and found a posting that said there are
few problems with some of the Word and Excel Automation commands.

I will appreciate if you can share with me your experience of other arising
problems of VFP8.0 running on Vista and your solutions.
This will enable me to prepare and seek to understand with solution before
the company get Vista installed in our PCs which I may have not enough time
for troubleshooting.

I hope to hear and learn from you. Thank you.

Best regards,
Julie

TonySper
Mon Mar 03 18:31:01 CST 2008

Julie,
Yes I have had some minor problems with the automation when running VFP8 on
my Vista OS. The problem I had was that when you start up Word it ends up on
the task bar and then you have to click on the task bar to bring it up. The
way I cured this was as follows
IF OS(3) = '6' && OS IS VISTA
oWORD = CREATEOBJECT('Word.Application')
WITH oWORD
.APPLICATION.VISIBLE = .T.
.DOCUMENTS.OPEN(MYLOCATION+'\'+M.C_FILE_NUM+'.DOC')
.APPLICATION.WINDOWSTATE = 2
.APPLICATION.WINDOWSTATE = 0
ENDWITH
ELSE
oWord = CREATEOBJECT("Word.Application")
oDocument = oWord.Documents.OPEN(MYLOCATION+'\'+C_FILE_NUM+'.DOC')
WITH oWord
.Application.WindowState = 1
.Application.Visible = .T.
ENDWITH
ENDIF

The first case was using the program in Vista. The Else was using the
program in XP. You can use the first case for both Vista and XP but if you
use the first case in XP you will see the word file blinking twice on the
screen. No problem though just one client did not like the blinking of word
twice. Some people are picky. Also Word is picky on the way you set up the
With Word sequence.

TonySper


"Julie" <Julie@discussions.microsoft.com> wrote in message
news:4DAC68FF-7576-450E-9795-1CFCA5C5CA69@microsoft.com...
> Good day everybody,
>
> I have a few applications developed using VFP 8.0 running on XP.
>
> My company is going to change from XP to Vista, therefore I have to make
> sure that my applications still work well in Vista.
>
> I have checked the discussion thread and found a posting that said there
> are
> few problems with some of the Word and Excel Automation commands.
>
> I will appreciate if you can share with me your experience of other
> arising
> problems of VFP8.0 running on Vista and your solutions.
> This will enable me to prepare and seek to understand with solution before
> the company get Vista installed in our PCs which I may have not enough
> time
> for troubleshooting.
>
> I hope to hear and learn from you. Thank you.
>
> Best regards,
> Julie
>

RGBean
Mon Mar 03 18:28:24 CST 2008

Julie,
You may want to check out Doug Hennig's FREE Advisor articles
http://my.advisor.com/doc/18897 and http://my.advisor.com/doc/19195. While
they address VFP 9.0 SP1 (and SP2) under Vista, most everything would apply
to VFP 8. SP1.

Rick

"Julie" <Julie@discussions.microsoft.com> wrote in message
news:4DAC68FF-7576-450E-9795-1CFCA5C5CA69@microsoft.com...
> Good day everybody,
>
> I have a few applications developed using VFP 8.0 running on XP.
>
> My company is going to change from XP to Vista, therefore I have to make
> sure that my applications still work well in Vista.
>
> I have checked the discussion thread and found a posting that said there
> are
> few problems with some of the Word and Excel Automation commands.
>
> I will appreciate if you can share with me your experience of other
> arising
> problems of VFP8.0 running on Vista and your solutions.
> This will enable me to prepare and seek to understand with solution before
> the company get Vista installed in our PCs which I may have not enough
> time
> for troubleshooting.
>
> I hope to hear and learn from you. Thank you.
>
> Best regards,
> Julie
>

TonySper
Mon Mar 03 18:40:38 CST 2008

RGBean,
Checked out your two articles and failed to see any reference to using VFP
automation with Vista??? Otherwise nice place to check out other problems
that I may run into.
TonySper

"RGBean" <rgbean@NOSPAMmelange-inc.com> wrote in message
news:0571C8C7-CB59-4011-9963-C2DE40C2CC2D@microsoft.com...
> Julie,
> You may want to check out Doug Hennig's FREE Advisor articles
> http://my.advisor.com/doc/18897 and http://my.advisor.com/doc/19195. While
> they address VFP 9.0 SP1 (and SP2) under Vista, most everything would
> apply to VFP 8. SP1.
>
> Rick
>
> "Julie" <Julie@discussions.microsoft.com> wrote in message
> news:4DAC68FF-7576-450E-9795-1CFCA5C5CA69@microsoft.com...
>> Good day everybody,
>>
>> I have a few applications developed using VFP 8.0 running on XP.
>>
>> My company is going to change from XP to Vista, therefore I have to make
>> sure that my applications still work well in Vista.
>>
>> I have checked the discussion thread and found a posting that said there
>> are
>> few problems with some of the Word and Excel Automation commands.
>>
>> I will appreciate if you can share with me your experience of other
>> arising
>> problems of VFP8.0 running on Vista and your solutions.
>> This will enable me to prepare and seek to understand with solution
>> before
>> the company get Vista installed in our PCs which I may have not enough
>> time
>> for troubleshooting.
>>
>> I hope to hear and learn from you. Thank you.
>>
>> Best regards,
>> Julie
>>
>

Julie
Tue Mar 04 23:27:07 CST 2008

Dear TonySper,

Yes, I remember reading your posting dated Dec 2007.
Yes, I do use the same command to open Word application from my VFP
application.
In fact, I also open Excel and Powerpoint too.

Thank you very much for sharing your coding with me. It will save me a lot
of time looking for solution.

I wonder will opening of Excel and Powerpoint application will have the same
problem and solve similar way?

Hope to hear from you again.

Have a nice day.

Best regards,
Julie

TonySper
Wed Mar 05 13:08:40 CST 2008

Julie,
I could not come up with a comprimise between XP and VISA..
Excel is strange in the way it acts. Seems to even stay running when you
close it at times.
The following code worked for me in both XP and VISTA
.
* GET_excel
* WILL OPEN MICROSOFT EXCEL FILE USING DEFAULT LOCATION OF EXCEL.
* FADR is the exact location and name of the file like FADR =
"C:\FOLDER\FILE.XLS"

oEXCEL = CREATEOBJECT("EXCEL.APPLICATION")
oEXCEL.Application.Visible=.T.
oWORKBOOK=oEXCEL.Workbooks.Open(FADR)
oWORKBOOK.Windows[1].Activate()
oEXCEL.Application.WindowState = 2
oEXCEL.Application.WindowState = 1

TonySper




"Julie" <Julie@discussions.microsoft.com> wrote in message
news:11F60CF8-4C23-4132-8E9F-4A1310FD4CAE@microsoft.com...
> Dear TonySper,
>
> Yes, I remember reading your posting dated Dec 2007.
> Yes, I do use the same command to open Word application from my VFP
> application.
> In fact, I also open Excel and Powerpoint too.
>
> Thank you very much for sharing your coding with me. It will save me a lot
> of time looking for solution.
>
> I wonder will opening of Excel and Powerpoint application will have the
> same
> problem and solve similar way?
>
> Hope to hear from you again.
>
> Have a nice day.
>
> Best regards,
> Julie
>
>

Julie
Wed Mar 05 17:18:04 CST 2008

Thanks again TonySper, your codes will be very helpful to me and to the
others in this group.

Have you heard or experienced any other problem beside Word/Excel automation?

I wish I can get Vista in my PC as soon as possible so that I can start
testing and troubleshoot. But have to wait for company to purchase the
software.

Hope to hear from you again.

Have a great day.

Best regards,
Julie

TonySper
Wed Mar 05 17:45:10 CST 2008

Julie,
I have not used Power Point in XP or VISA so can't comment on it. The only
other thing I ran into was in running XCOPY using a variable. I had to put
quotes around the macro in order to get it to work.
TOBACK = ALLTRIM(M.BACKUPTO)
FROMBACK = ALLTRIM(M.BACKUPFROM)

RUN XCOPY "&FROMBACK" "&TOBACK" /E/Y/S/V/I/R/K

MESSAGEBOX('PI FILES BACKED UP TO '+TOBACK,0,'BACK UP')

I have 10 Clients using my program developed in VFP8 on their VISTA systems
and have not heard of any other problems as yet.
Tony


"Julie" <Julie@discussions.microsoft.com> wrote in message
news:86B74EF4-64B7-4A77-A81A-540EF2C9A994@microsoft.com...
> Thanks again TonySper, your codes will be very helpful to me and to the
> others in this group.
>
> Have you heard or experienced any other problem beside Word/Excel
> automation?
>
> I wish I can get Vista in my PC as soon as possible so that I can start
> testing and troubleshoot. But have to wait for company to purchase the
> software.
>
> Hope to hear from you again.
>
> Have a great day.
>
> Best regards,
> Julie
>

Julie
Thu Mar 06 03:02:02 CST 2008

Thanks again, TonySper.

No, I do not use XCOPY in my application. Lucky me ;-)

Best regards,
Julie

Gene
Thu Mar 06 16:35:31 CST 2008

Julie <Julie@discussions.microsoft.com> wrote:

>Thanks again, TonySper.
>
>No, I do not use XCOPY in my application. Lucky me ;-)

His problem was likely with filenames containing spaces. You
might have that one at some point.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.

Julie
Sun Mar 09 18:08:01 CDT 2008

Thanks, Gene for pointing this out to me.

Best regards,
Julie

"Gene Wirchenko" wrote:

> Julie <Julie@discussions.microsoft.com> wrote:
>
> >Thanks again, TonySper.
> >
> >No, I do not use XCOPY in my application. Lucky me ;-)
>
> His problem was likely with filenames containing spaces. You
> might have that one at some point.
>
> Sincerely,
>
> Gene Wirchenko
>
> Computerese Irregular Verb Conjugation:
> I have preferences.
> You have biases.
> He/She has prejudices.
>