Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Capture Tabbed Pages' Names from Excel
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Database:
Visual FoxPro
Divers
Thread ID:
01428658
Message ID:
01428670
Vues:
31
Hi Peter,

Well, in regard to the Southwest Fox Conference, unless I can dig up some money I don't need, probably not. I have been unemployed for 11 months now and have only had a few very short gigs since November 14th of last year. The fact is, things have turned upside down financially for not only myself but a lot of other VFP developers throughout Canada and the United States. I think that the economy has done a rough job on many of us.

I can see that I ought to have gone into C#.NET and maybe ColdFusion a bit sooner than now. These are my two choices for coding. I like C#, although it is a little cryptic. I also like web development using ColdFusion, which is like powerful HTML, although it is called CFML. My problem is that I liked VFP so much that it seemed that I was betraying myself to move to anything else.

I actually thought I could continue to find work as a VFP Developer until past 62 years of age. I am closing in this month on 56 years of age, so I guess I missed my goal by a few years, eh? Can a 56-year old retrain? I think so. Will employers hire a 56-year old person? Not many will do that in my own opinion. One employer in Arizona actually outright asked me how old I was. Time to dye the grey hairs? Maybe.

I was getting one error which states

CLASS definition Excel.Application does not exist

I found that I used three p's in the word 'oExcel.Application' rather than two. I fixed it and it works fine.

Thank you!

Cecil

>>I am thinking that at least one person has done the following:
>>
>>I want to capture the names of each tabbed page in an Excel file which contains more than one worksheet. I suppose you could say that each worksheet is named accordign to its tabbed page. That is what I want to capture. Once I capture that data into an array, I will use it in a dropdown combobox on a form.
>>
>>I do not have much experience with Microsoft Office Automation, so this one is a bit out of my league.
>>
>>Thanks,
>>
>>Cecil

>local oExcel as Excel.Application
>oExcel= create("Excel.Application")
>oW = oExcel.Workbooks.Open("c:\...\....\filename.xls")
>for I = oExcel.Worksheets.Count
>? oExcel.worksheets[m.I].name
>endfor

>I hope this helps.

>Am I going to see you next week in Phoenix??
>Peter
>Peter Cortiel
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform