Importing into Excel from a Text file
We have a text database of about 7,000 rings. It is in a fixed format.
Unfortunately some where we have about 4 or five rings whose format is
screwed up. We figured by importing to Excel, we should be able to find
where the records are to fix them. But, we just can't get the following
format to import into excel. If anyone can help us, we sure would appreciate
Each record begins with Begin Product
Each record endswith EndProduct
a semicolin seperates each record
Also there are para symbols at the end of every line
Herer are a...formula tu sum up to a number till 7
This is the data I have:
I want in column C to G cells to be filled till 7 starting to count
from B and then starting again. Result I want:
A B C D E F G
2 3 4 5 6 7 1
And so on...
How can I do this...
Thank you so much!!!
I don't fully understand this. Why do you not show 2 as the starting
value in column C? Why do you have a 1 after the 7? Is this the
corresponding value from column B? Would C2 start with 4 and continue
across until you next...hyperlink to existing excel file
When I create a hyperlink to an existing excel file and then click on it,
explorer opens to the folder that the file is in instead of the excel file
opening. Just to test I pointed it to a word document and the doc file
opened fine. How do I get a hyperlink to open the excel file? Thanks.
Are you sure it isn't to the folder instead. Only way I can reproduce that
is if I select the folder instead of the file when I create the hyperlink.
As expected if I use a hyperlink to a particular file it will open..
"purplehaz" <email@example.com> wrote i...Save for Web (.htm) file
I have two similarly structured XLS file. One file "A" is much
longer...perhaps 2000 rows long...when saved as a htm file it is around
500KB. I take another XLS spreadsheet that looks like the same
structure...rows and colums...only about 560 rows...when I save this as
webpage .htm it ends up being 11.2MB. What the heck happened? How do I get
it down in size. There is no apparent reason why a smaller file ends up
being 11 time larger that the smaller file when saved!
...Unable to open Windows XP
When I try to open my Virtual PC Windows XP on my Powerbook G4 it
comes up with an error that Windows could not open successfully. I try
to open it in safe mode and all of the other options available and it
still comes up that I am unable to open Windows. Any ideas how to fix
this or what the problem is?
You'll probably get faster & more thorough assistance if you post to
But they'll need much more specific information about VPC & OS X versions,
update levels, etc.
On 9/19/07 11:55 PM, in article
11...Outlook 2003, Relaying denied error, Windows XP
I seem to have a problem when Outlook 2003 is first opened that it will not allow an email with an attachment to be sent. A 'Relaying denied' error message comes up. If I send an email without attachment this works OK and triggers the Norton anit virus software to check email before sent. After this the problem seems to go away i.e. I can now send attachments.
Any ideas on why this error occurrs ? Is there a setup feature I've missed ?
Have you set up authentication to your outgoing server ("More Settings..."
on your account page, go to the "Outgoing Server&qu...point exchange to a different priv1.edb file
I have a snapshot of my priv1.edb file on a different drive. I know that
exchange 2003 lets us me the priv1.edb file to a different location if the
file isn't already there.
Is there a way to have exchange point to a different priv1.edb and use it?
On Thu, 5 Oct 2006 21:31:01 -0700, Han <Han@discussions.microsoft.com>
>I have a snapshot of my priv1.edb file on a different drive. I know that
>exchange 2003 lets us me the priv1.edb file to a different location if the
>file isn't already there.
>Is there a way to have exchange point to a differ...Customer Source for Certified Partners (Not MBS)
Does anybody know if Microsoft Cerified Partners (not MBS) can Access Customer Source or Partner Source? If so how do we get a logon?
...IF COUNTIF & COUNTA on Filtered Visible Cells #7
Hope this will help.
Correction to Last Posting:
My Helper Column "U" increments one Row at a time and says:
Check from Row above Current Row back to beginning of my "V" Range: i
the Room was used previously give me the Last (MAX) time it was used b
returning the relevant Row Number of the (text based) Group Nam
(Executive, Trainees, Manager, Graphics, etc.) that used the Room Last
The Helper Column "U" then passes this data to the Formula in Colum
"T" - it checks for the criteria within the specified Range and doe
the COUNT calculation us...Check Number format
In Great Plains our checks were initially set up with 20 zeros. For some
reason when running the Vendor check request report on some of the PC’s (on
screen and to the printer) the entire check number does not show up so it was
requested that we remove 8 of the leading zeros. I went into
Cards>>Financial>>Checkbook and pulled up the appropriate checkbook and
removed the leading zeros from Next Check Number and Next Deposit. When I
print the report, the zeros are still visible. Am I changing the correct
field or will this change not affect existing numbers in the report I...Hyperlink Error
I have a hyperlink set-up for a netwrok file. It works fine, but when the
file is copied the hyperlin chages to the folder that the file has been
original link - L:\folder\folder\file
Changes to - C:\file
How can I get it to keep the original link?
...Publisher 97 #7
Somehow I am getting the message: "ASSERT
File:Undialog.cpp Line 1396" when I try to open the
program. When I acknowledge, it crashes.
Tried reinstalling, with no effect whatsoever. Any ideas?
The only reference I have ever found for this error is from ZoomText. If you have
this product installed go here:
Otherwise it is a C++ extension.
Mary Sauer MS MVP
"Erik" <firstname.lastname@example.org> wro...getting a single line from a file
I was wondering if someone could tell me how to read a single line from a
text file. I tried using getline, but my MFC program does not recognize the
getline function. Nor does it recognize <string> or <string.h> or using
namespace std. So is there another function that I can use in MFC?
Take a look at the CStdioFile MFC class.
Check Abdoul [VC++ MVP]
"R.H." <email@example.com> wrote in message
> I was wondering if someone could tell me ho...Skinning Windows Media Player
I use to have a skin on my WMP that was called QuickSilver. I liked that skin
because it was compact and nice looking. Well I had to pretty much reformat
my drive a few weeks ago and now I only have 2 skins for my media player. I
downloaded the Rad skin and tried to apply it but it doesnt work.
I am using WMP 11 and when I go to choose more skins it brings up the page
and there isn't a restriction on which version I can use RAD on.
I'm just wondering why its not working and if anyone knows where I can get
the quicksilver skin I liked.
On Thu, 24 Dec 2009 20:50:01 -...Browser Problems in Windows XP
I am having problems getting Microsoft Explorer to work in
installations of Windows XP. In some installations it
works just fine and in some it will begin to go to the web
site and then the window closes with no error. Has anyone
experienced this problem before? I can log in with all
the user accounts from any windows 98 computer using the
same browser version.
Thanks for any help.
Eric Davison wrote:
> I am having problems getting Microsoft Explorer to work in
> installations of Windows XP. In some installations it
> works just fine and in some it will begin to go to the ...overwritten file
I have a client that overwrote an excel sheet. He did not
have autorecovery on. Is there any way to recover this
johnf202 at hotmail dot com
"mark" <firstname.lastname@example.org> wrote in message
> I have a client that overwrote an excel sheet. He did not
> have autorecovery on. Is there any way to recover this
Backup file is pretty much his only option if one exists. Has he perhaps sent the file anywhere
else that he can get a copy back from, or if so he could possibly still have a ...File Size #4
Using Windows XP and Office 2007
Is there a reason that Publisher files keep growing in size? We have a
weekly bulletin with some static information and some information that
changes from week to week.
On Monday, we open last week's publication, delete the no-longer-relavent
text boxes and pictures, and add new text boxes and pictures for the current
week. That has been our standard practice. I just noticed that the file
size is increasing exponentially which leads me to believe that even though
I delete things, there is still some sort of "ghost" material left in the...Preventing Excel files from being moved or deleted
What permissions setting is used to prevent users from moving or deleting an
Excel file on a network?
This is more of an network operating system setting question.
I would think putting the file on a share that the users only had readonly
access would be enough.
But this would mean that the users could still copy (not move) the file.
And they wouldn't be able to update the workbook.
> What permissions setting is used to prevent users from moving or deleting an
> Excel file on a network?
All explained in Start>Help and Support "p...Windows Live ID Problems
I have been using Money 2006 for the last 2 years. Since the online updates
stopped as of 9/1/08, I was prompted to download a new version. I downloaded
and installed MS Money Plus 2008. When I attempt to log in using my Windows
Live ID and password I get the following error: "The email address or
password is incorrect. Please try again."
I never had this problem with the older version.
My Windows Live ID and password work fine on this website and when I go to
the main passport website.
I am using Windows XP Home Edition, and have been for the last 5+ years.
I have re-...Windows Easy Transfer won't load files?
I ran Windows Easy Transfer on my laptop with Windows 7 RC1 to save and move
my profile data because Win 7 RC is shutting down. I am trying to install the
Windows Easy Tranfer data to Windows Vista Business. Each time I try it won't
read the file but keep asking for the drive with the data to be loaded. I
tried a test by moving the the data (.MIG) files out of the folder I saved
them to and put them in the root of the drive but that didn't help. I tried a
test of copying the files to the root of C: and now it actually sees the file
for the short test at home I trying in t...publisher 97 won't import a file graph of acceptable quality.
To MSFT: Let me try this again. I have Pub 97 that I must use
for writing a manual. I try to import a black and white graphic-a chart,
in jpeg or gif or whatever,but the graphic is of such poor quality that it
can not be used. This only happens in my Publisher program. I have tried to
change the adapter accerleration reading, but it does not help. Does anyone
else have this problem with the older version of Pub 97? Do you have this
problem with later versions of Publisher? Any ideas are appeciated.
Check your graphics filters. Might have some corruption going on.
They are in a folder sim...List of File Extensions
Is there a list somewhere that contains the file extensions used in Office
2003 applications? I need to backup files before re-installing my OS. These
include files that store settings, customizations, macros, Outlook address
...Making Design Gallery Objects available to other files in publishe
I created some custom objects and saved them to the Design Gallery, and they
did appear under My Objects. However, I saved the file and opened up a new
one and to my shock My Objects was empty. I opened the earlier file where I
created and saved the objects and they were still there.
Does this mean that the Design Gallery if file-specific and not saved in a
Publisher Application file for use in other .pub files? Perhaps that is the
default setting that can be changed later.
Please help me on this matter.
Thank you in advance for your support.
Alcide <Alcide@discussions.micr...Automatic open locked excel file through access control
We know,Excel has prompt password
to open it files.
Is it possible to create a code that can
supplies the excel prompt password?.So that when we
open the excel file through our access control in a form,
the excel files can be opened automatically.But when the
excel files opened from its default icon,it will prompt a
On Jul 10, 8:43 pm, "shiro" <s...@play.com> wrote:
> We know,Excel has prompt password
> to open it files.
> Is it possible to create a code that can
> supplies the excel prompt password?.So that when we
> open the excel file throu...Shortcut key for the Auto Sum, Max, Min, etc. window
I am trying to find the shortcut key(s) that lets me
change the setting/functionality of the Auto Sum, Max,
Min, etc. window in MS Excel.
The window I am referring to is located in the bottom
right hand corner of Excel, i.e. two places to the left of
the NUM (displayed when Num Lock is on) window.
Thank you for your help.
I think you may be referring to the AutoCalculate feature
which appears on the status bar when you have selected
cells with values in them. By default it gives the sum of
the cell values, but you can right click on the
calculation in the status bar to change...