No blank lines in text files #2
When opening a comma delimitted file, I don't get blank lines anymore. In
Excel 2000, if a line in the text file was empty I would get an empty row in
the new spreadsheet. Now all non-blank rows are jambed together in one
column! How do I get Excell2003 to opoen Comma Delimitted files properly
(including empty lines?)
Oops, managed to send the same question twice! How can one delete a subject?
"Charlie Gotwald" wrote:
> When opening a comma delimitted file, I don't get blank lines anymore. In
> Excel 2000, if a line in the text file was empty I would get an empt...font #2
Is there anyway to enlarge the font of the F screens. When using the F5
and others, the font are so small.
About all you can do is reduce the screen size of your monitor. If you
change from 1024x786 to 800x600, the fonts will appear bigger, but you
will loose real estate at the right and bottom of the screen. The only
way to modify the built in screens is to find an add-in that replaces them.
You could also try the windows screen magnifier - part of the
accessibility tools in windows...
Tiber Creek Consulting
glenn@tibercree...Changing password #2
If I change a domain user's password, will that user's
Exchange Server 2003 mailbox's pssword be changed too?
I mean, does Active Directory share the same password
with Exchange Server 2003?
Exchange never had passwords separate from domain, not even in Exchange
4-5.5 era. So you would change just one password, which belongs to AD
> If I change a domain user's password, will that user's
> Exchange Server 2003 mailbox's pssword be changed too?
> I mean, does Active Directory share the same password
> w...Error when opening .csv files
Whenever I try to open up a .csv file in Excel (2000) by
either double clicking on the file or use the "Open"-menu
it opens up the document without separating the columns at
Everything goes into the first column.
If I rename the file to become a .txt-file and then open
it up in Excel it works just fine as long as I change the
separator to a comma sign.
What could be wrong?
I'm guessing that the list separator in the file is different from the list
separator inside your windows setting.
You could either continue doing what you're doing or...Convert PNG file to Bitmap without a DC?
I'd like to store images resources as PNGs due to the compression over
bitmps. To load such a resource and get it converted to a bitmap for the
eventual Blit to my screen DC, I basically want the equivalent of
LoadBitmap. Better yet, I was thinking I would create a CBitmap derived
class "CPNGImage" that would have a "LoadPNGResource" method much like
CBitmap's LoadBitmap method. So far so good.
The stumbling block for me at this point is that the process of converting
the PNG to a bitmap seems to require a DC compatible with my device. This
is neatly enc...Re-arranging table using pivot-table?
I have a worksheet with data organized somewhat like this:
New York New York
New York Albany
California Los Angeles
California San Diego
I need to convert this to a list of states and each city in the columns to
the right of their corresponding state. Something like this:
New York New York Albany
Florida Miami Orlando Tampa
California Los Angeles San Diego
Any help is greatly appreci...Re-install Outlook 2002
I am trying to re-install Outlook 2002 for my palm pilot
after a crash. The installation will run until I get the
message - "another version is already installed and must
be uninstalled". The previous version was corrupt and I
was unable to uninstall it. Now when I go into the control
panel to add/remove the uninstall is no longer in the
...Saving files when closing Excel
Excel does not prompt for saving changes when closing a file after changes to
the file have been done.
have you checked that there's no event macro in your file?
Jonathan Gold wrote:
> Excel does not prompt for saving changes when closing a file after
> changes to the file have been done.
...access file to exe file
May i know the procedures on how to make access file to an
executable file. I read a lot of Access books from 97 to
XP versions but i was not able to find any.
thank you very much and anticipating your response.
> May i know the procedures on how to make access file to an
> executable file. I read a lot of Access books from 97 to
> XP versions but i was not able to find any.
I tried a number of converters to translate Access into Visual Basic, all
with limited success. Even when I was able to get a form working it required
as much time to tweek it a...?�Z�k ?��??�ra? ??�s?�� #2
...Query not found in Dataviewer Business Portal 3.0
I am new to BP...and working my way through it.
I was in the INVENTORY section and was modifying the queries to show all
rows and no "Pick a Task" section.
When I clicked "apply" I was returned with "One or more errors have
occurred....Can not change Web Part Title due to a save error on the foler.
/DataViewer/Item List-Item List".
NOW I cannot get ITEMS>view Inventory Information to work. Dataviewer shows
a folder marked Item List-Item List/Item List but the whole thing doesn't
appear to work.
I need to help in fixing.
Thanks ...If Function help #2
I have what should be a simple IF then formula, which is copied below,
where both criteria must be met: Z9 must be true and S9 must = COS.
Any assistance why this isn't working would be greatly appreciated.
What is contained in Z9?
Maybe you need
<firstname.lastname@example.org> wrote in message
>I have what should be a simple IF then formula, which is copied below,
> where b...RE:Excel will not open from a web link
When opening a link on a web page that has an Excel
Spreadsheet embedded in it, the spreadsheet will not open
up Excel but opens within another browser as an Excel
file. Programming on webpage is correct, opens up on
other machines just fine.
...summing number of 'y's in a filtered column #2
thanks domenics one seems to be workin
neowok's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=594
View this thread: http://www.excelforum.com/showthread.php?threadid=31434
...Problem opening files in excel with a specific account
We have problmes opening a couple of files in excel, without any specific
error message. The application just "hangs". When we log on to WXP as
another user, the files work fine.
We have re-installed excel, deleted and recreated the user profile which has
problems, but still no luck.
Anybody got a clue why this is happening?
The computer excel is running on is a DELL Optiplex Pentium HyperThreading
Thansk in advance.
Sometimes cleaning up the windows Temp folder will help.
If that doesn't help, sometimes the file that contains the toolbar
customizations...how do I embed files to tabs in a worksheet?
not sure what you mean, a worksheet is a tab in a workbook (sheet1, sheet2,
etc) do you want the worksheet itself to have tabs?
> please help...
...Can't upload a file from my system
Using IE8, Windows XP, and SP3. When I am asked to upload a file (resume)
from my system, click on Browse, My Documents opens then after about 3-5
seconds, My Documents window closes and I am not able to upload a file. This
just started within the last 2-3 weeks.
1. Start Internet Explorer without add-ons by right-clicking the IE icon on
the desktop. Choose Start without add-ons.
from Start> Programs> Accessories> System tools> Internet Explorer (no
If the problem goes away, a browser add-on is causing it.
For troubleshooting informa...how do i make a value entered be * 2
I want to make the value of the number I enter be * 2
example: if I put in 1 i want it to equal 2 in my sum in another column
can anyone help me
> I want to make the value of the number I enter be * 2
> example: if I put in 1 i want it to equal 2 in my sum in another
> can anyone help me
This is probably what you need. Enter this in, say, Cell B1
where A1 will contain any value that you want as your input.
BenjieLop's Profile: http://www.exce...Does XP have a file to decompress *.gz files?
I hope this isn't too off-topic. I have XP media center and
also XP home. Will these include a application to
decompress files with the extention GZ. I know Winzip
Jack from Taxacola (formerly Pensacola), FL
> I hope this isn't too off-topic. I have XP media center and
> also XP home. Will these include a application to
> decompress files with the extention GZ. I know Winzip
> doesn't work.
> Jack from Taxacola (formerly Pensacola), FL
philo ...Pivot Table #2
I have a database with type and age ranges in columns. Six age ranges. One
type column. The data (dollars), by type and age range are below each age
range column. I want a summary report that sums the dollars by type and age
combined. My preference is to have the sum of age ranges in the rows, the
type in the columns with the dollar sum of each type and age range in the
data fields. I hope to have the sum of the types for all ages on the right
and the sum of the ages for all types at the bottom. It seems simple enough
I don't seem to be able to make the table work?
If ...Re-Enable CRM User
I am trying to enable a disabled CRM user and I received the following error
message. Any thoughts or suggestions would be greatly appreciated.
String UserId) +0
Microsoft.Crm.Application.Platform.SystemUser.Activate(String id) +38
sender, DataEventArgs e) +127
eventId, FormState state, User user, String objectId,...Excel Icon for files
I am running Windows 2000 professional on my PC and connected to a LAN. I
am running the MS office 2000 Professional suite. When, I save a worksheet
from Exel 2000 it does not save the file with the common Excel file
Icon(green X). The file is displayed with the default Windows Flag Icon.
When I double click on this default Windows Flag Icon the system tries to
open the file with Word not Excel.
Word and PowerPoint both save with their common Icons. The Excel program
saved fine a couple of weeks ago. I have not installed any new software and
our server takes care of Virus protection thro...Business Portal 2.7 and eReq (print a PO, display GL account descr
Has anybody tried diplaying the GL acct description when you choose to viiew
a doc in eReg.
Also, has anbody been able to print or display the PO that gets creaed in
eReq from the eReq module without having to log inot Great Plains to get
access to it.
...Vlookups to Excel Version 3 files.
I use a system that on a daily basis creates an Excel
version 3 file containing cost centers and their budgets.
When I do vlookups from other Excel 97 files to this file
it takes a long time for the sheet to calculate. If I save
the Excel V3 file as Excel 97 its OK, and if the Excel V3
file is open before the 97 file its OK. I don't want to
have to constantly save the V3 file as 97 (I may not be
around to do that always)
Does anyone know how to resolve this.
...Thanks Ken Wright but one more question RE saving data from circular references
Thanks heaps for that macro Ken Wright .
I have run it and it works.
However it loops forever. Can I set it up so that it could save dat
from a certain number of iterations?
Thanks again Michae
Message posted from http://www.ExcelForum.com
If you stayed within your thread and did not change the subject
Ken would see your reply as a reply to his reply and would see
it a lot faster than when you start a new thread. Ken would
probably see your post highlighted in RED. Also someone other
than Ken might have been able to help you. (not me I avoid
anything that hints of circul...