hi how do you publish an excel spread sheet to a web page and retain grids
I don't think Excel gives you that option. So you'd have to edit the HTML
file in a text editor like Notepad, and replace any "border=0" with
"fox" <email@example.com> wrote in message
| hi how do you publish an excel spread sheet to a web page and retain grids
...Excel VBA #4
I'm very new to VBA and could use a little help. I wrote a macro that
does the following:
Unprotects the sheet; then does a file Save As to a specific folder and
then goes to Cell P2.
All is fine except the macro didn't record the password and I have to
type it in everytime. So it's prompting me for the password everytime.
During the file Save As operating, it says such & such file already
exists, do you want to replace? The answer is always going to be YES.
How do i make that happen?
Once Cell P2 is activated, I type in a code (number) for that...New message opens up behind outlook window
Everytime I click new in my inbox to open a new message,
the new message pops up behind the main oulook window.
does anyone know how to make this stop?
Is it possible to write a criteria where the value of an empty field is "0.00"?
Background: I have three queries with different customer account groups. Not
every salesperson has customer accounts in every accountgroup - so, he will
not shown up in that query. But he has accounts included in another query.
Now, I would like to get a sum of commission earned by each salesman
calculated from all three queries together.
Since the salesman has no record in one query the total sum of that specific
salesman is not shown.
Any idea how to solve that problem?
On Wed, 29 A...New to Mail Merge
So I am checking to see if I can merge a list of names(roughly 450) into a
template in Publisher that will be used a name plate of sorts. I also want to
include years of services in the template, i.e. John Smith 12 years of
Is this possible and what is the easiest route?
Yes it is very possible in Publisher. There is a lot of help here:
If you decide to use Publisher there is a registry fix that will be
http://msauer.mvp...O2003 New Toolbars Saved Where?
I have XP with O2003 on one computer. Just got a new computer with W7
and installed O2003. I copied over the "outcmd.dat" file and I can see
my data (e.g. views) so I know its using the correct "outcmd.dat"
However two custom toolbars I created are not shown nor are they in
the customized toolbar list. Are custom toolbars saved in a different
On Jul 24, 6:22=A0pm, srm <s...@primatech.com> wrote:
> I have XP with O2003 on one computer. Just got a new computer with W7
> and installed O2003. I copied over the "outcmd.dat" ...Keeping a table in a form editable and checking that fields are filled in before allowing a save
Firstly apologies if this is the incorrect forum but I was looking for
a general word forum and could not find one. Please point me to one if
I am trying to create a form where I want to specify what items need
to be filled in. (Review minutes from design reviews). I want to make
certain fields mandatory like the date, attendees and check list used
and want to block saving of the document with a warning until they are
filled in. Is there a way of doing this?
Also as a part of the review actions are filled in to a table.
depending on how many actions there are the table...Setting Outlook settings to new server
We are in the process of moving mailboxes to a new server. Is there a utility
or ad policy to automatically configure outlook to point to the new exchange
server? Instead of manually configuring the users outlook profile.
On Tue, 21 Nov 2006 11:15:01 -0800, Rich
>We are in the process of moving mailboxes to a new server. Is there a utility
>or ad policy to automatically configure outlook to point to the new exchange
>server? Instead of manually configuring the users outlook profile.
If you are moving the mailboxes in the same org vi...copy-paste from excel to powerpoint
When I copy a number of cells from Excel to powerpoint, I can't get rid of
the grid lines. There are no borders. When I'm in Excel, I see the faint
grid lines as you normally would. Unfortunately, these lines also display in
powerpoint. How do I stop that behaviour.
Thanks so much for any help.
Select all the cells you are copying. Then:
Format > Cells... > Patterns Then select white color ( bottom right)
When the backgound color is set the gridlines vanish unless borders are
> Off...How to add new entity?
I'm now researching the customization abilities of MS CRM 1.2.
So I have a small task, which I'm not able to accomplish with SDK.
The main question is how to add additional entity to CRM?
I need to add entity "Pets", and dictionary "PetTypes".
Pets should be linked with Contacts (1:M).
Pets should have 3 attributes:
- Name (string of 150 chars),
- Type (value from PetTypes dictionary),
- Description (string of 1000 chars)
PetTypes should have 3 entries: "Cat", "Dog" and "Parrot"
I expect that i...Error creating new task
"Could not complete operation. One or more parameter
values are not vaild"
...Change of field separator
When I open CSV files in Excel all data is put in one column. Can anyone tell
me, where I change my set up, so I get another field separator? Please be
specific, because my Excel is a Danish version, and sometimes I have a hard
time following the English instructions. Thanks!
you specify this in the Windows regional settings. Another idea:
- rename your *.csv file to a *.txt file
- now open it with excel. The Import wizard should appear and should allow
you to specify a different delimiter
> When I open CSV files in Excel all data is put in one co...Zero filling a number field
I have an auto number field that I want to zero fill to six digits but
can't figure out how. Any ideas?
You don''t say where you're trying to do this, but basically
>I have an auto number field that I want to zero fill to six digits but
>can't figure out how. Any ideas?
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2003
Message posted via AccessMonster.com
You can't do that wi...Email accounts are not created for new user
I had a severe system crash several days ago because of bad memory in my
domain controller (Server 2003 R2)/Exchange server 2003 (small site - no
extra systems). I had to reinstall Exchange 2003 and reload the exchange
store from backup. For existing users everything works great. Everybody can
send and receive email, the calender works correctly, etc. OWA works.
However, when I create a new user account in Active Directory Computers and
Users, the account is created and the new user can log onto a system.
However, Outlook 2003 cannot be configured to use the exchange server. In
t...A first look at the new Office Snapin for MSCRM
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script or code samples are subject to the terms
...New Static IP
We'll be moving our office this coming weekend. We will be getting
a new static IP from our ISP (I tried to get them to let us keep our
existing one but they said that would take "an act of God").
Our mail is delivered to our server after being filtered for spam by
McAfee. Our server is configured to only allow mail from McAfee's
range of IP address and an internal IP for a "scan to email" device.
In an effort to make this move as smooth as possible I'll be calling
McAfee in advance of this move and setting up a "ticket number"...Cannot create mailbox for new user accounts
I am running Exchange 2003 on Server 2003. I was able to move all existing
mailboxes from my old Exchange 2000 server to my new 2003 server. Whenever I
try to create a new user it creates the user normally and asks if I want to
create a mailbox for the user. I check yes, and it says account created
successfully. However, the mailbox never appears in Exchange, no email
address is assigned to the new user, and I cannot send mail to the user
account either. If I try to access any Exchange properties from ADUC it
shows everyhting as if a mailbox exists, but there is no mailbox. I am
...Annoying problem with lookup field
On a client, I have a MOSS 2007 portal with two lists which are not
wroking as expected. One contains people and the other one contains a
lookup field based on data from the first list. When someone which
hasn't got administrative rights logs in and tries to see the
properties of any element in the second list (on DispForm.aspx), they
can't see the lookup field value, and if they try to edit the element,
the dropdown control used to choose a person from the first list
appears empty. Administrator don't have this problem.
The users having the problem have collaboration rig...How to copy aQuery to a new Table?
I have a database in a Table, a report based on that same Table and a Query
based on that Report.
After two months or so I like, after some new data input, to save the Table
into a new Object Table. What is the best way for the Report and Query to
follow the new Table whitout recreating the original Report & Query?
Thankyou for your comments. I use MS Office Access 2007.
>>I have a database in a Table, a report based on that same Table and a Query
based on that Report.
Your phrasing is wrong when it comes to the elements of an Access database.
A dat..."could not fetch new headers " ERROR
i get the error " could not fetch new headers in the inbox of IMA
server.The operation was cancelled ", while using my outlook 2000 o
config: smtp/imap thro internet mail a/c option
pl try to provide solutions to it.
the error message pops up say every 5 min whenever outlook is on.
thnks n regards
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
aggiridharan <firstname.lastname@example.org> wrote:
> i get the error " coul...How to write a new entry in a combo box to its underlying table
Dear Access 2007 VBA Gurus,
I have a assets database (rather uncreatively named "Assets"). I use a form
(named "Asset Acquisition Input Form New") to enter new assets. The
"Manufacturer" field (combo box name "Manufacturers_ID) on this form is a
lookup to a Manufacturers table. What I want to happen is when I enter an
item that is not in the lookup list, I want a message box to prompt me to add
the new entry to the underlying table, or to cancel and select an item from
the list. I have no trouble with the MsgBox command itself. What I don&...Middle mouse button does not always open in new tab anymore
I am experiencing the problem that when I click with the middle mouse button
on a link (for example google search results) it does not always open it in a
new tab anymore. In about 20% of the cases it takes over the current tab
The same problem is explained here in german:
But since there was no answer found so far I decided to take it to the next
level (english c...exchange 5.5 will not keep new server name.
We have exchange 5.5 in enviroment where windows server
2003 is setup along with active directory and active
direcitory intergrated zone which is replicated to other
Problem: I enter the Exchange Server Name followed by
the mailbox name then I select the button [CHECK NAME]
In the exchange server name field after entering the new
exchange server name the old exchange server name is
displayed instead. This only happens in office 2003
professional and not in office 2000 professional
"old exchange server name"
How did you go about changing the name of the server...New Computer #3
How do I move my settings, emails, address book, etc...
to my new computer. I'm mostly concerned with Outlook
because it's the program I use most often. I have an
older computer running WIN2K Pro. I purchased a new Dell
computer with Windows XP Pro also with Office 2003. Again
how do I make my new Outlook have all the information and
settings that my old computer has. I do have both
computers connected on my home network and they can see
each other. But I'm not sure what to copy over. Any help
would be very helpful. Thank You, Paul
The file you need to copy and re-use up ...How to change the FROM field in email campaign activity?
How to change the FROM field in email campaign activity?
I would like to create an email campaign activity and change the TO
field of the email to be abother name instead of mine
I would also like to add attachments
I can't find a way to do this
Any help is very much appreciated
There are many ways to send marketing emails from CRM:
Quick Campaigns with mail merge using Microsoft Word
E-mail Campaign Activities
E-mail Campaign Activities with mail merge using Microsoft Word
Direct e-mail using templates
Send a workflow e-mail