Recent content by Mrall

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.

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

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

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.

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

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

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

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

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

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

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

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

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

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

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