Importing Text File #3
Did ya ever have one of those lucky accidents that you like and would like to
I created a simple excel workbook based on imported text data. Later, when
I reopended the file, I noticed that the "refresh" button was activated and
would auto import when I clicked. The best part is that the import specs
I have no idea how I did this and have not been able to replicate the
Can someone help?
It sounds as if you used Data - Get external data. It remembers all the
paramaters you specify, and you have only to do a refresh, ...Excel problem, File disappeared.
I created a file in Excel on a WinXP PC that I called
pron.xls and saved it in the my documents folder, I then
decided to move it and using Windows Commander F6 key
(Rename and Move) I attempted to move it to a different
folder and rename it to prn.xls at the same time.
This process caused the file to disappear!!
I now realise that this was because prn.xls is an invalid
I tried to search for the original and new names but
neither existed. There is no sign of it in the recycle bin
Is there anyway of retreiving the lost data?
As far as I'm aware no....Opening File using default viewer
Hello, how would I go about opening a file using the default viewer, so
for example, if the file is a txt file, then notepad would open it. Or
if it is an XML file, then maybe firefox woulld open it.
I was hoping to use a CButton and if the user clicks on it, then it
would grab the path specified and open the file with the corresponding
> Hello, how would I go about opening a file using the default viewer, so
> for example, if the file is a txt file, then notepad would open it. Or
> if it is an XML file, then maybe firefox woulld open it.
> ...Repairinf file and Removing Bills
I have been experiencing some issues with my Money Plus Premium so I have
been trybg to repair the file while deleteing the bills data. Every time I
try i get the following error:
There has been an error reading or writing the file...
Has anyone else had this issue?
In microsoft.public.money, NealT wrote:
>I have been experiencing some issues with my Money Plus Premium so I have
>been trybg to repair the file while deleteing the bills data. Every time I
>try i get the following error:
>There has been an error reading or writing the file...
I suggest you make a repaire...assign cell content as file name
I am attempting to create a macro that will save a workbook with the
file name under which I save the workbook coming from the contents of
one of the cells in the workbook. Suppose that each time the workbook
was altered, a specific cell (A1 on Sheet1 for instance) contained the
desired file name for that workbook. It is my goal to create a macro
that automatically assigns said workbook a name based on the content of
that cell. Any help would be most appreciated.
dim myFileName as string
myfilename = "C:\temp\" & thisworkbook.worksheets("sheet1"...How can I type business cards?
I'm trying to type and print out dinner tickets that are business card size.
I have business card paper. How can I type and print several copies of the
tickets on the same page?
probably not an Excel question. Try this in the MS Word NG
"Bobby9093" <Bobby9093@discussions.microsoft.com> schrieb im
> I'm trying to type and print out dinner tickets that are business
> I have business card paper. How can I type and print several copie...PST files
I have been backing up my laptop Outlook info to PST files each month
and I have about 7 of these PST files and erasing some content like
email right after each backup so as to keep my main Outlook datafile
small for better performance. However, I just learned to understand
how AutoArchive works and realize the inconvenience in having so many
different files that overlap in data but do have distinct emails and
contacts. So I would now like to combine all of them into one big
file but I wonder if there is an automated and preferred way to do
this and so that this combination/conversion...Alert user to check the filed when it is final
Hi, I want to create an alert to check the Final( checkbox ) field, if
date_issued is enter.
if date_issued is null then do nothing, In what even I have to code this and
Message posted via AccessMonster.com
mls via AccessMonster.com wrote:
>Hi, I want to create an alert to check the Final( checkbox ) field, if
>date_issued is enter.
>if date_issued is null then do nothing, In what even I have to code this and
Based on just that one requirement, you can use the date
text b...Unable to type email response in outlook emails
I am unable to type in an email response in outlook. When I begin typing I
get very small., small letters and the body of the original email is in the
new response screen as very tiny letters and therefor not allowing me to type.
Check your zoom settings. See;
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
Real World Questions, Real World Answers
"sunnynaz...Setting directory for file save in macro
Thanks to a generous poster I now have a great bit of code to use in a macro
for Excel which saves a text file (I'm no VBA programmer so this was really
Open "Test.txt" For Output As #1
(rest of code)
My problem now is this:
The macro saves test.txt to Excel's current active folder, rather than the
folder that the current workbook is contained in.
For example, if I last saved an Excel workbook to c:\workbooks\, and the
workbook that I have open exists in c:\workbooks\workbook1\, when I run the
macro it saves the text file in c:\workbooks\. If I ...instructions disppear when users begin type (text field)
I need to customize the outlook contact form and I want to add one text
field to allow users to add details info and instruct users how to add.
Instructions shows in the field and the instructions disappear when users
click and begin to type. How should I do this? exchange 2003/outlook2003
It's hard for me to visualize exactly what you're expecting to happen. If
you want the instructions to stay on the screen, you could display them in a
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumps...How do I merge two publisher files?
I am using publisher 2003. I am creating an 80 page catalog. I like to save
page 1-10 as file one, pages 11-20 as file two and so on. When I am finished
with my catalog I need to send one file to the printer. How can I merge all
of my pages together in one file?
Copy and paste. Or if you have Acrobat (not just the free Reader) you can
create a single .pdf file with the parts.
MVP Microsoft [Publisher]
"screnda" <email@example.com> wrote in message
>I am using publisher 200...Unable to load graphics file
I had a hard drive "repair" and re-loaded Publisher 2000.
Now the program won't let me insert .jpgs (or any other
graphics file) -- I get an error message saying it can't
convert them. I've tried to re-install from the CD,
including the graphics section, but to no avail. Any ideas?
Maybe your graphic filters are corrupt
Look in a folder similar to this
C:\Program Files\Common Files\Microsoft Shared\Grphflt
If you cannot insert any image rename the .flt files to something like jpegim32.old
and drag a new instance from your CD.
Mary Sauer MS MVP
http://office.micr...getting the error when updating file xls file.
We are using exchange 2003 server and office XP but know we start to
Upgrade our office to office 2003 Know we are face problem. When our user try
to make changes to file in public folder there can not make the changes it
say “file is read only” but that user can make the changes or edit that same
file from the P.C were office XP is installed.
Do I have to install some patch if yes can you please send that
patch because in trying from last two day and I can not find it.
Note: If possible can you reply on firstname.lastname@example.org
Just a guess...
Are you s...How do I convert a list to an Excel file?
I have a WORD file with 48 lines of comma delimited data in the form:
I would like to convert the WORD list to EXCEL.
When I attempt to open the WORD file in EXCEL, I thought a conversion window
would appear....what I actually get is "incorrect format"
Save the WORD file as a plain text file.
Then, when you open the file in Excel a Wizard will open
and step you through it. Just select COMMA as the
>I have a WORD file with 48 lines of comma delimited data
in ...access 2000 to 2003 files
I have many databases created in Acces 2000 on a comp.
w/98SE, which always worked fine. I copied these files to
new comp. running XP home, and using MS office Prof.
When I attempt to open these databases from Windows
explorer, I get anerror saying the <path><filename> is
unrecognized. Anyone know why?
"Rick K" <email@example.com> wrote in message
> I have many databases created in Acces 2000 on a comp.
> w/98SE, which always worked fine. I copied these files to
> new comp. running XP h...XML extension cause file download loop
Suddenly. When I click on an XML file expecting it to open in IE, it begins
the file download screen, then attempts to open IE. These 2 screens flash in
an endless loop.
What's up with that???
Any ideas are welcome!
Sr. Software Developer
E-mail correspondence to and from this address may be subject to the North
Carolina Public Records Law "NCGS.Ch.132" and may be disclosed to third
*****...Importing data from other files
I�m new to Excel so I don�t know if this is really easy to do.
I need to collect data from maybe 1000 different statistic excel files.
They are all similar in structure and looks, but ofcourse they contain
different numbers. Now I need to collect the data from a certain row
and column from the group of files and make some calculation to present
statistic data in a new Excel document. This brings to questions up to
1. How do I do to get the data into the new sheet if it's for example
position G25 in every single source file?
2. Is it possible to "flag" a different posit...How to export exchange global address book to WAB file?
I would like to export exchange address book to outlook express address book.
How to export exchange global address book to WAB file?
> I would like to export exchange address book to outlook express
> address book. How to export exchange global address book to WAB file?
I don't know about wab files, but see if
http://www.slipstick.com/exs/portagal.htm helps at all.
...cannot view all of text in large cell, even though I have it to w.
I have cell format to wrap text and it works fine to a p[oint then no more
text is displayed....casn increase the size of the cell, but still only so
much will display....rest of the cell show blank.
+the limit is 1024 characters. You can extend this with manually inserting
linebrekas using aLT+ENTER
> I have cell format to wrap text and it works fine to a p[oint then no
> more text is displayed....casn increase the size of the cell, but
> still only so much will display....rest of the cell show blank.
...corrupted PST file
I have Outlook 98, running on XP, on a PII 400Mghz Dell
desktop. My PST file is about 1.95GB. It has been
running extremely slow, and has had to be restarted a
bunch of times in the past 2 weeks. Yesterday, it gave an
error that the PST file was corrupted, and that PST file
need to have the Inbox Repair Tool run on the file, and
then the system restarted. I ran the Inbox Repair Tool on
the PST, and it did not work. I am totally unable to use
the file, which has all my critical contacts and emails.
If someone could help out, I would be MOST grateful.... I
pulling my friggin ...Separate transactions being merged when importing QIF file
I downloaded a QIF file from my bank dating back to 01/01/2004. When I
imported this file into Money 2005 the balance was way off compared to the
bank's website. In comparing each tranaction I noticed some were missing in
Money. Each group of missing transactions were all on the same day and for
the same amount. Also, for each group one transaction would be in Money and
the others missing (ex. There are 5 transactions according to the bank but
only 1 shows in Money). I opened the QIF file in Notepad and can see the
multiple transactions that were missing in Money. Based on this info...Shared offline files
Does anyone have experience using shared workbooks in conjunction with
the Win2000 Offline Files feature? We used to use the Win95/Office95
briefcase function successfully, but with the advent of Office 97 shared
Excel files wouldn't merge. Spent time with MS tech support documenting
the problem but was never fixed. Was hoping functionality had returned
in Office/Windows 2000.
Thanks in advance,
...recently opened files in the Open section of the Task Pane
In Excel2003, how can I remove the list of recently opened files in the Open
section of the Task Pane?
On Feb 28, 12:42 am, "Jeff Hopkins" <atomic58"NOSPAM"@sc.rr.com>
> In Excel2003, how can I remove the list of recently opened files in the Open
> section of the Task Pane?
This is a same list as Recently used files list under File menu. Go to
Tools -> Options, and under General tab remove checkmark at Recently
used file list. You must restat excel after this to change take
I have TextBox1 with this Value = 57.7
I need do something like this
MyNewVar = CDbl(TextBox1) .... but this is Type mismatch error 13
I need transform text value to number value.
I found the problem.
I need transform 57.7 to 57,7
"Tom" <firstname.lastname@example.org> p�e v diskusn�m p��sp�vku
> I have TextBox1 with this Value = 57.7
> I need do something like this
> MyNewVar = CDbl(TextBox1) .... but this is Type mismatch error 13
> I need transform text value to number value.