5.0 Not Compatable

B

Bill C

I wrote a macro using Excel 5.0 and it has been running great for several
years using 5.0 but client has upgraded to newer version of Excel and
problems exist.
Dim LotReq As String
Message = "Choose ""OK"" For All Lots, Or " & Chr(13) & "Enter
Lot Number Requested."
Title = " CHOOSE LOT"
Default = "ALL"
LotReq = InputBox(Message, Title, Default)
If LotReq = "" Or LotReq = False Then EndAll

The following statements are not working:
Default = "ALL" ( get error about const assignment )
If LotReq = "" Or LotReq = False Then EndAll ( stops program )
Also Excel appears to be returning "false" on this statement when Pmts =
0.00
If Pmts = False Then EndAll

I do not have access to current Excel program. Can anyone spot the problem?

TIA,
Bill C.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help modifying code 0
GetOpenFilename code execution interrupted 5
Convert excel 5.0 macro 1
Code corrupts file (XL2003) 3
excel 2003 vs 2007 menu and sheet issues 3
what is the way to select ASCII file and import it into excel sheet? 2
How to autofit text containing CHR(10)? 3
Import CSV Data from Outlook Public Folder 0

Top