Free Microsoft Excel 2013 Quick Reference

trouble with Excel 2003 and dde

hello Good afternoon, I have an application that
reads a file excel by means of a DDE REQUEST,
which works very well for Excel 2000 but for Excel
2003 it does not work, this must to properties of
object which they changed in the version 2003 in
ahead, I founded a file which corrects this situation
but and not found it again on Internet... i hope you
can give me the better aids.

Note: the application give an error Ora-106555.. thanks


I'm using a treeview control with Excel 2003 and VBA.

Can anyone provide a code snippet to show how to, on a treeview node_checked event, pass the node.checked true/false value back to a specific cell on an Excel worksheet?

Thanks

Hi,
in our office, users have either Excel 2003 or Excel 2010.
And I make pivot tables and charts with Excel 2003 or Excel 2010, depending on who will be using them.
So I have both Exel 2003 and Excel 2010 installed on my (Win7) machine.

I haven't yet found a way to force my machine to open XLS files with Excel 2003.

I have used the "Open with" dialogue and specified that I want to associate a particular file extension with its corresponding programme but whatever I stipulate is ignored.
XLS files are opened with Excel 2010.

The only way I have found to open the XLS file in Excel 2003 is by drag and drop.
Which is not optimal. (In fact it's a pain.)

Any help appreciated.
TIA
Wayne

I am a user of Hyperion Retrieve with excel 2000 and recently we changed to
Office 2003, but Hyperion Retrieve still use Excel 2000.

Some files which are linked from files updated into retrieve lose their data
values (which are into formulas) when are opened into Excel 2003.

I know that every file saved in other version is updated when is opened in
Excel 2003, although choose "don't update", but anybody knows if there is any
trick for save this file into retrieve with version 2003 or any other way
that could make my life more easy; my last option is copy and past value but
there are many, many formulas.....

I am a user of Hyperion Retrieve with excel 2000 and recently we changed to
Office 2003, but Hyperion Retrieve still use Excel 2000.

Some files which are linked from files updated into retrieve lose their data
values (which are into formulas) when are opened into Excel 2003.

I know that every file saved in other version is updated when is opened in
Excel 2003, although choose "don't update", but anybody knows if there is any
trick for save this file into retrieve with version 2003 or any other way
that could make my life more easy; my last option is copy and past value but
there are many, many formulas.....

I am running a simple calc on a new computer that I bought with an Athlon
3200+ processor. The calc adds either .1 or .2 to the previous result
depending on a condition. After the calc runs on the first 15 or so rows,
instead of adding a .1 it adds a .100000000000001 which, although small,
creates an error and later "IF" statements fail a test that should be true.

Does anyone know of a problem with Excel 2003 and the Athlon 64 3200+
processor?

Rick1459

I have run into a brick wall with InStr, Replace, and Len. I take the data from the active cell (formatted as text). I need to cleanup the data and do further massaging of it. In testing cleanup code, I get behavoirs and results I simply don't understand and can't figure out from hours searching forums many places.

The following simplified example commented code can be cut/pasted into a new spreadsheet module and should be self-explanatory. Example data is in the comments. All help greatly appreciated.

Data is entered by multiple users and multiple sources. Therefore there is no control over the input quality so extraneous characters and multiple repeated periods and spaces can show up anywhere.

Option Compare Binary
Public Sub periodStripper()
' ActiveCell on spreadsheet formatted as "Text"
' See comment #4. In ActiveCell, want to replace any
'   continuous substring of periods until only 1 remains.
' "..." or "...." would become "."
' or "...3a...2[]" would become ".3a.2[]"
 
Dim myStr As String
myStr = ActiveCell.Value
myStr = Trim(myStr) ' #1 trim lead/trail spaces. works OK.
myStr = Replace(myStr, " ", "") ' #2 remove any spaces. works OK.
myStr = Replace(myStr, ".[", "[") ' #3 delete period next to left bracket. works OK.
' #4 following fails. should keep replacing any 2 periods until only 1 remains.
' Have also tried putting in a Do Loop.
myStr = Replace(myStr, "..", ".")
ActiveCell.Value = myStr
' String and results
' "....2A4." doesn't strip any periods
' "2.......[a]" strips 1 of 7 periods
' "....2..A....4." only strips the 2 periods between "2" and "A"
' "...3a...2[]" strips 1 period from each group "..3a..2[]"
' same result with Excel 2003 and 2007
End Sub
 
Public Sub testStrLen()
' want to see if Period at end of string
' problem with Len and inStr
' ActiveCell Examples
' "2A4." 4 chars long, period at end
' "....2A4." 8 chars long, period at end
' "2.......[a]" 11 chars long, no period at end
Dim myStr As String
Dim myStrEnd As Integer
myStr = ActiveCell.Value
myStrLen = Len(myStr)
MsgBox ("Data: " & myStr & _
    " -- Length: " & Len(myStr) & _
    " -- inStr Value: " & InStr(myStrLen, myStr, "."))
' Start String followed by values that Len and InStr return
' "2A4." --- 4 chars long, period position 4 (Is Correct)
' "....2A4." --- 6 chars long, period position 6 (both wrong)
' "2.......[a]" --- 7 chars long, period position 0 (Len wrong)
' same result with Excel 2003 and 2007
End Sub


Hi All,
I am having a problem with Excel 2003 SP2 and Hyperlinks!
I created a macro in Excel 2000 that copied a workbook to another location then updated all the hyperlinks to suit, this is the code:-

Sub replacelink(years, week)

Dim c As Range
For Each c In Selection
Application.StatusBar = "Examining Row " & c.Row & " Coloumn " & c.Column & " In Sheet " & ActiveSheet.name
'if there is a hyperlink in the cell
If c.Hyperlinks.Count 0 Then
With c.Hyperlinks(1)

.Address = Replace(.Address, "2007", years)
.Address = Replace(.Address, "k09", "k" & week)
.Address = Replace(.Address, " 09", " " & week)
.Address = Replace(.Address, "Summary Data", "")

End With
End If
If c.HasFormula = True Then
oldform = c.Formula
oldform = Replace(oldform, "k09", "k" & week)
oldform = Replace(oldform, " 09", " " & week)
oldform = Replace(oldform, "2007", years)
c.Formula = oldform
End If
Next c
ActiveSheet.Protect Password:="UNIT"
End Sub

This works great and alters the hyperlinks as required, however in excel 2003 the hyperlink gets truncated to:-

../U3 East/2008/Week 13/01 - Monday Day - Wk13U3E.xls
Instead of:-
//ebouds01/ltshare7/00000 - MU 3 Shift Reports/Summary Data/U3 East/2008/Week 13/01 - Monday Day - Wk13U3E.xls
And hence I cannot get at the hyperlink part “/Summary Data” to change it!!

I have tried setting the hyperlink base address:-
ActiveWorkbook.BuiltinDocumentProperties("Hyperlink Base") = "ebouds01ltshare70000 - MU 3 Shift ReportsSummary Data"
Which works on my PC but does not point to the same point on another PC.

Looking on the Microsoft website there is a known bug with excel 2003 SP2 and Hyperlinks however I have tried there suggestion of installing SP3 and I still get the same error

Is there a way to get excel 2003 to display the entire Hyperlink address? So I can change what I need or does anybody have any other ideas?

Thanks in advance for any help, because this is driving me up the wall!!!

hi folks,

i have a macro that i use to do somethings with but i've always been a bit suspicious of the vlookup formula used is.

=if(isna(vlookup("sheet1"!b3,"sheet2"!a1:c20,false,2)),0,vlookup("sheet1"!b3,"sheet2"!a1:c20,false,2))

Please note i know i might have the syntax wrong for the defining of the worksheet (so please over look this error if it is one).

the formula is supposed to do the following....

1. try and find match to the data in current workbook in sheet2
2. if found copy the stock units into the active cell
3. if not found instead of displaying #N/A enter 0 (Zero)

I've since googled excel 2003 and vlookup formula (2003 is the version i use).

I noticed how the last 2 flags where reversed and was wondering if this might be the problem.

Would i improve the accuracy by swapping the last two around?

eg

=if(isna(vlookup("sheet1"!b3,"sheet2"!a1:c20,2,false)),0,vlookup("sheet1"!b3,"sheet2"!a1:c20,2,false))

I have tried using the match function but this again was giving me erroneous results.

thanks.

I am having a problem with excel 2003 and visual basic for applications.

I have read knowledge base article 837258 and I have applied the hot fix and
some other patches that were available for windows xp and office 2003 but the
problem came back. The problem ocured when excel tried to perform an
autorecovery. The only error message I saw in my spreadsheet was as follows:

An unexpected error has occured. AutoRecovery has been disabled for this
session.

What else can I do to solve this problem.

Edward Letendre

hey, can anyone help me ?

I copy and paste an Excel 2000 file into my computer (with nothing changed)
, and when i open and printed out the file document with Excel 2003, the font
size and lingement have changed? please help?

We are using Excel 2003 and we have detected that, when we open a sheet
(any) and scroll through it with the arrow keys, the system begins to use CPU
(in some cases, up to 100 %) and memory (we have even run out of virtual
memory sometimes). The memory usage growth happens even if we are int the
upper left cell and try to move left or upwards (something that, obviously we
cannot do). Has anybody had the same problem? At the moment we have detected
thar it happens in machines with Excel 2003 (with or without SP1) and W2000
or WXP.

I have some files saved as xlsx with Office Beta 12. I need to be able to
read and modify these files with Excel 2003.

Is it possible? How?

Thank you in advance

Hi,

I wanted to find out are there any differences between csv saved from Excel
2003 and Excel 2007?

Thanks in advance,

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Hi there,
I have Microsoft Excel 2003 and have a problem with hyperlinks. I have
cells in which I have right clicked chosen hyperlink, named it news and
then entered the hyperlink adress as www.news.com.au . When i click on
the news hyperlink i receive an error message saying "Unable to open
http://www.news.com.au/ . Cannot locate the internet Server or proxy
server. I also have email addresses in the same spreadsheet and they
open my email program no problems at all. I'm using Mozilla firefox as
my web browser and Mozilla thunderbird as my email program which is why
i point out that my emails open properly. I changed my default browser
back to Internet Explorer but I got the same error message.

Any help greatly appreciated.

HI

We are facing a consistant difference in real time behavior between
Excel 2003 behaviour and Excel 2000 behaviour in the usage ot the Group
function...

Using the exact same Excel file that have around 1000 lines with several
level of grouping, the time needed to group under level 1 or 2 is around 2
to 3 seconds with Excel 2000 while it is around 25 to 30 seconds with Excel
2003. In both case the same function is quite immediat if we settle the
calculation mode to manual...

The same phenomenon can be seen if you ask for the group function on a file
without any formulas while another big excel file with a lot of formulas is
open at the same time but not active...

Is there something different than the calculation mode that should be
settled in Excel 2003 in order to get the same response time on group
function than in Excel 200? Any other information, experience about that
problem? Is it link to a different behavior of excel in front of calculation
strategy?

Thanks for your help
Alain79

Hi.
Have an issue with conditional formatting rules created on excel 2003 and
edited by excel 2007.
I created a series of rules on specific fields of a pivot table. The rules
are applied to many cells on the same column, so that if the pivot table
expands vertically, the new rows are affected by the same rule, too.
Everything has worked perfectly for years. Now, with excel 2007, these rules
are no longer kept. Excel erases all the rules applied to cells inside the
pivot table and moves the rule to cells outside the table. The only solution
I found so far is to re-create the rule with 2007 but other users (who read
the same file using 2003 version) won't be able to read the file like before.
Has anyone else encountered the same problem?
Is there a work around it?
Many thanks in advance.
--
eml

Hello

i'd like to know if a file saved in excel 2007 can be opened with excel 2003.

Thanks

I'm running Win XP Pro and wish to open a DBF file with Excel 2003 via
Windows Explorer (as is possible with Excel 2000/Win98SE, simply by
associating DBF files with Excel), but get an error dialog:

"This action is only valid for products that are currently installed."

Having trawled the web, it seems as though the Office 2003 user settings
need amending. I've looked at the Microsoft Knowledge base and have been
unable to readily trace a step-by-step guide that also includes the
Excel/DBF association steps.

Is anyone aware of such a guide ? TIA

Regards,

Dave Purdy.

In my computer class my professor wants us to find an article that compares
excel 2003 and excel 2007. I have been searching for 4 days now with no
luck. I went to sites like Microsoft Technet and MSDN and I don't know where
to look in them or they don't have the information I'm looking for. Does
anyone know where I can find information about this or anything that relates
to this? Any help would be very much appreciated.

MS Austria told me that it is possible to compile Excel sheets (any Version)
with Visual Studio Tools, but looking through the documentation i just found
the possibility to create managed code (i.e. the VBA Code is located
separated from the sheet on a web service), which means the source has to be
Excel 2003 and .NET Framework. Does anybody know how to do it with Excel 2003
and VBA 6.0 Code?

I would appreciate a solution very much!

Heinzpeter

Hi

I am trying to use a Function in Excel 2003 and 2010 but keep getting a Compile Error. The odd thing is the Function works in some versions of 2003 and 2010 e.g. I opened a new workbook in 2010 put the Function into a module and it worked.

If I open up the existing workbook with the Function I keep getting the 'Compile Error'.

Does anyone have an easy answer?

Cheers

Option Explicit

'~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~  USER NAME FUNCTION  ~~~~~~~~~~~~
Private Declare Function apiGetUserName Lib "advapi32.dll" Alias _
    "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long

Function GetUserName() As String

' Returns the network login name from advapi32.dll
' This allows the Electronic signatures facility to work.
' This function should not be changed
Dim NameIssue As Variant
Dim UserName As Variant
Dim lngLen As Long, lngX As Long
Dim strUserName As String

On Error GoTo NameIssue

    strUserName = String$(254, 0)
    lngLen = 255
    lngX = apiGetUserName(strUserName, lngLen)
    If lngX <> 0 Then
        GetUserName = UCase(Left$(strUserName, lngLen - 1))
    Else
        GetUserName = ""
    End If

NameIssue:

If Err.Number > 0 Then
    GetUserName = UCase(Environ$("Username"))
End If
    'MsgBox "Whoops " & Err.Number & " " & Err.Description
   
End Function
I got the code from an existing Macro I found. If its not referenced properly to the correct person, my apologies.

Hi,

I have been using IE to download an excel file which is served by an
servlet with Content-Encoding:gzip and it has been unpacked and served
to Excel 2000 just fine. Now with Excel 2003 it seems as IE is passing
the link directly to Excel 2003 and it doesn't understand the zipped
content. Any ideas/teories on this?

Thanks in advance,
Nik

hey, can anyone help me ?

I copy and paste an Excel 2000 file into my computer (with nothing changed)
, and when i open and printed out the file document with Excel 2003, the font
size and lingement have changed? please help?

I have a PC with Excel 2003 and 2007 installed. Until recently it worked fine, but something has changed, and now I can't get it to recognise 2007 files (03 seems fine). If I click on them in explorer or here nothing happens. The only way is for them to be saved, open xl2007 and open the file from Excel. A minor inconvenience, but since it used to work I reckon there must be a solution. I have checked the file types xls, xlsx, xlsm and they seem correct.

Any thoughts? Thanks in anticipation.