Search results for query: *

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

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

Thanks Mike that is exactly wat I need to do.

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

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.

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