Recent content by johnod33

Thanks JRB-Bldr, I just changed the "" to 0 and it worked fine. Before: IF(RC[-2]=0,"","=RC[-1]/RC[-2]") After: IF(RC[-2]=0,0,"=RC[-1]/RC[-2]") Thanks again! John O'D

I am copying and pasting a formula into column I rows 4 thru predetermined count of DBF records. The constants are : #DEFINE xlSum -4157 #DEFINE xlFillDefault 0 #DEFINE xlAutoFill 4 #DEFINE xlPasteFormulas -4123 #DEFINE xlPasteValues -4163 #DEFINE xlNone -4142...

Never mind, I am an idiot. I have been using &array instead of @array. :-(

I have spent hours and hours trying it get this to work. searching here and on the Internet. I have found the same code over and over but it just doesn't work. Here goes: Column A in Excel table is Country Column G is sales for Country by customer (Actually several columns need to be...

Hi guys, I don't have it yet. My boss wants me to do some testing on it before we get it for everyone in our department. I would just as well keep using the older versions. I create data for the financial analysis people. I often teeter on 65,500 records. If I need to send more than that I...

Thanks Mike L and Mike G, I understand what you are talking about now. I use that all the time in my programming. For some reason I didn't associate this process with the term you used AUTOMATION. Thannks for the info! John O'D

Thanks Mike, What do you mean: "You can, of course, also use Automation to import Excel data"? I use the IMPORT in a VFP program. Is that what you mean? Maybe I will learn something new here. John O'D

We are thinking of upgrading to excel 2007. I often import excel spread sheets programmatically using VFP (6.0). IMPORT FROM (mfilename) XL8 SHEET I also create Excel spread sheets programmatically. COPY TO filename.xls XLS or FOX2X for those databases over 16,385 records. I also do an...

Sorry it should say it DOESN'T add a passowrd. John O'D

Sometimes I add a passwrod to an Excel table created in my Fox Pro code using these lines of code. WITH oExcel . . .(some code removed) . .ActiveWorkbook.Password = "XXX" .ActiveWindow.CLOSE(xlSaveChanges) .APPLICATION.QUIT ENDWITH I want to use a password...

I hope this is the correct forum to use. I don't see any forum for errors. I often run code to gather sales data month by month appending into a common dbf for many months which results in huge databases. 5 or 6 million records maybe 10 or 15 fields. Once I get the data into a common dbf I pull...

Woo Hoo! Thanks BongoB1 that worked! John O'D Thanks everyone else for your input also.

How do I get this to work? I have two list boxes list1 and list2. I have a drop down list in list2 and I am populating a display list of items in LIST1 as the user clicks on the drop down list in list2: (in the click procedure of list2) WITH THISFORM .WINDOWSTATE = 0...

Deleting the two files did nothing. When you run the exe the two file are recreated again of course with just the data from that last session. Do you think it could have anything to do with the setting of the screen resoultion? This user has it set 1280 x 1024 John O'D

Simple report I open a dbf USE DBF IN 0 SHARED ORDER emp_no then I open a REPORT REPORT FORM REPORT.frx PREVIEW This report is opened in a FORM. The form opens max screen using ZOOM WINDOW SCREEN MAX in the INT procedure of the parent form. The report opens full screen as I want it to for all...