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...
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...
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?
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?
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...
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...
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...
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
------------ ------------------------------...
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...
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...
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.
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...
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"...
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?
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.