Combining Cells #2
I need the easiest way to do this:
I have a column with values. Sometimes there are 2 rows, sometimes 20.
For another program, I need all the values in that column in one long
string separated by commas. So if my orginal data is:
What I need excel to spit out is: 8766,7788,9987
How do I do this given that my number of rows can vary. I don't mind
at all copying and pasting a function in that handles this, but just
not sure how to go about it. Any help is appreciated. Thanks!
Let's say the numbers start in A1
In B1 enter = A1
In B2 enter =B1&","&...ListCtrl #2
I have a bitmap background and I want my List Control to have transparency
so the background goes through,
Is there anyway to do this?
...Batch Not Posting #2
Hello all, we have an issue where when we attempt to post from several
different modules it gets so far then kills great plains. we have to go
into the batch recovery run the batch recovery at which time it will
print the reports them GP dies again. then we have to go back into
batch recovery and hit cancel on all the reports and it will them post
the batch. TIA
...excel based budgeting #2
I amusing Excel Based Budgeting, the spreadsheet is getting created, yet
created blank. I know the system created the spreadhseet b/c the worksheet
page 1 gets named the Budget ID that we started with.
this workstation/user can export with no issue from smart list
At the same time we are working on exporting the budget, on another
workstaion we were processing a pretty big GL integration
...sequence numbers #2
how i can put sequence number after applying filter.
if anyone can help me on this matter, i'll be very thankful.
If your list begins in cell A1....
Insert a column and put SEQ in the "new" cell A1.
Then put this formula in Cell A2 and copy down:
Now filter your list. That formula will count the number of non-blank,
Note the dollar sign in the formula. Cell A3 will count the non-blank,
visible cells from A2:A3. Cell A5 will count them from A2:A5, etc.
Does that help?
> how i can put se...Allowing Default Domain for OWA
I have an Exchange 2000 environment in which I am hosting multiple company
email accounts under one forest and one domain. I would like to now offer
them OWA access over SSL.
Are there any known security risks by entering the "Default Domain" under
the various protocols in ESM so my clients would no longer have to enter the
domain each time they would like to log on through OWA? If I do, should I and
can I utilize this under all protocols?
My gratitude ahead of time...
There's a KB article on that.
...Trim function #2
How can I have displayed the figures (cells) used, when I run a Trim function.
not really sure what you're rying to achieve. Could you
give an example?
>How can I have displayed the figures (cells) used, when I
run a Trim function.
When you use the TRIM Worksheet Function
by itself the result is displayed in the cell.
If you want to know what B1 actually contains, you could use
CODE for each byte, but easier would be Chip Pearson's
Cell View -- http://www.cpearson.com/excel/CellView.htm
For a maco to trim all cells i...OWA Security Port 80 or 443?
I have been having this discussion at work about what is the best way to
secure our clients Exchange servers. We all agree to use SSL, but they
insist on having both port 80 and 443 open. I say to close port 80 and only
allow port 443 to the exchange server for OWA. I am trying to find some
documenation to back up what I am saying if indeeed what I am saying is best
practice. Can someone help guide me and possibly give me some ammuntion to
go back to them with.
Thanks in advance.
Microsoft technet has this information in their webcast:
http://msevents.microsoft.com/c...Compare 2 rows of data and update the first
I have 2 lists both have the same data in each (account names). Th
first list is the master and the second list is a new accounts list.
I would like to compare the second list to the first one and if th
account is not in the first list then I would like it added to list 1.
The second list changes frequently so I am looking to automate thi
I am able to do vlookups to check for matches but I am unsure of how t
perform the additional tasks of updating.
Is there a simple solution with formulas or do I need to insert
thank you for your time and help,
Message ..."No more fonts may be applied in this workbook." when saved. Why? #2
"No more new fonts may be applied in this workbook." Message box when spread
sheet is saved. Why?
...Trying to work with Transaction.DropAmount #2
I have been tasked with making an addition to the status.htm that will
display a notification when the cash in the drawer has reached a
I'm familiar with HTML and VB Script, but I've been going over the
customization guide provided by MS and I'm a bit lost. The syntax
that I see doesn't appear to be working for me or perhaps I just
forgot how to do things.
If anyone has any advice on how to access the values of
Transaction.DropAmount or the value of cash in the cash drawer, I
would really appreciate it.
...0x800CCC0F error #2
I have my POP and SMTP settings correct (I have run test message and it
sends and receives) yet when OL automatically sends and receives, I get the
above error with server responded on 553 unknown address.
I have increased server timeout but still nothing, any help is appreciated
It's a bit tough to know exactly what the problem is but one suggestion is
that you have 2 email addresses set up; one which is working and one with
erroneous settings - maybe set up by mistake when you were configuring OL.
"T5" <email@example.com> wrote in message
ne...counter on owa 2003
I need to monitor the number of users who are connected to the service
and the number of mails that are read.
Can someone tell me about counters that do this job?
...Show <> Records Between 2 Tables ?? (ANTI-Join)
I've got 2 tables.
One has 2000 records (original)
The Second has 1000 (created from the Original with 1000 records removed).
There is a unique ID (which is in the Original and the Second for matching
like records...the CustomerNum).
I'm familiar with creating a query that would join them at the CustomerNum....
which would generate a list of records with matching CusterNums in each table)
In the New Query dialog box, there's a wizard to create an Unmatched Query.
That's what you're looking for. One of the tables has to be the "base"
table, so you m...Line graphs #2
I am using a line graph in Excel 2007. It has 3 variables. One of the
variables, I changed to a column graph.
When the data is plotted:this yr sales,last yr sales and budget, on the
bottom of the graph shows dates for every week of data that I have for this
How do you just show dates for every 4th week instead of every week. I had
that in my scatter graph and I think it looks cleaner.
You select the X-axis
Choose Chart Tools, Format, Format Selection, Axis Options tab, Major Unit,
Fixed, Days, 28.
"Charles Eaves" wrote:
>...Authentication Error after CRM Rebuild
We had to rebuild our CRM 3.0 server, and after installing SQL 2005 & CRM and
restoring the databases, we are now getting an authentication error in the
browser. Note that the original AD security groups in AD were accidentally
deleted. Also, we tried to re-associate the databases with CRM through
Deployment Manager but the Server Manager part is not displayed. We made sure
we were logged in with the CRM installation credentials
Any thoughts about how we can get past this?
1) Uninstall CRM
2) Run the Redeployment Wizard (on the DVD, Redeployment folder) --
this will do ...workbook macro help #2
Hello there, I would like some help with a macro that I need to run in
a workbook. this is the macro.
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
what or how do I get it to work for every worksheet in the workbook, I
currently place the macro in each worksheet which is very time
consuming. Is there a way to place the macro in the workbook so all
worksheets have the autofit macro?
Try putting the following code into the ThisWorkbook module (replace the
names of the sheets to single out as ...exported excel charts and pdflatex #2
pdfLatex is compatible with jpg and pdf images, and real pdfs loo
better than jpgs it seems. I found that the best way was to make a .p
file of the chart by printing to a postscript printer, and the
converting to pdf. All is done in vba (uses ghostscript)
hke's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=155
View this thread: http://www.excelforum.com/showthread.php?threadid=26893
JPG is the wrong format for most charts anyway, being designed for photographic-type
images with cont...List box #2
Simple question for all you MFC guru's. How do you change
the back color for a list box?
>Simple question for all you MFC guru's. How do you change
>the back color for a list box?
Handle the WM_CTLCOLORLISTBOX notification message - in MFC this is
done via OnCtlColor CTLCOLOR_LISTBOX.
MVP VC++ FAQ: http://www.mvps.org/vcfaq
...Can not compose or respond a message in OWA 2003
We are using Exch. 2k3 SP1 in a W2k3 Server. Our clients are XP SP2 and some
of them can not compose a new message or respond a message because their IE
got with a X in the field one is sopouse to write.
I compared one "good" PC with one "bad" and all the IE settings are the same.
We are using IE 6 SP1.
PLease help me because I have used more than a day trying to get an answer
but cnow am frozen.
I have the same problem but no solution yet. I saw your post after I posted
my question. Here's the link to my message if you wanna keep an eye on it if
someo...PinPad 1000SE #2
My pinpad was working fine and all of a sudden it stopped working and I get
an communications error every time I open the POS. The pinpad reads ready.
However, if I go to configure and test it I get a unable to open error (code
104). I checked all my printers to make sure nothing is on COM2 (I have a
serial connection). Is there a way to see if anything else is taking up COM2
or are there any other problems I should test. Any help would be appreciated.
You can try going to the start menu, clicking on Microsoft Retail Management,
then Configure MS OPOS...when you get this screen, scroll...Changing default paths to templates, toolbars, etc., in O2K? #2
I'm in a bind at the office. I'm constantly replacing a colleague now
and I have to be at her desk. It's been a pain not to have access to
my system so yesterday re-routed files so that my general and default
templates and toolbar files for, say, Word and Excel are on the
network. Now when I log on even at her station, I have mostly
everything working exactly as if I were at my own computer.
However, haven't figured out how to deal with Outlook defaults and
template files (along with rwz files and all those other files we back
up). Is there a way to have O2K look to a netw...Exchange 2003 OWA Forms Security
I am testing an interesting scenario - If a user is logged into OWA and then
the account is disabled, the user can still actively send emails. I am
thinking this may hold true for mobile access as well.
We are running Exch 2003 SP2 ENT on Win 2003 SP2 ENT with a FE/BE
configuration with Forms based authentication enabled for OWA. My timeouts
are 15 mins for 'Public' and 8 hrs for 'Private'.
Has anyone else seen this? Is there a way for us to force a
re-authentication or something else without reducing the timeouts? Is this a
Tha...unable to delete mail selected by using OWA
I am having problem in deleting mails from inbox.
My mail server is SBS 2003 - Exchange server 2003.
some mails from Info@xxxxxxx.com are not able to delete,
whenever I try to delete, I am getting "400 Bad Request" and "SOme Items
can't be deleted,They were either moved,already deleted,or access was denied."
and I can not block this mails as the domain name keep changing.
All our clients are using OWA.
Please help us and suggest solution for this issue.
Is there any patch or fix up available ?
Info Tech Systems Manager
Naval Exchange ...OWA, "wrong" public folder server
I have 3 Exchange 2003 servers (mail1, mail2, mail3) and I'm about to
decomission one of them (mail3). So far I have moved all of the users on
mail3 to the other exchange servers and public folders is no longer
replicating to mail3 (only system folders reside on mail3). We have
installed OWA, but for now it is only accessible internally so this is not a
big issue yet, but I noticed something today that I'm unable to figure out.
When I log on OWA using http://mail1.domain.com/exchange and click on public
folders, it opens http://mail3.domain.com/public. Although the public