Recent content by jworley

Thanks - I'm working with an existing sheet. I've tried your approach but it doesn't seem to work. Any idea what I may be doing wrong? worksheet = createobject('excel.application') oExcel = worksheet.APPLICATION oExcel.Workbooks.open('C:\LAT Excel Demo\excel\test.xls',,.F.) oExcel.VISIBLE =...

Hi, I've created a macro in Excel that uses the find function, here is the code it produces: Cells.Find(What:="Saunders", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate...

Hi, I have a 6 column grid with one combo inserted into column 3. The combo is populated with several choices that the user can make, a common scenario no doubt. At runtime, this all works fine except for the fact that the combo looks "squeezed" i.e. the row does not seem tall...

Hi, Does anyone know if it's possible to use the VFP Query Designer within an app, i.e. call it like a form. Am I asking too much ? I don't want to reinvent the wheel by having to write a query tool for my end users. Thanks! Jim Worley jim@aits-uk.net http://www.aits-uk.net

Hi, Please forgive me if this question is a little elementary but I have searched this forum for ages and I haven't found anything on this subject. I am writing a query form where a user can locate and open any VFP database. What I would then like to do is get a list of tables in that...

Thanks Mike, I'd like to use the path next time the program is used, this would mean that I would have to store it in a database field, and then get getfile() to look at the store path next time the program runs. Is this possible? Jim Worley jim@aits-uk.net http://www.aits-uk.net

Hi, I'm using getfile() to locate a file that the user wishes to import/export. In use, the first time the user browses to a particular location, the path seems to stay in memory until the program is terminated. I'd like to be able to store the path that the user first browsed to, and start...

Hi, I have written an app that is installed in 30 or so locations. User input has resulted in a new version which has required changes in several tables i.e. addition of new fields. Is there an easy way of inserting the new fields into the existing tables when the upgraded executable runs for...

Hi, The Outlook junk/adult mail filter is accessible in a silly little window where you can add/remove addresses. Is there a data file with these entries in it that I can manually edit in a text editor to save messing about ? Hope you can help :) Jim Worley jim@aits-uk.net http://www.aits-uk.net

I have a HP Laserjet 4500 which is connected to a D-link print server. When I set this up, everything worked fine for a while, and then it stopped working. When trying to print a test page, I get the following message in the event log: "The document Test Page owned by administrator...

Hi, I have a new Toshiba Satellite portable running Win 2K, and Office 2000. When I use File/Save As and try to save to A:, it reboots immediately. It does not do this in any other application when I save to the floppy drive. I have deinstalled Office and reinstalled it, still does the same...

Shriram, you are a genius !! It worked !! Jim Worley jim@aits-uk.net http://www.aits-uk.net

Hi, We have an installation of 1 NT4 Server and 34 NT4 W/station clients. On one (and only one) of the clients, you can log in as administrator when the machine is not connected to the network, and you have full administrator privileges locally. Connect the machine to the network using the...

OK, is there any way one can identify what version of VB the exe was compiled with ? Jim Worley jim@aits-uk.net http://www.aits-uk.net

Hi, One of my clients had a bepoke app written, he doesn't know what language the developer used, I note that it uses an Access database and am assuming that it is VB. The company who developed it went bust and you guessed it, no source is available. Changes need to be made with it as it...