Excel 2003 - Importing External Data
I have a spreadsheet that I have been importing data into (from another Excel
spreadsheet). Everything was going smoothly with importing (text in some
columns, dates and numbers in others) until data in one of the columns
changed. The data used to be only a (work order) number. Now, the entries
have a letter or two before the number. None of the newly formatted work
order numbers (for example, T00058) are populating in the spreadsheet, the
cells are blank. If I change the number to "58", it will transfer, but not
with the T in front. Please help!
it looks like t...Installer problem
One of my XP Pro (SP3) machines has stopped being able to install
applications from CD using the InstallShield installer. The installer
launches, but when the user selects an option nothing happens. The issue
occurs both using the CD drive itself and installing from a network location.
Some downloaded application have installed with no problem, so the issue
seems to be specific to the particular installer.
Any suggestions as to trouble shooting procedure would be greatly appreciated.
Instashield installer works with windows installer,is windows installe...Problem in handling event of Data Grid
I am using datagrid control to display the data.
I want to know the content of the the cell on which mouse
For this I am handling "OnRowColChange" event of the
But whenever I select one complete row by clicking on the
row header it gieves following error:
[The instruction at "0x24ed2ec4" referenced memory
at "0x000c015c". The memory could not be read.]
Can any body suggest any solution, or suggest any other
grid control which support ADODB and edit at run time.
...Outlook has encountered a problem, needs to close
I am using Outlook 2000 with WinXP Pro. For the past three months I have
gotten an error message, up to 20 times a day, indicating it is experiencing
problems and must close. I have downloaded all updates, uninstalled and
reinstalled and still experience the same problem.
The Event Viewer reports two errors:
1. Faulting application outlook.exe, version 126.96.36.1996, faulting module
msvcrt.dll.version 7.0.2600.2180,fault address 0x00036f07.
2. Faulting application outlook.eve,version 188.8.131.52004.faulting module
ntdll.dll.version 5.1.2600.2180, fault address 0x0001142e.
S...list view problems
basically I have a few questions CListViews that I'm trying to use:
1. are the rows uniform in height, and rowheight cant be adjusted?
2. How can I set column width as per my wish. i tried SetColumnWidth and
3. is there a setting so users cannot resize the column or in other words
make column width fixed?
Thanks a lot.
1. There are several ways by which you can set the row height of a list
Create an owner-draw list control and handle the WM_MEASUREITEM message,
and set the itemHeight attribute of LPMEASUREITEM struct.
Create a C...Newsreader problem...
I want to be able to invoke the Outlook Express Newsreader from my default
e-mail program, Outlook 2003. Help in Outlook 2003 tells me to put the
"News" command in the Outlook 2003 Go menu as follows:
1. On the Tools menu, click Customize.
2. Click the Commands tab.
3. In the Categories list, click Go.
4. In the Commands list, click News, and drag it without releasing the
mouse, until it rests over the Go menu.
5. When the menu displays a list of commands, point to where you want the
command to appear, and then
release the mouse.
But, what do I do if there is NO "News...Star TSP 700 USB receipt printer
Is anyone using this printer? I tried to use the raster driver and can get it
to print a receipt but it doesn't pop the cash drawer. When using the OPOS
driver for the printer it only shows COM port choices not USB. The cash
drawer does pop if I use a parrallel TSP 743 printer and the OPOS driver.
Use USB and go into printer options and under raster it shows cash drawer
"Pat@arms" <Patarms@discussions.microsoft.com> wrote in message
> Is anyone using this printer? I tried to use the raster driver...OWA problem
The users in our organization can't delete emails when
they connect to the exchange server via OWA. These emails
are always mass emails that have also been giving us
problems when using outlook 2000 but can be deleted with
the preview pane turned off.Some of our users can only
access thier email via OWA and can't get rid of these
problem emails. Has anyone else run in to this problem and
foung the solution??
YOu might want to post this in an Exchange group.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to the
Swen virus, al...Date problem #2
I am trying to add a date function to my spreadsheet. I want it to
display the date that a certain value was entered. So far, all attempts
have resulted in a date that reupdates everytime I reopen excel. Is
there a function that will insert current date and make it static?
Your post has an April 6 date on it and today is only April 2. Did you check
your PC clock 1st? That may fix your problem.
"Drew Reed" <email@example.com> wrote in message
> I am trying to add a date function to my spreadsheet. I want it ...SAFEARRAY Problems
I've run across a problem with MFC and OLE.
I have a class that I've added by "MFC Class by TypeLib." All class methods
work except the ones that require me to pass in a SAFEARRAY. When I do pass
in a SAFEARRAY, I ALWAYS receive a COleException indicating I have a type
In the OLE/COM Object Viewer, for example, one method is of the type...
[in] long NumItems,
[in] SAFEARRAY(long *) Handles,
[out] SAFEARRAY(long) * Errors);
When creating the class through MFC, it defines it as follows...
void Remove(long NumIt...budgeting problems
Money 2004 Deluxe is my first experience with finance
software. I like many things about it except that it
can't get my budget correct. I use autobudget for most,
but not all my income/expenses like the directions say.
All the way through creating and editing of the budget,
my numbers seem good. The problem arises when I click
finish and enter into "Review your current budget status"
My money file dates back to the end of May. My income
and expenses budget are almost the same at about $5,500
per month. I tried desparately through august to get my
budget correct to n...USB
Anyone have suggestions on good sites/books on accessing the usb port from
Windows application? Would like to access a usb port as a serial or parallel
Normally you access the USB port via the device driver for the specific
device which is attached to that port (unless, of course, you are writing
the device driver for a new device). I'm not sure that it's meaningful to
attempt to" access a usb port as a serial or parallel port" without
knowledge of the device you are trying to communicate with.
Is it possible to have a USB to rs232 device attached...Problem upgrading
I trying to migrate from 3.0 to 4.0 and i got this error and i have no idea
what is the problem any one can help me please
this the end of the where i got the message log
17:32:47|Verbose| Retrieving information from database
Catalog=Continex_MSCRM;Integrated Security=SSPI ...
17:32:47| Info| Query row count: 0
17:32:47|Warning| Check CrmV3CustomizationUnpublishedValidator : Warning: El
programa de instalación ha detectado personalizaciones en el sistema actual
que no han sido publicadas. Si continua, estas personalizaciones se per...How do I enable USB ports?
I'm on a computer that was origionally intended for public use but is now
used in an office and as a result of being intended for public use, it's set
so that nothing connects to the USB ports. If I plug in a drive, it lights
up, so there is power to the USB ports, but it doesn't show in My Computer.
So how do I enable the USB ports? What icon do I go to in Control Panel?
Or, in case that icon isn't there, in what subfolder of Z:\User would I find
the file that opens the needed panel?
Enter the BIOS and re-enable them.
Im new in your forum and also in Vista World!
I got a Hp laptop AMD Turion x2 64 2.00 Ghz, 2 GB Ram, 250 GB HDD!
Im having a problem, since my laptop is new, i couldn't install other OS
except Vista (or i could manage it with some serious changes on the
system, which i didn't accept to do)
So, since I'm new in Vista i don't know much about that! Im having a
issue with this laptop a kind of System Restore every time I restart my
In case that I don't know that the SR is, let me explain my problem
For example: My default folder view is show...IF then problem for beginner
I have five cells that show
6.03% 3% 3% -0.07% and 7440
If any of the first four cells contain a negative number,
how would I display "warning" in the fifth cell instead
The "" will make the cell blank if d2 is greater than 0.
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
E1 =IF(MIN(A1:D1)<0,"Warning", 7440)
In article <085201c3a7bc$d...Got problem with CView::Create
I had a class. It works so good on my many demo applications. But when I add
that class into other application, it doesn't work. It got error at line:
if(!CView::Create(NULL, NULL, WS_CHILD | WS_VISIBLE, rectClient, pWnd,
(Error message: Unhandled exception 0xC0000005: Access Violation)
Somebody help me please! Thanks for reading! Have a nice day!
Well, that access fault happens on a specific line of code. Note that you cannot use the
syntax below because CView::Create is not a static method, so I have no idea what this is
doing because you have shown no co...Blackberry/ Outlook Calendar Duplication Problem
We've been having this wierd Outlook/ Blackberry problem. I am configured for
aireless Calendar Sync. Someone sends an appointment request, I accept on
Backberry, and the appointment shows up in the Calendar both places; then I
accept on Outlook, it dupes... THEN i go to Deleted Items on Outlook, re-
accept, the dupe disappears!
Strange. Anyone seen this?
I have similar problem
> We've been having this wierd Outlook/ Blackberry problem. I am configured for
> aireless Calendar Sync. Someone sends an appointment request, I accept on
> B...Maintaining Order of Songs Synced from WMP to USB Stick
Hi There, I'm a novice, and I thank you for reading my message.
I've been creating Sync Lists of Songs, with the songs mixed in a
particular order I desire. I then name the playlist. I sync the lists
into my USB Stick 1GB without shuffling, but upon playback the order of the
songs in the playlist have been altered. In fact, they are played back in
the order of the artist. Is it possible to sync the playlist exactly as I
mixed it, and have the USB Stick playback the exact mix of song order
accordingly? Or is this an impossiblity? Thank you for your help and...problem opening publisher 2003 document
(I posted this question on a user group thread yesterday - 11/066/06, but
have been uunable to locate the thread - so here goes again)
I have tried to email a Publisher document to another computer, both of
which have Pub 2003 installed.
I have been successful with other documents, but this one gives the
recipient a message that Publisher cannot open this version”..
The document in question was indeed originally written using Publisher 2000,
but has been modified and saved many times over the years in P-2003, and I
have no problem opening it at home.
Is there a way that I can save it ...Problems!
Anyone seen this before? My ISP says their mail server is
fine. I can rcve anything, just can't send out anything
over about 60kb attachment!
"Your server has unexpectly terminted the connection.
probably cause is network, server, et....
email stays in the outgoing box but also shows as sent.
go to microsoft exchange and change your limits to 'no
limit' for both outgoing and incoming mail.
>Anyone seen this before? My ISP says their mail server is
>fine. I can rcve anything, just can't send out anything
>over ...USB problem
Running XP-SP3 with all updates current. I have a WACOM tablet, driver is
latest version; plugged into a USB port in rear of DELL PC. I'll boot up and
get error message,"USB device not recognized...". I check Device Manager and
no flags are showing. I simply plug into another USB port and I get message
that "Human Interface Device found" and my tablet now works. The next day I
boot up and the same error message pops up and the fix is to reverse what I
did the previous day, just plug back into yesterday's "bad USB port". Any
ideas what I am ch...Problem with Worksheet_Change
I have a "Home" worksheet with a hyperlink to another hidden "Test"
worksheet. The test is timed and will display "STOP" in cell "u1". In the
sheet code module, I have a subroutine to recalculate so the time elapsed is
Private Sub Worksheet_SelectionChange(ByVal Target as Range)
I want to use "STOP" as the trigger to return to "Home" worksheet which will
display the test results. I've read some of the other postings and tried the
procedures but it doesn't work.
If this isn't...Outlook problems and bugs
In Outlook Express you can view a message's headers and HTML source by right
clicking on an email header and choosing 'properties.' Is there any way to
do this in Outlook? This is a useful feature and I can't believe that it
wouldn't exist in Outlook. I get a lot of possible spam that I want to
examine before opening. I am detecting viruses in my email just about every
day and I am being cautious.
I had to reinstall my OS a couple of weeks ago -- so I backed up my folders
in Outlook and then imported them back into an new installation of Outl...Tab control problems
I am creating a form that has 2 tabs on it, one for entering packing data,
the other for entering nutritional data. I now want to divide up the fields
from my database onto the 2 tabs, some fields are for one, some are for the
other. I have gotten a lot of the fields in the right place and everything
looked good, but then all of a sudden certain of the controls were appearing
on BOTH tabs, and when I would delete it from one tab, it would be deleted
from the form completely. This is probably something extremely simple, but I
am just not seeing it.
Thanks in advance for the help.