Jay, I apologize for the slow response...busy Monday. I would like to send you the a sample of the file ASAP... (This would be the one our company is using) Let you take a look at it and see what kind of modification you would want. (Such as Company Name/Logo) Then if your still interested we could discuss fee via email, or phone what ever you prefer. The cost will really be based on modification you want (less Company Name/Logo). I appreciate your interest Again you can contact me via email. [email protected] Thanks BMK

Bryan, I did think about using a .bat file... But I wasn't sure how to call a windows program from the DOS environment. I really haven't did a lot with batch files since the DOS days. I do agree it would give me some flexibility if I can get it to call up the window program. By the way...that sounds like a very clever batch file you wrote up. It opens some doors. Thanks for the help. BMK

Jay, It is something that I would be willing to share for a very small fee. I hope this doesn't come across greedy. I did put quite a bit of time into it...and it works very well. And of coarse it can be customized. I could send you a .xls sheet that it post for you to view. Rekd, I'll give that a try...it makes sense to me. I have had problems with spaces in the variables. I usually try to avoid space in my folder names because of this problem. We haven't load V9.1 yet...but I'm very interested to see how well it works with VBA apps. I would agree that would be the best / most flexible way to start the excel app. I'll try your suggestion with the path name and pass on the results. Thanks for the help BMK

To all, I have created a .SET file that post out data which is then read directly into a Excel file using VBA... We have 10 Engineers/Programmers that access this Set File & the Excel file. (on a network) After the Programmer post the SET file...he then opens this excel file which pulls in the data automatically... The VBA/Macro places the data in the correct cells then pulls in tool images...ect. It all works great...so far.(working for about a month) What I'm trying to now is completely automate it by using the LAUNCH Function to open the Excel file automatically from the SET post. It work just fine on my computer because I know where my Excel is installed.(see code Below) #************************************************* sexcel "d:Program FilesMicrosoft OfficeOfficeexcel.exe" sexcel_file "Q:MastercamModern_ToolsheetModern-Toolsheet.xls" ppost result = launch (sexcel, sexcel_file) #************************************************* But of coarse no one on the network as the same path to Excel.exe. My question is how can I over come the different path names for each Programmer? I've tried using a Win NT Environment Variable in system Properties.... i.e.. Control Panel>System>Environment> MSoffice = d:Program FilesMicrosoft OfficeOfficeexcel.exe. This Variable works fine in a Desktop Shortcut but nothing in the SET file.. (sexcel "%MSoffice%EXCEL.EXE") Doesn't work. Could some point me in the right direction. Any help is appreciated. Thanks BMK

Hello All, 1st post...usually find what I need in archives. Would someone have a .SET file that pulls ALL info from the tool such as drill point angles, tool material..ect. I want to be able to get this info from the tool itself rather than the "TOOL NAME" in parameters which is typed in. It would really save me a lot of time & headaches if someone already had something that they would be kind enough to share. Any help is appreciated. Thanks Bob [ 04-19-2003, 05:37 PM: Message edited by: bmkbailey ]