Import UTF-8 text from Excel

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Exchange Fox
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Intermittent Error 12 - Variable Not Found I have a situation where I am intermittently getting Error 12's trapped to my application (VFP7 based). The code path is something like the following: In my form: snparptr = 0 =gnssadd(,,,,) In gnssadd the following code is executed: =gnaddrec() REPLACE fddate WITH DATE(), ; fcsnaptime WITH TIME(), ; fnparent WITH snparptr, ; fccancel WITH vccancel, ; fctable WITH lctable, ; fcaction WITH vcaction, ; fnrecno WITH lnrecno, ; fcprompt WITH vcprompt SAVE TO MEMO fmdata ALL LIKE f* The gnaddrec either adds a new record to a table or reuses a deleted record. The error 12 error nominates the snparptr as the variable that is not found I cannot see a code path were the snparptr variable is disposed of. The problem is very intermittent and in most cases once the error has been received you can re-enter the program and execute the same function and have it work fine. Is there some resource that is being depleted that is causing this error? or any suggestions of another cause? thanks pete Tag: Import UTF-8 text from Excel Tag: 231428
  - 2
    - eReports on vfp6 untracable error Using DBX tech eReports, we have a report to pdf conversion that works fine in the IDE and locally compiled but returns a code 124 on a clients system running under terminal services. the oReports.ErrorLog seems not to be returning a string any help to resolve this would be appreciated John Tag: Import UTF-8 text from Excel Tag: 231426
  - 3
    - do work intellisense , form , with , endWith This is a multi-part message in MIME format. ------=_NextPart_000_00B0_01C76FB5.AC335F00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all i would like to have intellisense for my form, With the operator With = EndWith i would like to have my custom Method or Custom Property. With ThisForm as Form of G_RUE.SCX EndWith it's doesn't work , have you an idea ? thank's=20 Olivier ------=_NextPart_000_00B0_01C76FB5.AC335F00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.3059" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><STRONG><FONT face=3DArial color=3D#000080 size=3D2>Hi = all</FONT></STRONG></DIV> <DIV><STRONG><FONT face=3DArial color=3D#000080 = size=3D2></FONT></STRONG> </DIV> <DIV><STRONG><FONT face=3DArial color=3D#000080 size=3D2>i would like to = have=20 intellisense for my form, With the operator With = EndWith</FONT></STRONG></DIV> <DIV><STRONG><FONT face=3DArial color=3D#000080 size=3D2>i would like to = have my=20 custom Method or Custom Property.</FONT></STRONG></DIV> <DIV> <DIV><FONT face=3D"Courier New" color=3D#0000ff size=3D2><BR>With = ThisForm as Form of=20 </FONT><FONT face=3D"Courier New" size=3D2>G_RUE.SCX</FONT></DIV> <DIV> <P><FONT face=3D"Courier New" size=3D2>EndWith</FONT></P> <P><FONT face=3D"Courier New" size=3D2><STRONG><FONT face=3DArial = color=3D#000080>it's=20 doesn't work , have you an idea ?<BR><BR>thank's=20 <BR></FONT></STRONG></FONT><STRONG><FONT face=3DArial color=3D#000080=20 size=3D2>Olivier</FONT><FONT=20 face=3D"Courier New"></P></FONT></STRONG></DIV></DIV></BODY></HTML> ------=_NextPart_000_00B0_01C76FB5.AC335F00-- Tag: Import UTF-8 text from Excel Tag: 231416
  - 4
    - vfp9 speed issue group, our app has several screens with hundreds of objects. They open instantaneously in vfp6 but they take over 10 seconds in vfp9, making 9 totally useless for us. Has anyone come across this type of behavior? We use vfp9sp1. Wade Tag: Import UTF-8 text from Excel Tag: 231410
  - 5
    - Active Directory User name and Password How can I read the user name and password from Active Directory? in other words how can I authenticate a user through Active Directory? Thanks HME Tag: Import UTF-8 text from Excel Tag: 231406
  - 6
    - print dbf file How do i print dbf file Tag: Import UTF-8 text from Excel Tag: 231382
  - 7
    - Which Tags Are Used? Hello and thanks for the help. Is there any data in the CDX file that would indicate that last time an index tag was used? I have a table with a lot of tags some of which I sure are never used. I can search the code but that doesn't tell me which ones might have been created to speed up an SQL query. Is there any index tag usage data available? Thanks, Jeff Tag: Import UTF-8 text from Excel Tag: 231367
  - 8
    - Fox Programmer .... Need Jobs Sir, My name is Tommy from Thailand. With my Visual FoxPro experience more than 6 years. I need more jobs. Who have jobs for me, feel free to contact me anytime Thanks Tag: Import UTF-8 text from Excel Tag: 231366
  - 9
    - Check to see if SQL table has been updated by another user Hi... What's the quickest and simplest way to check if a row has been changed (by another user) on a remote SQL table? Obviously TABLEUPDATE returns .F. if it encounters and error but it would be better to 'test' the condition before even attempting to perform the update. Any help would be much appreciated. Tag: Import UTF-8 text from Excel Tag: 231364
  - 10
    - buffering select 0 use tablea shared select tablea cursorsetprop("buffering",4) set filter to type="A" select use tablea again shared alias tableb set filter to type="B" * 1. is the following necessary? select tableb cursorsetprop("buffering",4) ... ... show form to edit these values ... ... * 2. if I tableupdate() tablea, * will tableb be tableupdated() as well? 3. Any other things I need to remember? -- iTech Consulting Services Limited Expert of ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852)2325 3883 Fax: (852)2325 8288 Tag: Import UTF-8 text from Excel Tag: 231355
  - 11
    - help, cash denomination.... hi experts, anybody can give me some example that of cash denomination, like for example, the given is 1525.75 and the output would be.... 1000 - 1 500 - 1 100 - 0 50 - 1 20 - 1 5 - 1 .50 - 1 .25 - 1 thanks in advance.... Tag: Import UTF-8 text from Excel Tag: 231353
  - 12
    - Vista and Elevation Hello all! I have been working for 2 days trying to figure out how to change my application (written in VFP9) to work with Vista. The first objective is writting to the registry. The way our application works... the first time you launch it, it asks for a Code. The user enters this code and the program saves it to the registry under HKEY_LOCAL_MACHINE. This works great under XP. This way if they change users or they are running terminal server, they all find this entry in the same location. In order to write to the HKEY_LOCAL_MACHINE on Vista, you must be elevated to Administrative level. I have read several articles on how to achieve this, but the common belief is to create a separate program that can be run from your main program. This new "separate" program should be setup to require administrative rights using a manifest file. Now the trick I needed to pull off was to be able to call this program and wait for it to close. I tried a few solutions... but the one that seemed to work best for me was to create a third program. This third program will be a COM Object accessable by Foxpro, with the sole purpose of running the "separate" program mentioned above and wait for it to close. I call the COM Object from VFP and it stops the VFP programs execution until the separate program is closed. Perfect! It seems like I found the answer.. but because I knew it had to be too good to be true I decided to test a little. I created two shortcuts on my Vista desktop. Both shortcuts run Foxpro 9, but one is flagged as "Run as Administrator" and labeled "Admin". The other shortcut runs as Standard User is titled "Standard". When I run the Standard VFP shortcut and execute the Com Object, everything is perfect. Life if great! Now I tried to run the VFP shortcut "Admin" and access the COM Object. Here is where the problem is..... Class definition x.y is not found Help! I don't know what to do next. When I run the "Admin" shortcut, Vista prompts be to "Allow / Cancel". It is elevating my instance of VFP to Admin level. But when I attempt to execute the COM Object it cannot find the class definition. Any ideas on how to get around this "little" problem? How is everyone else handling this? Thanks Dan Tallent Tag: Import UTF-8 text from Excel Tag: 231330
  - 13
    - Gefile on terminal server Hi, a client reports following situation with our Application (built on VFP9SP1): Every dialogue, where we use the putfile or the getfile function, does not appear. They had to delete the local profiles of the user on the server, because there were problems in the encryption module, and after that, the getfile() - function does not show the input form. the command is totally ignored... How can I make the dialogue appear? Thank you! Bastien Tag: Import UTF-8 text from Excel Tag: 231316
  - 14
    - Winsock and ip address changes Hi and thanks in advance for the help. This isn't strictly a Fox question but since I develop in Fox I thought I'd see if any of you have any ideas about this. I use the MS WinSock control. One of the properties is LocalIP which should be your machine's IP address. It is set by the control and not changeable in code. My application stopped working and I was looking at the LocalIP property. It said 0.1.4.0 instead of 192.168.0.33 which is my correct ip address (fixed, no dhcp involved) Once I rebooted, the LocalIP went back to 192.168.0.33 I'm curious as to how it got changed. Did I have some poorly behaved software? Did my machine need a re-boot and the funny IP Address was a symptom? Is something more evil going on? If anybody knows anything about this please tell me. Thanks, Jeff Tag: Import UTF-8 text from Excel Tag: 231310
  - 15
    - Upgrade from VFP 6 to 9 - RUN command fails I have the RUN command in a long-standing app that I am now running under VFP 9 for the first time, but even from the command window, a simple RUN cmd or RUN command both fail. I'd appreciate suggestions on what to look into next. The RUN command is an integral part of this application and we need it to work. If I do a DIR <batchfilename> from within VFP 9, the file is there, and I can edit it from a cmd window (which I just did) and save my changes, and I also just ran it from a cmd window, but this is a cmd window opened by the operating system (me clicking on the shortcut on my desktop labeled "dos box") and not from within VFP 9. Thanks in advance. -S- Tag: Import UTF-8 text from Excel Tag: 231308
  - 16
    - Problem with VFP9 report In group footer we have: in 1st line - field object with Fix relative to top option in 2nd line - field object attached to memo field in table with Fix relative to top and Stretch with overflow options in 3rd line - field object with Float option in 4th line - field object with Float option If memo field has up to 20 lines everything is ok, but if memo filed is longer than 20 lines footer continues on next page but it does not print 3rd and 4th line. Thanks in advance Tag: Import UTF-8 text from Excel Tag: 231298
  - 17
    - FoxPro with MySQL how to use Foxpro to access MySQL database ? some sample will be good. thanks! Tag: Import UTF-8 text from Excel Tag: 231297
  - 18
    - List of all Foxpro base properties? I am trying to write a program to document the custom classes I made. How could I obtain a full list of base property names of all base classes, so that I could auto-magically know the property is a custom one or a base one? -- iTech Consulting Services Limited Expert of ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852)2325 3883 Fax: (852)2325 8288 Tag: Import UTF-8 text from Excel Tag: 231293
  - 19
    - Patches for VFP 9.0 I just installed VFP 9. On this page: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx The first item is SP1, and the second item says what's in it is already in SP1. What about the remaining items on the page - do I want/need them? XSource FFC VFPCOM Utility There is a brief explanation of each on the web page but I'm afraid it's a little too brief for me. TIA. -S- Tag: Import UTF-8 text from Excel Tag: 231291
  - 20
    - Delete query Can someone tell me why the following does not work? I have two tables, cps and complete. I need to delete all the records in cps that match the records in complete. Here's my query: DELETE FROM cps.DBF WHERE Cps.invoice = Complete.invoice When I run that above Foxpro tells me that 0 records were deleted. Any help would be greatly appriciated. Jim Tag: Import UTF-8 text from Excel Tag: 231286
  - 21
    - Sending report to file I have a large VFP application I inherited. There is a function I made to create a PDF from a report and email the PDF file. I send the output to a file using the command REPORT FORM MyReport NOCONSOLE TO FILE MyResultFile.ps I then use GhostScript to create a PDF. Everything works fine the FIRST time, but the next time I run the REPORT FORM command, the output is sent to the default printer and not a file. In trying to find the problem, I have used DISPLAY MEMORY TO FILE both times to compare the contents of memory. I have done the same with DISPLAY STATUS. I do not see any glaring differences that would prevent the output to a file the second time around. If I exit the application and reenter each time, the report is sent to a file successfully. It only fails if I _don't_ exit the application and it only fails after the first run. I have verified the printer is being set correctly and the SET('PRINTER', 3) is the printer with the postscript driver. This definitely seems like a bug in VFP since a file is not created and the REPORT FORM command should produce a file because of the "TO FILE". Any ideas? Tag: Import UTF-8 text from Excel Tag: 231285
  - 22
    - Question: Is VFP a Developing tool or a Database ? If you believe so, please take a look at the following link which is there since 2004: http://www.microsoft.com/usability/enrollment.htm Demetrios, Greece Tag: Import UTF-8 text from Excel Tag: 231278
  - 23
    - Project Documentation Machine What is "repair object hierarchy in progress"? -- iTech Consulting Services Limited Expert of ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852)2325 3883 Fax: (852)2325 8288 Tag: Import UTF-8 text from Excel Tag: 231271
  - 24
    - VFP9: Weird Event Issue A central part of my app is the Invoicing Wizard. It gives the operator a display of Work Orders and the opportunity to select one for invoicing. Because of the nature of the business, there are many things to check before invoicing, so the form has thirty-two buttons. While this might seem to be a good entry for the Interface Hall of Shame, it does work rather well. (Yes, I have used the app as well as having written it.) There is a peculiar behaviour that I noted when working on a related matter. Each Work Order listed has a textbox next to its details. Putting a "Y" in it selects the Work Order for invoicing. The textbox has input validation for whether it will allow the Work Order to be selected for invoicing. Among the things that is checked is the Work Order Type. If it is "E", then a messagebox asks whether this is what was really intended and should the system change the type to "F". If yes is chosen, the Work Order is updated and so is the display. If not, the Work Order is not selected. If "Y" is entered into the textbox, focus is moved off it (say, with <Tab>), and then the "Generate Invoice" button is clicked, invoicing will start. However, if "Y" is entered into the textbox, but focus is not first moved off the textbox before clicking "Generate Invoice", when the Work Order Type is "E", the messagebox will appear, a yes response will result in the Work Order and the display being updated, BUT invoice generation will not start. The focus will be on the Generate Invoice button, but the button's click will not get executed. My question is why does the button's click not get executed. Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: Import UTF-8 text from Excel Tag: 231262
  - 25
    - SQL query problem with character comparison. Hi, I have a problem in Foxpro. We have a query like Select * from Account, Bank where alltrim(account.bank_id) = alltrim(bank_bank_id) and alltrim(account.Bac) = alltrim(Bank.Bac) and alltrim(Bank.Bac) = '0000991' and not Deleted() Bank table has a column Bac which is type Charater(7). The application always inserts 7 charactes in this column. Eg. for 71 it will insert 0000071. But i have some records in the table which are marked deleted and they have bac column as 0001 i.e is less than 7 characters. The problem is above query does not return a result set even though there are records present. Moreover if i pack the table Bac, the query works fine. I also tried changing the query to Bank.Bac = '0000144'. Initially it worked fine and returned me 400 records. Then i zapped 300 records from account and executed the query. this time it agan gave me no records. By some trial and error i found that the modified query worked if there were more than 170 records. For any less it gave blank recordset. I want to find out the reason for such weird behaviour and if this some Foxpro limitation Please reply. Thank you Tag: Import UTF-8 text from Excel Tag: 231250
- Next
  - 1
    - Foxpro going open-sourced? http://www.linux.org/news/2007/03/20/0001.html -- iTech Consulting Services Limited Expert of ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852)2325 3883 Fax: (852)2325 8288 Tag: Import UTF-8 text from Excel Tag: 231249
  - 2
    - Mulitiselect records on the Grid hi expert, how can i multiselect records on the grid. can you give me some example code thanks.... gechelle Tag: Import UTF-8 text from Excel Tag: 231243
  - 3
    - Microsoft is going open-source the core portions of the Visual FoxPro DBMS! I want to be between the first ones to bring this news: http://www.eweek.com/article2/0,1759,2105307,00.asp =A1Can't believe that! Best regards, Fernando D. Bozzo Tag: Import UTF-8 text from Excel Tag: 231239
  - 4
    - focus.fll and vfp9 I used focus.fll in my vfp7 application, and there are hundreds of users out there. I used 2 functions (fil_encrypt and fil_decrypt) to encrypt and decrypt personal information. (I also used fil_open and fil_create but haven't started to worry about these yet). I am in the process of moving this application to vfp9 and of course focus.fll is no more. My dilemma is how to enable users to transfer their data. I don't really want to have to supply a separate vfp7 exe with runtimes to convert the data, but can't get a response from fastwrite.com about purchasing the source code for these functions. Does anybody have any help or advice to offer? Sincerely Stephen Ibbs Tag: Import UTF-8 text from Excel Tag: 231232
  - 5
    - Foxpro 2.6a windows Install disks Anyone know how I can get access to install disks for this program? Does anyone that no longer needs their copy be willing to sell it off to me? Tag: Import UTF-8 text from Excel Tag: 231224
  - 6
    - No more Foxpro Would Micro$oft open the source codes of VFP since it's only Micro$oft that has no interest in it..... -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.10) Linux 2.6.20.3 ^ ^ 20:18:01 up 1 day 6:36 0 users load average: 1.00 1.00 1.00 news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: Import UTF-8 text from Excel Tag: 231222
  - 7
    - How to APPEND FROM XLS for Cell with formula? Good day everybody, I am using VFP8.0 and Excel 2002. I have been using VFP program to use APPEND FROM to read Excel file and fill my DBF with data. So far I have no problem with that. However due to end-user request to minimize data entry work, I replace one of the Excel column with formula VLOOKUP to get some data from Excel table in the same workbook. Now I couldn't get the result upload into DBF file. I get a black box and first letter of the result only. I will appreciate if some one can guide me to solve the problem. Thanks in advance and hope to hear from you. Best regards, Julie Tag: Import UTF-8 text from Excel Tag: 231218
  - 8
    - Variable declaration doubt why and what is the benefit of following code local oSomething as "SomeServer" over the following code local oSomething since following code works even without declaring the variable. oSomething = NEWOBJECT("SomeServer") thanks! Tag: Import UTF-8 text from Excel Tag: 231212
  - 9
    - [fw] can this routine be sped up? wait wind "Starting Excel..." nowait tmpsheet = getobject('','excel.sheet') XLApp = tmpsheet.application XLApp.WorkBooks.Add() XLSheet = XLApp.ActiveSheet t_head1 = 1 select output goto top t_loop = 1 do while !eof() t_loop = t_loop + 1 XLSheet.Cells(t_head1+t_loop,1).Value = "'"+bookno XLSheet.Cells(t_head1+t_loop,3).Value = "'"+bookname XLSheet.Cells(t_head1+t_loop,4).Value = 'BOOK' XLSheet.Cells(t_head1+t_loop,5).Value = "'"+iif(empty(output.oapprm1),'',left(dtoc(output.oapprm1),5)) XLSheet.Cells(t_head1+t_loop,6).Value = "'"+iif(empty(output.ppdate1),'',left(dtoc(output.ppdate1),5)) XLSheet.Cells(t_head1+t_loop,8).Value = "'"+iif(empty(output.pstarts1),'',left(dtoc(output.pstarts1),5)) XLSheet.Cells(t_head1+t_loop,9).Value = "'"+iif(empty(output.bstarts1),'',left(dtoc(output.bstarts1),5)) XLSheet.Cells(t_head1+t_loop,10).Value = "'"+iif(empty(output.bcd1),'',left(dtoc(output.bcd1),5)) skip enddo -- iTech Consulting Services Limited Expert of ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852)2325 3883 Fax: (852)2325 8288 Tag: Import UTF-8 text from Excel Tag: 231206
  - 10
    - How to "select ..." on SQL Server 2000, Thnaks! Dear All, How to "select ... " on SQL Server 2000, Thanks! Q1: "select recno() as yrecno, * from tablename into cursor xx order by 1" Thanks! Tag: Import UTF-8 text from Excel Tag: 231199
  - 11
    - Grids In VFP6. Can you create a grid programmatically ? I can create a window on the fly and activate it, but would also like to put a grid into it with selected characteristics Thanks.. -- Tim Hobson Tag: Import UTF-8 text from Excel Tag: 231190
  - 12
    - Docking Windows Hi, When docking a window on the side and another on the bottom, the bottom window will always push the side window up. It seems when docking on the top or bottom, those windows will always dock full screen width. Is there anyway to change this so the windows docked on the side will show full screen height? Thanks Dave Tag: Import UTF-8 text from Excel Tag: 231185
  - 13
    - VFP9: How to prevent undocking of a form? Hello How to prevent undocking of a form? Thx Tag: Import UTF-8 text from Excel Tag: 231183
  - 14
    - sql question reference name continue 1 apple 1 2 apple 2 3 apple 3 4 boy 1 5 boy 2 6 cat 1 7 cat 2 8 cat 3 9 cat 4 10 cat 5 11 apple 1 12 apple 2 13 boy 1 How to produce "continue" from the first 2 columns? -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.10) Linux 2.6.20.3 ^ ^ 15:22:01 up 1:40 0 users load average: 1.00 1.01 1.01 news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: Import UTF-8 text from Excel Tag: 231177
  - 15
    - No VFP At the risk of seeming utterly self-concerned, I was wondering what the easiest path might be for VFP programmers. I don't think I can in good conscience start a new project in VFP. Does anyone know what languages and developer interfaces are similar? I hope Microsoft gives us some guidance. It seems as though they should drop Access and keep VFP. I started with dBase II, went on to DBXL, then finally Fox. This whole thing is very sad news because I love Fox. I'd love to hear from others. Monique. Tag: Import UTF-8 text from Excel Tag: 231171
  - 16
    - Problem with activeX under VFP9. Hi All: We've been using an activex control ("bblistview.ocx") for seven years under VFP6 without problems. But now we want to update our application to VFP9 so when we run our app under VFP9 IDE, that control runs correctly, but when it runs in EXE it fires an error: Error 1429 ... Exception code OLE lDispatch 0 of BBLIST~1: Invalid Index Value. And control doesn't run properly. Any idea or advice about this problem, please. We use that control a lot of times in our app, and if we can't run it, we can't update to VFP9. Thanks in advance. Rosana. Tag: Import UTF-8 text from Excel Tag: 231148
  - 17
    - Loadpicture Hi all, in an ICO file, we have are multiple Icons saved with different color depths and sizes... We want to create an ICO Object for loading the data into a treeview from that. In VB, there is a loadpicture function with parameters for size and color depth, and the system reads the right Icon from the file. How do I do this in VFP? Thank you for your answer. Bastien Tag: Import UTF-8 text from Excel Tag: 231144
  - 18
    - PageFrame behavior Why closing a form with pageframe without any changes will prompt for saving changes ? is only certain form or all form with pageframe having this same behavior ? why ? Tag: Import UTF-8 text from Excel Tag: 231141
  - 19
    - VFP9: Setting Printer Orientation Multiple Times I thought I had it all worked out. I did some final checking, and found that I do not have it all after all. A minor point: it turns out that the report should have its tag and tag2 columns emptied as well. More importantly, I find that I can not change the orientation in the middle of a report. I can kludge this on hardcopy by replacing my eject commands with close printer (and hope the pages print in order), but this does not work with PDF output as it ends the report. I only need to be able to do this for entire pages. The sys(1037,3) also appears to have no effect ever on PDF output. The sys(1037,3) documentation says nothing about the settings being for the entire printjob, but that is the way that it appears to work. Unless I missed something. If you know, what? Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: Import UTF-8 text from Excel Tag: 231126
  - 20
    - Presents without inviting Hi Seniors I hope ur fine In vfp 6.0 whenever i open the form by "modi form form1" , toolbox and property windows presents by default , how to avoid this. Paul Tag: Import UTF-8 text from Excel Tag: 231119
  - 21
    - Timers and resources Hello and thanks for the help. Does anyone know (or have a good guess) about the resources used by a timer control? If I have a window with a timer control set to 60000 (every minute), how many of these windows would have to be open before the performance is a problem? Thanks, Jeff Tag: Import UTF-8 text from Excel Tag: 231115
  - 22
    - ObjectForScripting? I want to communicate back from a html document which I run in a browser control in a VFP 9 form. In C# this is done by setting the property ObjectForScripting to the form object (). After this the htm page can run functions in the C# code. The ObjectForScripting property is lacking in the webbrowser control in VFP9. Any ideas how to do this? Basically what I want to do is to send back data to the calling ole control. Any help would be appreciated. Tag: Import UTF-8 text from Excel Tag: 231109
  - 23
    - registering ocx's under vista My vfp app uses msmapi32.ocx and mscomctl.ocx When loading it on to vista business (logged in as administrator) I get and error message code 0x8002801c and a message to lookit this code up on mskb this tells me that I have to rewrite the dll using categories (these are ms ocx's) where do I go from here? Any help appreciated John Davy Tag: Import UTF-8 text from Excel Tag: 231100
  - 24
    - Command Button In VFP6 and VFP7 there is no backcolor property in the CommandButton. Is there any way to change the background color. Tag: Import UTF-8 text from Excel Tag: 231095
  - 25
    - No VFP 10 Too early to be a aprils-fool. http://msdn2.microsoft.com/en-us/vfoxpro/bb264582.aspx Carsten _______________________________ Tag: Import UTF-8 text from Excel Tag: 231092

Is it possible to import or read texts from an Excel file that include =
UTF-8 texts?

Robert

Re: Import UTF-8 text from Excel by Man-wai

Man-wai
Tue Mar 27 09:21:30 CDT 2007

RobertVanGeel wrote:
> Is it possible to import or read texts from an Excel file that include UTF-8 texts?

check out strconv()

--
.~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Ubuntu 6.10) Linux 2.6.20.4
^ ^ 22:21:01 up 3 days 9:33 0 users load average: 1.00 1.00 1.00
news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk

Re: Import UTF-8 text from Excel by RobertVanGeel

RobertVanGeel
Tue Mar 27 15:21:49 CDT 2007

So how is strconv() going to get my values from Excel?

I tried reading the xls file with CreateObject("Excel.Application") and =
successive calls to read the sheet but they come in as ???.
The same goes for Import From, all values are tranlated to ????

Robert

"Man-wai Chang" <toylet.toylet@gmail.com> wrote in message =
news:%23IautsHcHHA.2300@TK2MSFTNGP06.phx.gbl...
> RobertVanGeel wrote:
>> Is it possible to import or read texts from an Excel file that =
include UTF-8 texts?
>=20
> check out strconv()
>=20
> --=20
> .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org
> / v \ Simplicity is Beauty! May the Force and Farce be with you!
> /( _ )\ (Ubuntu 6.10) Linux 2.6.20.4
> ^ ^ 22:21:01 up 3 days 9:33 0 users load average: 1.00 1.00 1.00
> news://news.3home.net news://news.hkpcug.org =
news://news.newsgroup.com.hk