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!

  • Congratulations Mike Lewis 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: Mrall
  • Order by date
  1. Mrall

    Excel VBA: Using Public variables and multiple modules

    I have had problems with public variables working in more than one module for some reason. So as an altertive I store them in a cell in a hidden sheet. It works always.
  2. Mrall

    Excel VBA:Dealing with two opened workbooks

    I was able to resolve the issue by simply getting rid of the curwbname variable. The value always remains the same so no variable is nessary. Windows("mywbtool.exe").Activate Thanks so much
  3. Mrall

    Excel VBA:Dealing with two opened workbooks

    Sorry about my response time, I travel alot with my work and don't alway have time to check this update. I tried changing to: curwbname = ActiveWorkbook.Name But I get the same error. As "Combo" stated ThisWorkbook is a workbook where the code that calls it exist. If you save a workbook...
  4. Mrall

    Excel VBA:Dealing with two opened workbooks

    The value of curwbname is 0 in the compiled version, however it is "excelfile.xsm" in the spread sheet before compiling it and it run just fine.
  5. Mrall

    Excel VBA:Dealing with two opened workbooks

    The error that comes up is subscript out of range for the following line. Windows(curwbname).Activate
  6. Mrall

    Excel VBA:Dealing with two opened workbooks

    I have written a module that opens another workbook. No problem. I have another module that switches the active window and copies some cells from it and than returns control to the previous window. This works just as it is, but will error out on a line if I save it as an addin or if I compile...
  7. Mrall

    Graphic Active X

    Perhaps I should explain further The maps(jpg) are 1800x1200 and I don't believe will fit on a form without some sort of scrolling ability on the image control. (or just how big can a form be?) The map is not divided into any sections or special areas. It is basically just a picture with...
  8. Mrall

    Graphic Active X

    Thanks for your quick response The floorplan would be a jpg of bmp(I have managed to obtain free external application to scan in the floorplan and adjust the size to a predetermined size (it works really well))It would be a set size (always the same) and may be selected using a getfile() This...
  9. Mrall

    Graphic Active X

    I believe that this request may not be possible in VFP but maybe someone has some ideas as to how it may be done with some sort of active x or C routine that can be called from VFP. I would like to take a 2d graphic (floorplan) and be able to click anywhere on it adding a very small icon and...
  10. Mrall

    Trapping an Excel import error

    I would like to do the Excel Automation but have no clue as to how this is done. I have Excel 2003 but some of the users have Excel 2010. Does this have any effect on the outcome? The big question is, how do I do this? Thanks
  11. Mrall

    Printer preferences

    I discovered this link has a routine the does everything http://www.tek-tips.com/viewthread.cfm?qid=1538957
  12. Mrall

    Printer preferences

    I know that I can select which printer to use by SET PRINTER TO NAME GETPRINTER() Is there a good routine or method to use to set all the preferences like what word or just about any other program does. Thanks
  13. Mrall

    Trapping an Excel import error

    I have an import routine that imports an excel spreadsheet. It works just fine unless the user forgets to do a save as Excel 5.0/95 Workbook file format. The program hangs up and corrupts the database file. Is there a way to error trap for this or detect the file type before importing. Thanks
  14. Mrall

    Two files opened exclusive

    I noticed when you view the data enviroment (in the form) jobs and dispisitions are aliases for curser1 and curser2 which are tables I have setup. The tables are not linked or indexed in any way (although I could and should index jobs on projname). Dispositions has no unique identifer...
  15. Mrall

    Two files opened exclusive

    Thanks for the response Olaf Projname in the curser jobs(table) and in the curser dispositions(table) is orginaly placed in each table from another imported file at the same time. So the fields should match. I have compared them and they are the same. I can delete the records from the command...
  16. Mrall

    Two files opened exclusive

    In this form the data enviroment has two files opened exclusive(single user enviroment) I set SET EXCLUSIVE ON in the main prg The jobs curser will delete correctly but, the dispositions curser won't delete anything. I not sure why. SET SAFETY OFF SELECT jobs DELETE FOR TRIM(jobs.projname) =...
  17. Mrall

    Is there a Command line XLS, XLM converter?

    Thanks Mike that is exactly wat I need to do.
  18. Mrall

    Is there a Command line XLS, XLM converter?

    danfreeman, you are right. I am still faced with the reality that the users may or may NOT have Excel and while, the csv does work with the ; (instead of the ,)one of fields has a chr(13) in it, which is the main problem. There may be some way to to use VFP to change the chr(13) but it may...
  19. Mrall

    Is there a Command line XLS, XLM converter?

    I use the APPEND FROM GETFILE() TYPE DELIMITED WITH CHARACTER ";" just to see how it would work. The chr(13) or return located in one of the rows is messing the append up. I don't know how to fix it.
  20. Mrall

    Is there a Command line XLS, XLM converter?

    I thought I would also bring up a few more helpfull or not so helpfull facts. 1) I know how many fields (columns) are in the csv file (good) 2) some of the fields (in the rows) unfortunatly have chr(13) or returns in them (not good) so reading a line at a time may not work out so well. 3) I...

Part and Inventory Search

Back
Top