Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kawnz
  • Content: Threads
  • Order by date
  1. kawnz

    delete page in Word, based on Excel row delete

    Our medical billing system has the ability to generate letters asking our clients to supply information that was missing on the original order. We need this information in order to bill insurance. The system generates two things: an edit report that our employees can use to fix any errors that...
  2. kawnz

    append one worksheet to printing of another

    I have a spreadsheet with three worksheets: the first worksheet has VA insurance data the second worksheet has TN insurance data the other has revisions that were posted to the first worksheet. my manager wants the revision sheet at the bottom of the data worksheet, but then the data worksheet...
  3. kawnz

    word transferring large doc into several small docs

    I have a text file that I am unable to import into excel. The file is over 2000 pages long when I load it into word. Is there a way to save this text file into shorter text files - say 20 files of about 100 pages? How would I do this?
  4. kawnz

    excel97 - importing large text file into several spreadsheets

    I have a text file that, when loaded in word, is about 2000 pages. When opening this file in excel it will of course not load the whole file into one sheet. How do I load the file into excel over multiple sheets so that I can then extract the data I need?
  5. kawnz

    replacing templates in files already saved

    I have a number of files that were based off a template called "Job Descriptions". Now my higherups want to use a template called "Procedures". How can I replace the template for the files I have already created from Job Descriptions to Procedures and have them all work the way they would if I...
  6. kawnz

    excel - repeat row data

    I am working with a report that dumps data in the following format. The first line for each patient shows the account number, name, date, and test code. 142L56887 SMITH,MARY 10/18/04 C300055 0 MC - MEDICARE 0 C300450 0 0 0 MISC00005 0 0...
  7. kawnz

    deleting repeating paragraph

    I have a document that prints form letters telling the recipient of attached errors. The document then prints the errors following the form letter. I want to remove the form letters from the document and only print the errors. I can remove the text from the letter, but cannot remove my...
  8. kawnz

    Data dump excel

    Our billing creates a missing/invalid information report in an ansi (txt) format. I need to turn this into a readable excel form. The report comes across as follows: Accession Patient Service Client Estimated Price ------------ ------------------------------...
  9. kawnz

    excel: counting characters between symbol

    I am compiling a list of "canned messages" that will be entered in our billing system where the employees will be able to enter a code, that will write the whole message for them. e.g. "RFREC" = "Received refund request from" At first I thought I was limited to 30 characters for the message...
  10. kawnz

    showing date instead of formula

    I made a file called schedule.xls - it holds our department's time off requests. I put in 12 months, starting next month (1 Jul being start of fiscal year, etc.) So, the first month is July, and the sheet is called JUL. The next sheet,AUG, calls up JUL's date and adds a month to it...
  11. kawnz

    appointment reminder

    my boss asked me to find out how to have her groupwise notify her 1) 4 hours before a meeting with a pop-up window 2) 15 minutes before a meeting with a pop-up and a beep (or other obnoxious noise) Thanks.
  12. kawnz

    Hiding comments in Excel 97

    Is it possible to prevent comments from showing when sending an excel 97 file to someone else? My new supervisor sent out a schedule today for everyone's days off this month. When she first sent them as a viewable xl file (I think), the comments were expanded in the e-mail, so we could see why...
  13. kawnz

    running one macro inside another

    I was able to run one macro inside another last night in Word 2000, but it doesn't seem to be working in Word 97. How can I run one macro inside another in Word 97? The code I used last night was: Sub generate_new_form() Application.Run MacroName:="ToolsProtectUnprotectDocument"...
  14. kawnz

    resetting a form, but leaving default fields in tact

    sorry to be a pain, but when the macro resets the form, it also resets the default fields. is there a way to have it look for defaults and leave them there?
  15. kawnz

    auto running macro when file opens

    Thanks for all those that replied to my resetting forms question. I have this set to a template, and I protect my forms. How can I automatically run the Macro when the file (or template) opens? I don't know if this makes any difference, but I have my template saved to what they call the P...
  16. kawnz

    creating a macro that resets (blanks) a form's fields

    I have a Word document with a form, that is protected so that the form works by tabbing through the fields. It is a form that I might use 2 or 3 times a day, so I often leave it open. when I reach the last field in the form, and hit tab - it goes to the top... I would like, on hitting tab on...
  17. kawnz

    displaying text from random files

    I have a number of text files with comments from people, and I'd like to call them randomly to a page. I have put all the comment files into one directory so I can call them up from that one directory. The reason I want to work with text files, is because there will be 60-odd people sending in...
  18. kawnz

    temporary username & password

    I have a PDF file that I'd like to protect. What I want to do, is have people pay money, and then they get sent an e-mail with a temporary username and password at which they can view/download the file. I want to have that login expire, so that they cannot then forward the URL to a friend and...
  19. kawnz

    Hi, I am looking for a way to displ

    Hi, I am looking for a way to display two random images from the same directory, on the same page, but of course, I want them to be different. I looked for random numbers not the same, and found this snippet by skiflyer. I can determine the number of files in the directory, but cannot plug...
  20. kawnz

    refresh without retry

    Hi... I am back again. the flash card script works great. However, I have also added a form where people can input certain variables. (eg numbers 20-30, whatever) Now when they send these variables, the flash card scripts pops up, but, when it refreshes, it pops up with the ever annoying...

Part and Inventory Search

Back
Top