How to declare Sub and Function at the same line?

**ricky_low** · 10-04-2021, 04:43 AM

I have an excel vba macro which downloads a single file. In a 64-bit office it runs well but I'm facing problems in 32-bit version in declarations section.

The code in 64-bit is like this: pastebin /0uqVR60p (since im a new member im not allowed to post links yet)

but in 32-bit version it brings me errors like "Expected Sub or Function" and highlights PtrSafe then I fixed this by adding "Sub" before "PtrSafe" but it gave me another error which says "Expected Lib" then I fixed this by removing "Function Test" but now I have to declare this function somewhere because it is used on the code.

Can someone help me please?

**rorya** · 10-04-2021, 04:45 AM

I suggest you read this as it will show you how to work with 32 and 64 bit Office with API calls: https://jkp-ads.com/Articles/apideclarations.asp

**AliGW** · 10-04-2021, 04:46 AM

Welcome to the forum.

There is no version 32 of MS Office (32-bit is a flavour, not a version) - which version are you using? Please update your profile. Thanks.

There are instructions at the top of the page explaining how to attach your sample workbook.

**ricky_low** · 10-04-2021, 04:55 AM

Damn it was fixed like a charm. Thanks a lot!!

How to declare Sub and Function at the same line?

LinkBack

Thread Tools

Rate This Thread

Display

How to declare Sub and Function at the same line?

Re: How to declare Sub and Function at the same line?

Re: How to declare Sub and Function at the same line?

Re: How to declare Sub and Function at the same line?

Thread Information

Users Browsing this Thread

Similar Threads

Public Declare Function FindWindowA in 64bit

Excel VBA Function Method API Windows Function User32.dll Alias Declare Library List . :)

Declare and Initialize on the Same Line

VBA Function to Declare Yes = 100 and No = 0

How do I declare a function whose output is an array?

How can use LONGLONG type of C++ Dll in 'Declare Function' statement?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions