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....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...Converting a Microsoft Word document to a PC document
Operating System: Mac OS X 10.5 (Leopard)
I have created a Resume and a cover letter in Microsoft Word on a Mac to be uploaded to the Institute ORACLE recruitment system. <br><br>When I checked how it looked, the format, the bullets and formating were blown apart! I was told to convert the documents to PC format. <br><br>I don't know how to do this. I got some guidance to make them PDF files, but the formating still goes haywire! How do I do the conversion on my Mac?
The most important thing to do is DO NOT TEL...Convert date to months
I have a database that has multiple dates in it. What I am trying to do is in
one field I have a date and I am want that date to convert to months in
another field. Can anyone help me on this.
Message posted via AccessMonster.com
are you trying to find months between dates? or convert 4 to April?
Look at format function for ways to display months, datediff function for
"bohon79 via AccessMonster.com" <u35329@uwe> wrote in message
>I have a database ...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.
> ...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...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"...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...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 ...Need to convert point on screen to various screen resolutions
Let's say you click on a button on your screen at 1000,2500 TWIPS and your
resolution is 800 X 600. Now you change your screen resolution to 1024 X 768
and you need to click on the same button in it's new location on the screen.
Who's 100 times smarter than I am and can do some tricky math that will tell
me the TWIPS to find that button?
I'd ned to do the same calculation for other screen resolutions like 640 X
"Donna YaWanna" <email@example.com> wrote in message
news:%23HMLEWW2...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" <firstname.lastname@example.org> 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 email@example.com
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" <firstname.lastname@example.org> 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.
...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
Regard...open Outlook 2000 .ost file in outlook 2000
Does anyone know how to open a .ost file that was created
and saved from a different account?
Yes - see www.exchangerecovery.com
> Does anyone know how to open a .ost file that was created
> and saved from a different account?
...Money 2004 files to back to Money 2000 program
My computer in Florida has Money 2004. When returning to Wisconsin I tried
using the Money 2004 files with my Money 2000 in Wisconsin but the program
would not open because it asked for my "Password". I have never used a
password before and don't have a password. I have been using Money programs
for 5 years and this is the first time I have had any problems. Any ideas?
Joseph R. Ferris (Joe)