asap utilities question
I have Msft. Excel Vsn 2002 and latest vsn. of ASAP Utilities.
I used ASAP Utilities to merge single rows of data together so that
more than one row will fit on a single line of
My question now, is, is it possible using ASAP Utilities to separate
the data that has been merged back into single rows of data?
All information welcomed! Aaron
...Isinteg Warning Message Question
I ran isinteg -pri -test alltests. I came up with 506
warnings. There are basically 4 types of warnings. They
are below. Are these something I need to worry about? What
should I do?
Warning: MsgFolder 165 (Fid=0001-0000000D1864, Mid=0001-
PR_READ_RECEIPT_REQUESTED(0029000B) prop in Messages table
and MsgFolder table do not match.
Warning: MsgFolder 4 (Fid=0001-0000086DC911, Mid=0001-
00000436F972, Inid=0001-000004A583F1): Error
JET_errRecordNotFound seeking to INID for this ...Joining text with a formula in cell #4
just to complete the thread...
I found the answer.
You have to change the format of the cell to custom 0.00"*"
this is the only way it will show only 2 decimal places
Thanks for the hel
Mustard Head's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1630
View this thread: http://www.excelforum.com/showthread.php?threadid=27700
...Setting up a new e-mail account
I'm trying to set up my yahoo account so that I receive
my e-mail messages in my Outlook Inbox. I went to
Accounts, and servers, and put in mail.yahoo.com for
incoming mail (POP3) and smtp.yahoo.com for outgoing mail
(smtp). When I click on the send/receive button I get an
Dave <email@example.com> wrote:
> I'm trying to set up my yahoo account so that I receive
> my e-mail messages in my Outlook Inbox. I went to
> Accounts, and servers, and put in mail.yahoo.com for
> incoming mail (POP3) and smtp.yahoo.com for outgoing mail
Subject: Extending formulas
For my application that uses Excel for calculations. I need to be able to extend the forula base of Excell with complex scientifc functions. Is there a way to add new functions to the Excel function base?
MS has provided Visual Basic for Applications (VBA) to customize Excel
with new functions, commands, forms, menus, etc.
Tools|Macro|Visual Basic Editor
From the VBA editor
Then write your functions in VBA. Details of writting functions in VBA
is a very big topic,
may help y...Dotfuscator question
Hello Everybody !!!
When i create programm using C# i must understand that my programm from
exe - module
can be converted to the source file by Reflector.
In Order do not allow do this i must use dotfuscator, but i did not find any
free normal dotfuscator.
May be someone tell me what can i do cause now as think we have interesting
We 've got free technology but if we want to protect our products we must
buy expensive commercial dotfuscators.
You should post this message in a newsgroup which discusses managed
code. This newsgroup does not have much managed traff...question on the rules wizard
When clikcing on the Rules Wizard, Outlook locks up -
consistently. Has anyone got a remedy for this?
Ok, I have two questions:
1. With Thunderbird I can use this with a hotkey manager to compose a
new message with Tbird "D:\Program Files\Mozilla Thunderbird
\thunderbird.exe -compose" -- how can I do the same for Outlook
Express and Outlook 2003?
2. When I go to load Outlook Express I get this error message,
followed by the error message below it: http://i180.photobucket.com/albums/x296/gwar_1/Untitled-3.png
how can I fix this and use Outlook Express?
posted to the outlookexpress newsgroup via crosspost
Please Reply to Newsgroup for the benefit of others
Re...question about Time
How to make the time result for example if it�s ( 1:01 ) or higher shows
only as ( 1:00 ) and if it�s Lower like ( 0:59 ) or less it will show
the same result in this case ( 0:59 )
Any idea & suggestions.
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
Using Ron deBruin's google addin and asking for subject round time, I get
"saud" <saud.xgc4...Need to add to current formula
I have this formula that will cause values to change based on the mont
that is referenced in the formula ($L$1). Currently the formul
I need to add August, September, October, November, & December to thi
formula but excel is not allowing me.
Does anyone know how I can get around this? Oh by the way
November thru April =2, May and October=4 and June thr...Can i use conditional formating on a cell when it contains a formula?
I am trying a "conditional formatting" on a cell that contains
formula, but it didn't work.
"If cell value is equal to 0 then font - white" This doesn't work,
If i use this condition on a cell without formula it works just fine.
sit's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=262
View this thread: http://www.excelforum.com/showthread.php?threadid=26784
are you sure your formula returns an exact zero?. Could you post the
formul...HQ Licensing question V.2
I have a client running HQ client at 8 stores + HQ server at the warehouse.
They would like to be able to use transfers from the warehouse to the stores,
so I would have to setup a new PC running Store Ops and a new database,
however, in order for the transfers to take place, I need a HQ Client License
correct? Do I also need a POS key?
I appreciate any insights you may have.
Thanks in advance
yes - you'll need an HQ Client license so it can exchange with your
headquarters - "export" the wh database as you would any store from HQ
no - you won't need a PO...MS Project 2007 question
I am developing a simple schedule with no resources but 2 tasks out of 100
are hazardous and I would like to make the schedule so that when these tasks
occur, no other tasks can occur. In other words, even though all tasks are
moving around as the schedule is being developed, I would like to make sure
no other tasks can be scheduled wherever these 2 hazardous tasks fall. These
2 tasks are serial to every other task in the schedule. Is there a way to do
Thanks for your help.
Create two milestones. Use milestone 1 as the successor task to all tasks
I am using Excel 2000 with Windows XP.
I am having a problem. I am on Sheet 2 of my workbook.
I have SSN on a sheet named Employees in the same workbook.
I need to take the numbers on the Employees Sheet and transfer it to the
I know how to do this. It just won't work.
This is a copy of my formula. =SUM(Employees!C3)
This should take the SSN that is in the C3 cell on the employees sheet and
place it at the cell where the formula is typed.
When I put this formula in the cell I am getting just a "0".
Niek Otten...formula auditing/macro
Can anyone give me the sytax to goto - special - precedents so I can create a
macro so I can assign to a hotkey and dont have to go through 4 steps ?
With A1=1 and D2=2*A1, and D1 as active cell:
I recorded a macro for these steps:
And the macro contained just one line:
Bernard V Liengme
remove caps from email
"ynissel" <firstname.lastname@example.org> wrote in message
> Can anyone...SQL query / Formula for Reorder Point?
Is it possible to issue an SQL command(s) that would:
1. Set the Restock Level for all items to be equal to the current on-hand
quantity for each item.
2. Set the Reorder point for all items to be equal to 1/3 of that items
I'm currently doing this manually, or using a formula in excel when items
are initially imported into the DB, but there are still several thousand that
need to be retro-fitted like this...
Thanx in advance!
UPDATE Item SET RestockLevel=(Quantity - QuantityCommitted)
UPDATE Item SET ReorderPoint=ROUND(RestockLevel/3,0)
Ne...formula to have 0 to 6.5 only in ref to other cell val of 0<=6.5
...copy values generated by conditional formula in one sheet to the other work sheet as values
I have data generated by conditional formulae in work sheet1 in
columns A to J. If the condition is satisfied the cell will display a
realnumber, if the condition doesn't satisfied the cell will display
Now I wanted to copy the cells which have the real numbers in
sheet1 to sheet2 as values(as we do with paste special and paste the
values) Do we have any formula or other method to copy the cells in
sheet1 to sheet2. can anybody helpme out in this issue.
Thanks and Regards
Select your range to copy
edit|goto|special|c...IM Add New Batch
GP 10 on 2003 Terminal Server.
How do you create a Payables Batch in the IM in preparation for importing to
the Payables Transaction destination? Alternatively, how must GP be set up to
ensure that the “Add New Batch” rule works correctly?
With the Add New Batch rule set the IM crashes (see my post Integration
Manager 10 Crashes). Additionally the characteristics of the Add New Batch
rule do not match the required information which I understand to be Origin
and Checkbook ID.
I figured there might be some default settings for Origin and Checkbook ID
in the setup somewhere but was not a...Help! charts disappearing, new charts crashing powerpoint
When i open a presentation the charts vanish...i have restarted, they come
back. I try to edit a chart, and it crashes powerpoint after a few clicks.
What can I do...whole afternoon going crazy!
If you are using v 2007 there is a hotfix which is meant to cure some chart
john ATSIGN PPTAlchemy.co.uk
Free PPT Hints, Tips and Tutorials
> When i open a pres...Moving exchange 5.5 to a new server exchange 2003
Good day all... how do I move exchange 5.5 to a brand new
exchange server 2003. The new server will be in a new
organization. Any info would be greatly appreciated.
Microsoft MVP - Terminal Server
>Good day all... how do I move exchange 5.5 to a brand new
>exchange server 2003. The new server will be in a new
>organization. Any info would be greatly appreciated.
...Hopefully Simple VBA questions
Using VBA, I want to go row-by-row and get the values from certain cell
in each row so I can run some tests on them, then put the result of th
tests back in certain cells.
This is how I am set up so far, can you help me with my questions i
Dim i As Long, c1 As Long, c2 As Long
c1 = 0
c2 = 0
For i = 1 To 120 (HOW DO I MAKE THIS DYNAMIC TO INCLUDE NEW ROW
AS THEY ARE ADDED?)
If Cells(i, 2).Value Then 'start flag is true (HOW DO I MAK
VBA GO TO A DIFFERENT WORKSHEET WITH THE Cells(I,2).Value STATEMENT?
If Cells(i, 1).Value = "E" Then
c1 = c1 + 1
E...Help with percent formula beginner
Hi, have a cell (A1) with $39.99. I want a cell (B1) were I can vary
10%, 20% etc and have that effect (A1). So If I put in 10% A1 would be
$36.00 (percent decrease). Can you please help me out with the formula?
Also it seems like if I type in % in a cell and I delete it and type
another number and I don't want a % in there it gives it to me anyway.
Can I make this stop?
Thanks so much
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("B1")) Is Nothing Then
Wi...Combo Box initial values question
Does anyone know how to make a combo box show a value when a sheet opens?
Mine are always blank when I open them until I select a value.
Try something like:
Me.ComboBox1.ListIndex = 0
"teepee" <email@example.com> wrote in message
> Does anyone know how to make a combo box show a value when a sheet opens?
> Mine are always blank when I open them until I select a value.
thanks for trying.
says 'invalid use of me keyword.&...Newbie
I have a spreadsheet that is little more than a list of PO #'s that shows
what orders are done and ready to ship for a particular customer.
We upload the file every day to a website where the customer can view it
whenever they want.
So far, everything's fine.
I use the "=TODAY()" function so that when I open and modify the listings,
the date gets automatically updated.
The problem is, when the customer accesses the file, the date also updates
on THEIR end and the file looks more current than it really is. Is there a
way to maybe lock in the date ONLY when I save the file...