should I learn Excel ?
I've just completed a college class about Word , Should I learn about Excel ?
Only you can answer that. Do you learn Powerpoint, Access, Visio, MS
Project, etc., etc.
Excel is a widely used product, as is Word, and it can be a useful tool to
have in your skills toolbox, IF you are looking to find employment in a
field where the sort of number analysis that spreadsheets are good at. But
it is a complex product, and it will take a fair amount of effort and
practice to develop worthwhile skills in the product.
It can also be fun, worth learning just for the joy of learning another
product....Anyone use Mailwasher?....
If so does anyone have problems with their outlook form time to time
If so is the kind of problem when outlook won't find your pop servers?
Not sure if this helps, but I love mailwasher...
Turn off your automatic receive. Use mailwasher with 2
minutes or so receive, after you open it when you see new
messages in the taskbar, clean up and confirm THEN press
F9 in outlook to receive mail.
p.s. get the pro version, its worth the 20 bucks!
>If so does anyone have problems with their outlook form
time t...Using Time in formulas #3
Thanks for the link. I found that if I add 0.042 I'll get the nex
hour. Every so often it needs to be adjusted to 0.041 instead.
SPenney's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=107
View this thread: http://www.excelforum.com/showthread.php?threadid=26920
...Import from Excel fails after A97/A2K conversion
300 sConnect = "[Excel 8.0;HDR=YES;DATABASE=" & sFile & "]" & sTable
310 Codedb.Execute "INSERT INTO tblCB_Cashbook_Import SELECT * from " &
sConnect & ";", DAO.dbFailOnError
After conversion from A97 to A2K, the Import fails with message:
Field 'tblCB_Cashbook_Import.strCreditor' cannot be a zero-length string.
Same spreadsheet: blank fields were accepted as null by A97, but rejected by
Offhand, I can't think of any convenient way to make the import work again.
We will have to change the tmp table field specific...Using Foxpro from within Ms Excel using macros
Does anyone now how to incorporate the foxpro code "=sys(3050,1,100000) into
a VB macro so that the remote machines I am using restrict
foreground/background buffer memory. The following is taken from Microsoft's
"Using the commands COPY, APPEND, DELETE, INDEX, PACK or SQL-SELECT on a
large table in Visual FoxPro causes long pauses while the data is being
manipulated. The hard drive continues processing the data, but Visual FoxPro
seems to be inactive. This happens because computers that have large amounts
of RAM and are running Windows 95 or Windows NT g...Trying to use the INDIRECT funtion with a relative Row reference
I have a worksheet where I have rows of information. Each row is made up of
several columns of information. I am constantly updating the information by
inserting cells and moving the old cell to the right. I am trying to use the
INDIRECT function to reference the "G" column but I need the row number to be
relative because I sort the worksheet based on the information I get back.
INDIRECT works great until I sort then it is still refering to the row where
the information WAS at. . .not where it is NOW. I hope this makes sense and
any help would be greatly appreciated.
Tha...Access Version being used
This work only if the version of Access matches the version of Excel. How do
you detect the Access version being used?
Private Sub CommandButton5_Click() 'Go to customer database
Dim X As String
Dim nVer As Long
nVer = Val(Application.Version)
If nVer = 11 Then
X = Shell("C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE
If nVer = 12 Then
X = Shell("c:\Program Files\Microsoft Office\Office12\MSACCESS.EXE
If nVer =...I clicked a wrong button...am I destined to never use outlook now?
So I was trying to set up my new copy of Outlook 2007...I clicked on exchange
server instead of web based email system...now every time I open outlook it
says "cannot connect to exchange server" then it gives me the server
location and mailbox name, which I've tried to change...but then it just says
"cannot connect" and shuts down the whole program...how do I get back into
the setup page to fix my blunder?
I even tried uninstalling it and reinstalling it, but I guess that gets
saved? Wierd as all heck....Any help would be welcome....
Tools | A...adding a 2nd look up field to a form or table
I am using Access 2003:(
I am creating a database for multiple users.
I have a table for case status that is used to indicate different types of
cases. There are 4 common status types that are already listed in a drop
down list, and only a handful of "other" types that are only used a couple
times throughout the table. In order to limit the "other" types to be
entered and to limit the data that might be entered in this field I want to
create a table of "others" that would be used if "Other" is chosen from the
1st drop down list of status types. ...Retreive emails Using MAPI in VB using Outlook 2003
Till outlook 2000 we had a way to retrieve emails by
Reconfiguring Mail Support. Clicking the Corporate or
Workgroup option you can download mails from a VB
application automatically using MAPI and other Outlook
objects without ever opening Outlook.
This doesnot happen in Outlook 2003 and there is no option
like this to set.
Can any one please help me.
Outlook 2003 is already in "Corporate" mode, and MAPI subsystem is
always installed even if you use Pop3/Smtp account only.
MAPI spooler is integrated into Outlook 2002 / Outlook 2003 (it...Cannot Open Excel 1.x File
trying to open 1989 floppy disc - message popup is
cannot open normal document created in Microsoft Excel for
the Macintosh version 1.x
Am able to open word documents on same floppy but need the
any advice is welcome.
We're using the macintosh powerbook 3400C with Excel 98
try savinf the file first to a harddisk. NEVER open an Excel file
directly from a floppy disc
Nancy Owens wrote:
> trying to open 1989 floppy disc - message popup is
> cannot open normal document created in Microsoft Excel for
...Excel: Backup Copy not same size as File
I have the create backup option checked so excel creates
backuup everytime I save. Sometimes (cannot pinpoint when
this is caused) when I save file the file is saved. File
size is 4 MB. But the backup created is like 200K for
this. When I look at the backup file 1 worksheet is
missing and remaining everything is present.
Any ideas?? Thanks
...A useful tool for use with Visio (or almost any program)
For a while I've wanted to create a demo of the operation of some of
my software products and someone recommended a program called Wink for
creating Shockwave Flash files, well, I've finally tried it out with
Visio and it works really nicely. It would certainly provide a very
useful way of showing dynamic screenshots of problems or ways of doing
something that couldn't be shown with a single image file.
I've got a demo of the output from Wink at
and click on the Shockwave Flash demo link
You can get Wink at:
http://www.debugmode.com/win...Populate Chart/Graph Using Report Fields
Group: I have a graph that was created from a query which pulls from
linked tables with ODBC. When I create a report, everything populates
correctly in about 10 seconds, but when I try to create a graph using
the same query, Access runs basically forever (over an hour) until I
hit <Ctrl><Break>. The issue seems to be with Microsoft's graph object
and ODBC, so my thinking is if I can create a graph utilizing the text
boxes in a report, then there won't be a link between the graph and
ODBC, only the graph and the report fields. Then I could make the text
My ...Macro is Excel to populate a word document
Guys, I appreciate if you could help me do the following:
I have a table of data in excel and need to be able to click a button
in excel that will run a macro and send that data to a word document
(In the form of a table)
Thanks a lot
...How to rename messages using rightclick
I might have mentioned this previously, but our office recently got new
computers. The upgrade from Windows 95 to Windows XP came at a
we had to *downgrade* from MS Exchange 97 to MS Outlook 2000. So
naturally some things just don't work the way they used to.
Here's one: in MS Exchange, you could rightclick a message in the
message list and select "Rename" to rename it (you change the subject
line, other words). In MS Outlook, no such option seems to exist (I
even tried the customisation options). You have to open the message,
click on the ...VBA Open a Form upon Startup
I have other users, using an excel spreadsheet that I have created, bu
when they first open this spreadsheet I want a message box / Form t
appear straight away.
I have already created the form.
Any help appreciated.
Message posted from http://www.ExcelForum.com
In VBA double click on "ThisWorkbook"
Change the dropdown box at the top from "(General)" to "Workbook"
Change the other dropdown to "Open"
Private Sub Workbook_Open()
Change userform1 to whatever your form is
Alternitivly, you could always use msg...Insert data using a query?
I'm not sure if what I'm asking is even possible but here goes. I have a
table that contains employees and the company they work for. I have created
a query on that table to identify those employees who dont list their company
based on their employee id number. Example, employees with an ID number of
2000 - 39999 belong to a specific company, so I use the query to find all
employees with that ID number range and is null for the company name.
Now my problem. I want to use the query to update their company name, since
I know that all employees with an ID number of 2000...use only SMTP / use only POP
I forward several Email accounts to Gmail. Now I would like to receive
all these mails from Gmail (POP) but send my mails via the SMTP server
of the original account providers.
When I try to set the POP server to (empty), Outlook does not allow me
to click 'next'.
Thank you for your help!
derobins <firstname.lastname@example.org> wrote:
> I forward several Email accounts to Gmail. Now I would like to receive
> all these mails from Gmail (POP) but send my mails via the SMTP server
> of the original account providers.
> When I try to set the POP server to...Macro error after switching from Excel 2000 to Excel 2003
My company recently switched from Excel 2000 to Excel 2003 and now a macro I
created does not work. It gives me the error 1004 and highlights the line of
code where I set it up to open certain files in a folder. This macro has
been working for 6 months without fail and only has problems opening the
Excel files I created after the switch to 2003. Any help would be
Without any other info the only suggestion is to see if your sheets
have different names.
For example, a statement like:
Sheets("Feb Sales").Cells(i, j+5) = k
might cause a 1004 error if the new workb...Cell references in excel vba code
I have a lot of code in the form;
Sheet4.Range("S" & iCount).Value = Range("B20").Value
Sheet4.Range("T" & iCount).Value = Range("C20").Value
Sheet4.Range("U" & iCount).Value = Range("D20").Value
Sheet4.Range("V" & iCount).Value = Range("E20").Value
works fine but I can't easily add columns to the sheet as all the
references are then wrong ! Bad design, I'm sure.
What can I do about this - can I reference columns differently ?
Any other ideas ?
Help would be most welcome.
...How do I insert best quality Access report into Publisher?
I am creating a booklet in Publisher 2003. I have many Access reports that I
want to include as part of the Publisher booklet. I have tried creating a PDF
and selecting and some other methods but the quality is not nearly as good
when copied and pasted into Publisher. Any ideas on how to take an Access
report and copy/paste or insert into Publisher where there is very high
Right-click the report in Access, export, save as .rtf or .txt.
In Publisher, create a text box, right-click, click change text, click text
file, browse to the report.
http://msauer.mv...how to write unicode using XMLWriter?
I need to write some unicode symbols such as degree symbol
(for example 36=B0) by using XMLTextWrite but couldn't make=20
it work. I found the degree char in unicode is '\u030A'=20
and here is my sample code:
char myChar =3D '\u030A';
string myString =3D "36" + myChar.ToString();
it doesn't work.
"Linda Chen" <email@example.com> wrote in message news:firstname.lastname@example.org...
> I need to write some unicode symbols such as degree symbol
> (for example 3...MS Access Data Entry Forms
I am in the process of building a form in MS Access 2000. The form is
similar to a purchase order or bill of laiding. The top of the form has data
entry fields as follows; Vendor Name, Vendor address, PO #, and Date (Ect).
On this same form, I want to enter one, or multiple PO or Bill of laiding
line items which will contain the following fields; part numbers, part qty's
for each part number, and part weights for each part number. I don't want to
enter all of the form info entered at the top of the form for each of the
part numbers, so how would I make the form and associate...excel #147
somehow the column headings changed from letters to numbers. how do i change
them back to letters
tools / options / general / uncheck r1c1 reference style
> somehow the column headings changed from letters to numbers. how do i change
> them back to letters