Problem with komma versus period in Excel
I am have problems with the use of period in Excel. I
Denmark komma is the decimal seperator.
If I convert (from within VB Editor) the content of a cell
from "6340,00" to text and replace the komma with period I
get "6340" (I wanted "6340.00).
If I make the convertion in Excel and record the macro at
the same time I get the desired result i my sheet. BUT
when I put in my code in VBA and run it from here I still
get the wrong result, "6340" and not "6340.00".
I know Excel (VBA) transform "." to "," probably acording
to...Problem with View Source / Outlook 2000
I searched some more, found that the problem is caused when the
Temporary Internet files cache is too big. Deleted the cache and the
problem is solved. Changed the settings to a more reasonable 100 MB
and it shouldn't happen again
I'm using Outlook 2000 and Win 2000, no problems now (had to reinstall
Windows last week for unrelated reasons).
I also use ZoneAlarm and Outlook has permission only to access the
Trusted zone, not the Internet in general.
Something has happened in the past couple of days. I got an email
that looked blank ...Help! Setfocus problem
i ave a dropdown field on the first tab. I use setfocus so that it selects a
different field to stop users scrolling down and changing the selection on
the load event.
When a user changes tab and come back to the origional tab the setfocus
doesnt run as the form is already loaded. How do you get around this?
This is driving me and users mad at minute...please help before i open
another bottle of dark rum!
Check out following URL; how to fire onclick event on tab click. It may help
PLEASE do click on Yes or No button if this post wa...Problem with signature formatting
I'm running Outlook 2003 on my machine and am having an extremely irritating
problem with the signature formatting. I compose my messages in text and my
signature is text - no html. In the signature setup and in the compose
window of my messages my signature looks fine:
However, when I print or print preview, it looks like this:
Position, Unit Region Company
So the second, third, and fourth lines get ...Report Writer Text Spacing Problems While Modifying a PO form
Due to Report Writer static text field size limitations, I am forced to try
to use two adjacent text fields to complete a sentence. I am having an
inordinate amout of problems trying to get words to align in sentences with
the correct amount of character spacing between words that span the text
field boundaries. And, the process of toggling between Report Writer and
Dyamics to get the Purchase Order form to reprint is time consuming. What am
I missing (besides patience)?
1) Setup a calculated field for your static text. Set the result type to
String, and use the Constant...Safe Pay Check Amount Problem
I am trying to setup Safe Pay. Everything seems to be working fine except
for one annoying quirk. Our bank's Positive Pay data format gives us 12
characters for check amounts ($$$$$$$$$$¢¢). The file that Safe Pay
generates is working perfectly except for those checks that are greater than
$9,999,999.99 (9 characters). If the check amount is greater than that (say
$10,000,000.00), the value that the Safe Pay file shows for that check is
002147483647. And, even if none of the individual checks exceed
$9,999,999.99, if the total of the checks in the batch exceeds that a...Exchange Patch (KB912442) causes problem w/ share login accts
Exchange2003 std SP2 w/ Office 2003 & XP clients. We have several users who
shares a computer, so instead of logging in w/ different users accts, I set
them up w/ a shared logging and access Outlook w/ multiple Mail profiles.
However, after installing KB912442, it blocks these users from sending
emails. It gives them an message that the shared login doesn't have the
right to send emails on behalf of this user. I checked the mailbox rights
in AD Users and Computers, the shared login has Read & Full mailbox rights
permissions. Any idea how to fix this.
Thanks in advance.
...need custom cut and paste functions
I once wrote here about a problem I had cutting and pasting where columns
would turn to "REF!" after a cut and paste. I would work around it by
copying, pasting and then manually deleting instead. I thought turning
everything in the sheet to absolute references would solve the problem but
it didn't so now I am thinking of a different solution.
Could someone tell me what I need to do to write my own cut and paste
functions which would basically copy the selection and then on a paste it
would paste and then delete the original selection from where it was copied
from...Internet connection problem
Hi. I hope someone is able to cast some light on a problem. We have a
home network (all computers running XP) some wired and some wireless.
For about a month now we have intermittent connection problems in that
any one computer (randomly) will not connect to internet. I think all of
the computers have suffered from the problem. Rebooting the affected
computer makes no difference but rebooting the router can sort it until
the next time. Even my mobile phone occasionally cannot connect. In
Firefox the message is just "server not found". Pinging an IP address
results in a time...Problem with charting Net income vs Year
Im having some problems with my Excel chart. It will not plot Net Income vs Year. It keeps trying to treat Year as a different data series. It will work if I use text i.e. a1990, a1991, etc. but it refuses to use 1990, 1991... Any Ideas???
Use an "XY (Scatter)" chart, instead of a "Line" chart.
> Im having some problems with my Excel chart. It will not plot Net Income vs Year. It keeps trying to treat Year as a different data series. It will work if I use text i.e. a1990, a1991, etc. but it refuses to use 1990, 1991... Any Ideas???
Delete the co...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...Excel 2003 Copy/Paste filtered column
I have a filtered column on my spreadsheet. I have copied the column,
changed the figures and then tried to paste it back on to the filtered
column. It is not copying over the original filtered column but rather over
cells that have been filtered out. The worksheet/cells are not protected.
What could the problem be?
That's the way pasting works. It'll hit the visible and hidden cells.
> I have a filtered column on my spreadsheet. I have copied the column,
> changed the figures and then tried to paste it back on to the filter...Excel hyperlink problem
I have a strange excel problem and it's driving me nuts - I would be
seriously grateful if someone could help me out!
A colleague has this excel document with a huge number of hyperlinks in
it, well over 1000 (don't ask me why she wants to use excel - she just
does). The hyperlinks are in this format and are using DFS:
Whenever she clicks on a link, a pdf from another area of the network
is opened. Quite simple and no problems so far. However, as of
yesterday, whenver she makes any kind of change to the excel fi...securety problem
I start an app in vb with this code:
I always get a warning about hyperlinks that can be harmfull to
How can I bypas this warning.
I �ve put my macro securety on low and trust all installed add-ins and
templates + trust acces to visiual basic project.
Is there a way so the warning won�t show
climax's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30816
View this thread: http://www.excelforum.com/...Problems opening/saving attachments
I am unable to open or save any .rtf file attachments - this started
happening today, previously there were no problems with .rtf files.
When I try to open such an attachment I get this message:
Can't create file: xyz.rtf
Right click the folder you want to create the file in, and then click
Properties on the shortcut menu to check your permissions for the folder.
What folder is this? I am trying to open the attachment not creat the file!
Also, when I try to send an rtf file as an attachment, in the email message
the file does not show in the attachments section but the receipient
actu...wire transfer download problems
I made an international wire transfer of $5000 from my US bank. The receiving
bank in Panama took $15 as a service fee and credited my account with $4885.
Somehow my US bank now wants to show the amount as $4885 during downloads
to my checking account. But some genie reminds Money 2004 that the original
amount was $5000 which triggers a discrepancy. As a result, this transaction
wants to download each and every time, whether I change, accept, or whatever.
Thanks for help.
In microsoft.public.money, lanecito wrote:
>I made an international wire transfer of $5000 from my US bank. Th...Interesting TIF file problem
At the company I work for, we have someone that exports AutoCAD drawings to a
TIF file, then inserts the TIF file into an Excel spreadsheet. We have quite
a few of these.
Other users can open this spreadsheet, view it, do a print preview, but when
they try to print the file the inserted picture does not show up. All that
prints is a box with the broken url red x document image.
It seems that the problem is with Office XP. The Excel files are created
with Office 2000, and they print fine from Excel 2000. On Office XP and
Office 2003, the file won't print properly (all systems are ru...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...Problem with vba code to export query result in excel
I have a access report that exports to excel with click of a button after
choosing parameters. This works well. However I have to modify couple of
fields to utilize formula in the export module. I am not sure how to do this.
I am writing the above code which seems to cause problem. I appreciate any
help to resolve this issue. Thanks.
If lngColumn = 12 Then
xlc.Offset(0, lngColumn).Value = =([UnitPrice]*[OriginalShippedQty])/1000
It seems the fields UnitPrice and OrigianalShippedQty are not being
>I have a acces...Copy/paste range of rows between 2 dates...
Hi! I have a sheet called data which act as a database. The column A has
the dates. In order to create customized chart in a userform, for
different range of data(i.e from column D, G and M...), I'd like to
select a range of rows that are between 2 dates and create the charts
accordingly. Or copy to range to another sheet and then create the
charts. I am not so advanced in VBA and any help would be greatly
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
Hi all, I hope someone can help me with a few difficulties i'm having
uploading my website.
1. When I upload, only the first page is uploading - so pages 2-7 don't appear
2. Images do not download with the webpages so when you type in the url, you
simply see a blank space where a photo should be with a small icon at the top
left courner which sometimes offers the option of 'show picture'.
3. The webpage is positioned to the left of the window when it appears and
doesn't centre itself to the page so there is a huge chunk of white space to
the right of the window.
Can ...re install Pub 2000 problem.
Hello and I hope I'm In the right newsgroup. My problem is I've had to
re install my Office 2000 Disc2 and now when I want to start publisher
the message box tells me I am trying to access a program that needs the
cd. When I installed it, I checked for Publiher to "run all from my
computer" I've un installed and re installed, still need disc. what am
I doing wrong? Thanks for your help, John :)
> Hello and I hope I'm In the right newsgroup. My problem is I've had to
> re install my Office 2000 Disc2 and now when I want to start publis..."Archive all messages sent or received by mailboxes on this store" option problem
I want to backup the all message sent or received by mailboxes, I find that
there is an option "Archive all messages sent or received by mailboxes on
this store " in Exchanger 2003.
I had selected this option and forward to public folder. But I found that
not all message will be archived.
- All message sent by mailboxes can be archived
- Some Messages come from mailboxes will not be archived
Eg: yahoo, hotmail, and other company
Is this option not archive this message ?
Any other setting need to configure ?
...CHtmlView shutdown problem
We created an MFC regular DLL whch is loaded by an old MFC-app (built with
but we dont have access to the source of this app, just an DLL-interface.
our regular DLL loads several MFC extension DLLs.
one of the extension DLLs uses a CHtmlView based object which is used within
a docking pane,
we dont use document/view-architecture.
when I shutdown the app, it takes more than 1 minute till the CHtmlView
gets detstroyed. this effect doesnt occur when we load our DLLs from within
new MFC app, built with VC++.NET, everything shuts down fine.
due to the fact that there is n...Inventory Adjustments with problems
In this moment I have some journal entry in financial module with
transactions that i never saw before.
The bachumb is something like 'GLTRX024134', they are not sequencial.
In the descriptn, this has a link to a transaction from inventory
adjustment, but with a change... if for example the transaction from
inventory is AJ00000007, in this reference is IVAAJ00000007, this is
happening with the transfers too.
Any idea is welcome!!!
Thanks in advance