Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mbh27
  • Order by date
  1. mbh27

    Dynazip libs under Windows7 ?

    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...
  2. mbh27

    Dynazip libs under Windows7 ?

    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.
  3. mbh27

    Dynazip libs under Windows7 ?

    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.
  4. mbh27

    Dynazip libs under Windows7 ?

    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...
  5. mbh27

    Excel 2007/2010 dates into VFP9

    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...
  6. mbh27

    Error using Code References

    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...
  7. mbh27

    Error using Code References

    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...
  8. mbh27

    Error using Code References

    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...
  9. mbh27

    Excel 2007 Automation

    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...
  10. mbh27

    Excel 2007 Automation

    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...
  11. mbh27

    Excel 2007 Automation

    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...
  12. mbh27

    Excel 2007 Automation

    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...
  13. mbh27

    Create hidden folder?

    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?
  14. mbh27

    Create hidden folder?

    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?
  15. mbh27

    Create hidden folder?

    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...
  16. mbh27

    Create hidden folder?

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

    How to compare files?

    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.
  18. mbh27

    Formatting issue with Excel Automation

    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...
  19. mbh27

    Formatting issue with Excel Automation

    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...
  20. mbh27

    Formatting issue with Excel Automation

    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...

Part and Inventory Search

Back
Top