Search results for query: *

I agree with your views Olaf. What I've always found strange about these two third-party libs, however, is that I put them with the 4 vfp runtime dlls in the same folder as the application exe. I've never needed to register the 4 vpf dlls, but occasionally - and this happens under XP - I need to...

Thanks Olaf - I'll check the version of regsvr32 I use later today. My first thoughts were that the third-party libs need an update for Win7, but that's just a hunch at this stage.

To clarify - though I put the 2 third-party libs (DZACTX.DLL and DUZACTX.DLL) in the same folder as the application, they seem to require registration in Win7 (sometimes in XP as well) - unlike the 4 VFP runtime libs which are also in this folder.

I'm using Dynazip successfully in a VFP app under earlier OS but am now having a problem with Win7 (Home Premium 64). I'm getting the message 'Error creating output files (Problem extracting file(s))' followed by a messagebox containing '28' when the VFP app tries and restore a file using...

In a VFP9 app I extract info from a DBF and use automation to format and write to an XLS sheet. In Excel, the user can then update certain cells before saving in 95/5.0 format. VFP then reads the resulting XLS file into a DBF and updates other parts of the system from this. This was all fine...

Found a solution for this after ferretting around in the project directory. There was a file called <projname>_ref.dbf (and its associated FPT file). This looked to hold details of all previous code reference searches and results. I just renamed these files so they were 'out of play'. (There's...

Though I've not yet set up a 'new' project, I looked at a 2-month-old backup copy on another computer. This showed the same behaviour. The first time I called 'Code References' it gave the error 'Index tag not found' when looking at the single menu file, all five report forms, and a single prg...

I'm searching for specific text in several projects. The first few have worked fine - i.e. open the project then use 'Tools | Code References' to search for the text across the entire project. On one of the projects, however, I get the error message 'Table has no index order set' as soon as I...

Thanks to all who have contributed to this thread. At first I thought I had quite a rewrite on my hands, but in the end I merely saved the output XL file, via automation, through 'SaveAs(<fname>,-4143)' i.e. current format. Though Automation with XL 2007 wouldn't cope with saving type 43 from...

Mike, How nice to hear from you - it's over 5 years since you guided my first faltering steps in VFP. In the app in question I save the data in XLS (43) format rather than CSV because I want to format the spreadsheet with things like bold, borders, background shading, centering, locking...

Thanks for your input. I was under the impression, however, that VFP could only read in XLS sheets in 95/5.0 format (type 43). This is why, when I've exported data to, and imported from, XL I've always used this format. In short, I use automation to write a type 43 spreadsheet, and let the user...

My VFP 9 app uses automation successfully with Excel in versions prior to Office 2007 (though any input and output sheets are in 95/5.0 format). Users are now reporting an error (1420) when using Excel 2007 - at the point where we use the 'SaveAs' function (with parameters <filename>,43) after...

I can now achieve what I want using 'scripting.FileSystemObject', but is the file SCRRUN.DLL (which I understand is required) always likely to be available on a (client's) Windows system?

OK - now a variation on a theme. What if I have a file 'A.TXT' in folder X and I want to make a copy of this in folder Y (which already exists) but I want the copy to be ReadOnly and Hidden. Any ideas on the neatest way to do this?

Thanks for your input bborissov. I'll have a look at this. What I need it for is to create a duplicate copy of a text file somewhere out of the way (in a hidden folder). This is really for audit purposes. A user might be able to edit the normal text file output from the VFP app (though this may...

Is it possible to create a hidden folder from from within VFP? I can't see that MKDIR offers the chance to set attributes.

Is there an existing function that can compare two text files on disk? (I just need to know if they're identical). If not, I can write a routine myself but don't want to do this unnecessarily.

There's actually no consistency in the length or format of these serial nos. Many items may not even have a serial number at all. With Autofit I found that the column width was configured to the width of the first item in the list rather than the width of the longest item in the set. The max...

What I've decided on the end (though I know it's not a very elegant solution) is to add a ' to the front of the serialno in the CSV file - if the serialno is all numeric. When imported to Excel this is then interpreted as character data (even though the ' is displayed in the cell). If the user...

Thanks jrbbldr - some interesting points. In this case I'm not using Autofit because I want to specify more precisely the width of the columns. Autofit has a good try but I want consistency rather than relying on the data in each sheet. In outlining the problem I've tried to give just the...