importing text file into excel file using macro
How to import text file into excel file using Macro? Can this proces
run on form menu button? Please help and give me some ideas of doin
it. I have attached a text file for your reference.
Attachment filename: rdata.txt
Download attachment: http://www.excelforum.com/attachment.php?postid=66130
Message posted from http://www.ExcelForum.com
>How to import text file into excel file using Macro? Can
>run on form menu button? Please help and give me some
ideas of doing
>it. I have attached a text file for your r...How zoom/increase font size of Office 2004 "Help" text?
Font sizes can be set for Word, Excel and Entourage. You also can zoom in
to enlarge the View of text in Office 2004 components� documents.
How does one do this with the small-font text in Help?
On 9/14/04 1:36 AM, in article
BD6BFBA9.49F3email@example.com, "Norman R. Nager, Ph.D."
> Font sizes can be set for Word, Excel and Entourage. You also can zoom in
> to enlarge the View of text in Office 2004 components� documents.
> How does one do this with the small-font text in Help...Replying in Newsgroups
Using Outlook 2007, Vista Home Premium SP2, HP DV6500 Notebook
When replying to newsgroup messages (uses Outlook Express for this) the =
repeated original message lines are not prefixed with the > symbol, =
despite options being set to do this. Seems to be a problem that has =
started recently despite my not having knowingly changed any settings.
Any help appreciated.
Dave S. wrote:
> Using Outlook 2007, Vista Home Premium SP2, HP DV6500 Notebook
> When replying to newsgroup messages (uses Outlook Express for this) the repeated original message lines ar...Printing without certain text (i.e., answers, notes)
Does anyone know an easy way to print two versions of a document? For
example, I need to print a student version without answers and instructor's
One way would be to use a style (call it Answers for example), when you want
to print out the students copies change the color of the style Answers to
white. That should do it.
"TM" <firstname.lastname@example.org> wrote in message
> Does anyone know an easy way to print two versions of a document? For
> example, I need to print a student version without answers an...Reply rule doesn't work consistantly
I've got an Outlook 2003 client and we are trying to setup a rule to
emulate the Out of Office Assistant. I've setup a rule that is
supposed to send reply with a template if the sender is from a list of
contacts that I've chosen. It isn't working as expected. The first
time I tried it, I entered only one (internet) email address which
worked perfectly. If I add any addresses to that list, it doesn't work
anymore - the reply is not sent.
I know that it can reply to internet email addresses, since it worked
that one time, but I can't figure out why it won't work when...Name prefixing in reply message
I'm not even sure what terms to google for related to this problem. If you
get an email from someone in the Office XP version of Outlook, and you click
reply to that email, then start typing inside the portion of the message
that contains the original message you replied to, it will automatically
prefix everything you write with your name. How does one turn this off?
Thanks in advance!
> I'm not even sure what terms to google for related to this problem. If you
> get an email from someone in the Office XP version of Outlook,
> and you click...Server-Wide Auto-Reply / Address Change Notice
We are in the process of changing domains as far as email/web addresses are
concerned and I wonder if it would be possible to have Exchange reply for
each user with a message stating something like, "This is an automated reply
letting you know that the email address for User Smith is now
I realize that each user could create a rule in Outlook... but we would need
the rules to apply for a long period of time and that could be very annoying
for senders... getting hit with constant auto-replies.
Even if it would be possible for a user to create a rule th...Outlook 2002 coming through with reply but nothing is there
Confusing situation. ISP support has never heard of this
problem, hopefully someone here has.
3 people share a mailbox. One of them sends an e-mail.
The recipient replies. The reply comes through just
showing the original e-mail but not their reply. It also
says it came from (for example) "email@example.com on
behalf of firstname.lastname@example.org"
Now, the weirdest thing is, not all 3 get the same thing.
One of them may get it with the reply, and the other 2
not. One of them may get it without the reply but upon
closing Outlook and re-opening it, the reply is there. I...How do you get the maximum value to display in text box form
In a form, if I have 4 text boxes and 3 of them will contain a number. How do
you get the maximum value to display in the 4th. I have tried many different
things, I can make it work for a single field in a table, but that finds the
value through all records. I just want it to display the max value from the
numbers on the form, which could be different for various records.
You could use something like this as the Control Source of the 4th text box
(the underscore is for ease of reading here, and must be removed from the
=IIf([Field1]>[Field2] And [Field1]>[Field3],...Excel cells should take number format and/or optional text eg Dec.
I usually pre-set number formats and other limitations on forms to ensure
that I get the information that I need. Often, however, the date is vague and
requires text, e.g., Nov 2005 instead of 11/1/05, which is Excel's default if
you type in "Nov 2005." I can alleviate the issue on my own work, but my
forms need to remain locked when being used by others. My suggestion is that
an option be offered so a cell could take either/or text or number in the
case of dates.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the ...Autofill Text
I am trying to create a series of text sets, eg. aaa-aaz, aab-abz, but find that I cannot autofill unless the series contains numbers or dates. Can any one suggest a simple answer for this as I am not an experienced user of EXCEL. It seems that filling in each series individually is the answer but it's a lot from aaa to zzz. Would be greatful for any assistance. Cheers
"Ryko" <email@example.com> wrote in message
> I am trying to create a series of text sets, eg. aaa-aaz, aab-abz, but
find that I cannot autofill...inverting text box or fonts for artwork
I cannot figure out how to invert text that is inside a
text box. If there is not any way to do this is there a
way to invert text outside a text box?
Thank you for your help
The entire text box gets inverted. If you want just a line or a word to
invert, you need to make a separate text box. Just make the box active,
select the icon that looks like a line with an arrow head in a circle and
click on it.
BTW, this is with Publisher 2000.
Vancouver, USA, a great city in one of the 45+ countries in America!
"Kathy Keating" <firstname.lastname@example.org> wrote in message
n...Adjusting Two Columns with Text
I have two columns. I've entered numbered text in each column. As I add
more numbered items, the second column keeps adjusting itself downward. Is
there anyway to freeze the second column as I add items to column one?
I am not really sure what you mean by "the second column keeps adjusting
Do you have a two column table, or is the document formatted with columns?
It sounds like you may have the former when what you want is the latter.
Format the document so that it has two columns (via the Page Setup section
of the Page Layout tab in Word 200...Shrinking font in Report Text Box
I have strings of varying length that I need to display in the same text box,
so I would like to be able to shrink the text if it would otherwise be
truncated. I've read other, similar posts but still have a question. It
seems that Lebans AutoSizeFont is the right module for me to download
(http://www.lebans.com/autosizefont.htm), but having done that, I'm not sure
how to "apply" it to the text box in question. I've got no experience using
modules. Could someone walk me through it?
>I have strings of varying length that I need to...Great Plains and SQL 2005
Is there any info regarding to what version of Great Plains will be
supported on SQL 2005?
I remember someone mentioned that MGP 8.0 service pack 3 or 4 will allow GP8
work on SQL 2005.....what about GP 7.5?
Does anyone have any URL or whitepaper for the above query?
Visit MBS Blog Central
The yet to be released Version 9.00 of Great Plains will support SQL 2005.
A Service Pack for Version 8.00 will be released to support SQL 2005.
Version 7.50 has just had its last Service Pack (SP7) release and will not
support SQ...Vanishing Entourage Message Text
OK, so here's a good one. On the MacBook Pro, running latest OS and up
to date Office 2004, some email messages display no text.
Toggling the "display complex HTML" does not resolve this.
If I get the same message forwarded through another user, it often
are you by any chance connected to an Exchange 2003 server? If yes,
Microsoft released a patch a week or two ago which introduced a bug in OWA.
They are aware of the problem and working on a fix.
If that does not explain your problem, you'll have to post back and be more
sp...excel grid lines over lapping the text
Closer to the bottom of a printed Excel spread sheet the text is
moving into the lines. I cannot tell if the grid or the text is
moving. I am a printer technician for HP and I have looked at the
printer and it is OK. The driver has been updated also. Can anyone
I won't bore you with the standard 'Update the Printer Driver' answer, because
if anyone's got the latest then you have :-)
I did try a Google on it, and found practically zip on solutions for this, other
than one suggestion from Nick, that you may want to give a go:-
>>I doubt Excel and strange though it ...cell to have comma-delimited values based on text
I have a table called "220_reference" with a column name "Part Number" having
a sample value of below:
4047122(All Dash no.), 4057222(All Dash no.), 4058222(All Dash no.),
4060122(All Dash no.)
The entire value is in one cell representing the "Part Number"
column(defined as general type so text I suppose).
Simple enough. But what I need to do is take any number that has "(All Dash
no.)" after it and search through a column in another table to retrieve any
rows that have that number(text) in it. The other table name is "220" with ...Outlook 2003 bug -can't insert note as text
When creating a mail message, choose Item from the Insert menu, then try to
insert a note as text. All that is inserted into the mail is the date and
time the note was last modified. Outlook XP and Outlook 2000 don't have this
bug - they correctly insert the text of the note into the body of the mail.
...Removing attachment from reply
I want to reply to a message with an attachment without sending the
attachment back, simply and easily
"crownnut" <email@example.com> wrote in message
> I want to reply to a message with an attachment without sending the
> attachment back, simply and easily
Reply shouldn't keep the attachment by default.
Replies do not include the attachment. Forwards include attachments.
"crownnut" <firstname.lastname@example.org> wrote i...Wizard button text
I am creating a Wizard with slightly non-standard
behaviour and I need to change the text of the Finished
and Cancel buttons.
I can use SetFinishText() for the Finished button but
can't see a way to change the text of the Cancel button.
Is it possible to do this?
The reason I want this behaviour is that the Wizard
allows the user to configure devices and I want them to
be able to set up several devices without restarting the
Wizard each time. So the "Finished" button would be
better labelled "Configure" or "Apply" because it applies
the settings to ...outgong replies don't go out
I cannot send replies to messages. I get error
0x80042109. Unable to connect to outgoing SMTP mail
server but only on replies.
...Text and Formula in the Same Cell
Good Morning, Everyone -
Here's what I'm trying to do: I have a cell that has text - "Vendo
Name" - and I also want that cell to contain a formula (counta). I
theboatdude's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1024
View this thread: http://www.excelforum.com/showthread.php?threadid=27525
Here's an example:
="Vendor Name: "&COUNTA(B:B)
>Goo...Unbound Text Box Help
I have an unbound text box called TYPE, that I want to display the name of a
transaction type. See below code. I have added this to the BeforeUpdate and
the AfterUpdate and the TYPE remains blank.
This is DSform and the infromation is for display purposes only.
Does anyone have any suggestions on why this is not working and what I can do
to correct my ways.
Private Sub TYPE_BeforeUpdate()
If Me.TRANS_TYP = "S" Then
Me.TYPE = "SALES FORECAST"
If Me.TRANS_TYP = "I" Then
Me.TYPE = "INVOICE"
...Fill in text from drop down list box in Excel
I have created a drop down list box but the list is getting too big and
the user has to scroll down the list to select the data. Is there a
feature I can use to display the data that start with the same string.
For example: If I type "Be" in my box, the box could display the list
that start with "BE or Be".
I created the drop down list by using "Data", chose "Validation", and
chose "List" from the "Allow" tab.
Thanks for your help.
If your drop-down list if from Data Validation, you cannot have Autocomplete.