How to insert txt macro to Excel

[Ksiezniczka]

Hi,

I have macro saved as txt file (coded in VBA) which I need to insert in Excel 2007.
How do I do it?

For some reason getting below once I pasted code into "Module 1" (under Modules in VBA)

Compile error: Constants, fixed-length strings, arrays, user-defined types and Declare statements not allowed as Public members of object modules

Many thanks for your hep!

PS. I'm super new to macros/VBA

 

[Jerry Sullivan]

Welcome to the Board!

It sounds like you are putting your code in the right place, so there is probably a problem with your code.

Please post your code so we can help.

 

[ddarecki]

Hej Ksiezniczko, tu ksiaze sie klania podziel sie swoim kodem a byc moze ja bede mogl podzielis sie swoja wiedza