Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retaining Defaults in an InputBox # 3
Gordon,
It seems to me that if you're writing this application in VB, you should have no problem using a menu to set certain parameters including the location of such a file. You'd simply use the the FileSystemObject to do file operations (read, write, append). Each user would have a stand alone copy of the application and can manage their own settings. During the intial execution of the program, it should check to see if this "INI" file exists, if it doesn't then the user must obviously be prompted for the path. -Tim -----Original Message----- Thanks to a Wild Bill, but his suggestion was where I started - it don't work. Thanks to Tom Ogilvy for a practical route. But I had forgotten something in my original query: I was trying to add a clever bit in Word. The system which I am converting to VB is for consultant medics. It is all in Excel: it has a diary for consultations and treatments: it records fees, sends invoices, records payments received etc. For a brief note to a patient, there is an Excel sheet which comes up with name and address, details of the malady, treatment dates, and a text box adequate for the consultant to add a brief note. But some of them would like to be able to bring up the same stuff on a Word sheet, so that they could write below it pages and pages of advice and explanation if necessary. The Word sheet would have the consultant's name and address on it already. Other than the user editing of the VB code which brings up the Word file, is there a way for the user to enter the drive \ direction \ filename on installing, so that it can remain until it needs to be changed eg a new computer? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
InputBox Help | Excel Discussion (Misc queries) | |||
InputBox with VBA | Excel Discussion (Misc queries) | |||
InputBox | Excel Discussion (Misc queries) | |||
inputbox | Excel Discussion (Misc queries) | |||
Inputbox with VBA | Excel Discussion (Misc queries) |