Excel VBA help.

  • Thread starter Thread starter Sheela
  • Start date Start date
S

Sheela

Hello Sir,

Can I insert two declaration statement as below for 16-
bit and 32-bit in Excel together. I'm actually trying to
convert excel programs created in excel 95 (16-bit
version) to excel 2000 (32-bit version).

______________________________________________________
Declare Function GetVersionEx Lib "kernel32"
Alias "GetVersionExA" (lpVersionInformation As
OSVERSIONINFO) As Long

Declare Function GetVersionEx Lib "KERNEL"
Alias "GetVersionExA" (lpVersionInformation As
OSVERSIONINFO) As Long
_______________________________________________________

Will it affect the operating system? Please advise.

Thanks.
 
Will this be good enough to run in a 16-bit environment
and 32-bit environment? Is there anywhere else where I
have to make this sort of changes? I'm new to this. While
I was surfing the net, I came across on "Porting Your 16­
bit Office­Based Solutions to 32­bit Office". It shows the
declaration which I have to addin for 16-bit and 32-bit
but I really don't know where to insert this code.

Thanks,

Sheela
 
convert excel programs created in excel 95 (16-bit

Windows 95 is a 32Bit application. It requires Windows 95 (32 Bit) or
Windows NT 3.51 (32 Bit) or Later operating system. Not sure how you were
using 16 bit API calls -

Anyway, you can use the Excel VBA code

? application.OperatingSystem
Windows (32-bit) 4.10

I don't believe Excel 95 and earlier understands the Compiler Directive. It
was introduced in VB 4.0, but I am not sure what version of VBA/VB Excel 95
used. VB4 supported both 16 and 32 bit. Your article (first URL below)
talks about the compiler directive approach on Page 9.

I assume the article you spoke of is:

http://support.microsoft.com/default.aspx?scid=kb;en-us;139372
ACC95: Porting 16-bit Applications Available in Download Center
Porting Your 16-Bit Microsoft Office-Based Solutions to 32-Bit Microsoft
Office

you might want to look at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;147781
ACC: How to Convert API Calls from 16-bit to 32-bit

http://support.microsoft.com/default.aspx?scid=kb;en-us;210115
ACC2000: How to Convert API Calls from 16-bit to 32-bit

http://support.microsoft.com/default.aspx?scid=kb;en-us;224319
ACC2000: Error Message: There Are Calls to 16-Bit Dynamic-Link Libraries

http://support.microsoft.com/default.aspx?scid=kb;en-us;136064
ACC95: Overview of Conversion Issues

While these are for access, they seem to have the most information. I would
spend more time looking at the Original porting.doc article you spoke of
(first URL)

--
Regards,
Tom Ogilvy



Will this be good enough to run in a 16-bit environment
and 32-bit environment? Is there anywhere else where I
have to make this sort of changes? I'm new to this. While
I was surfing the net, I came across on "Porting Your 16­
bit Office­Based Solutions to 32­bit Office". It shows the
declaration which I have to addin for 16-bit and 32-bit
but I really don't know where to insert this code.

Thanks,

Sheela
 
Well, this file was created by someone before in a lower
version. When I run this program, it shows some error
messages and some of it says "Can't run 16-bit
program", "Cannot find CTL3D.DLL".

My company has migrated the systems from excel 95 (which
was running in 16-bit environment) to windows 2000 and
2002. So, when I run this program, it shows some errors
while the macros were executing.

Regards,
Sheela
 
If it says that, then you need to change to the 32 bit version I would
guess.

Here is an article about using CTL3D.DLL in a 32 bit environment:

http://support.microsoft.com/default.aspx?scid=kb;en-us;130693
HOWTO: Use CTL3D Under the Windows 95 Operating System

This article talks about the 32bit verion of CTL3D (CTL3D32)

http://support.microsoft.com/default.aspx?scid=kb;en-us;149860
Older Version of CTL3D.DLL Causes "Not Enough Memory" Message

It may be time to change the code to use newer methods.

--
Regards,
Tom Ogilvy






Well, this file was created by someone before in a lower
version. When I run this program, it shows some error
messages and some of it says "Can't run 16-bit
program", "Cannot find CTL3D.DLL".

My company has migrated the systems from excel 95 (which
was running in 16-bit environment) to windows 2000 and
2002. So, when I run this program, it shows some errors
while the macros were executing.

Regards,
Sheela
 
Back
Top