excel

Todd. need help. I downloaded a program from carlig with macros enabled. When i went to enter a past draw a popup appeared that said compile error argument not found. I do not know how to fix it. i hope you can help. thanks

Sounds like an error in the Macro program code, or else you are using an older version of Excel than what it was designed for.  You'd have to ask CarliG.

Todd,

Trust me , he has asked Carlig  lol

He is using Excel 2000  and I have shared this same exact sheet with several other people and none of them is having a problem with it.

I am not experienced enough to be able analyze and tell him why he may be having an issue if others arent .

It is code that I found on an open excel help forum and then altered to make it do what I wanted. But other than that, Im pretty much excel illiterate.

Carlig

In the VBE use F8 to run the macro line by line. Fix the errors.

On my end there are no errors, so I dont know what im looking for to change for whatever error he is having .

He says its a compilation error, thats all I know .

The code looks very basic to me.

CG

What version of Excel are you using?

Thanks Todd

I have 2007

Rettx is using 2000

CG

Is the file saved as .xls or .xlsx? 

Excel 2000 is pretty far back and there are some known VB issues with older versions of Excel with newer (2007 and 2010 specifically) files.  Depending on where you got the piece of code, it may only be using newer functions that were developed for Office 2003 or even 2007. 

AFAIK, MS has dropped support/service packs for Office versions prior to 2007, but it's possible that there are some add-ins available that may enhance the support for retxx's verson of Excel.

Retxx, you may want to try installing LibreOffice - it's an opensource (free) version of office tools that may have some support for the coding in the spreadsheet.

That's most likely the problem.  The spreadsheet is probably using a function that was not available in the 2000 version.

Thanks Todd

I will make sure Rettx sees this

Carlig

Thanks swingblues

I had saved it as .xls  because I thought that had the best chance of being compatible .

I got the code off an excel help forum , other than that, not a clue. I looked at the code and to me it looked pretty basic. but then again, I dont really know VBA

Thanks for replying

Carlig

wow getting some help here. maybe there is an answer carli. keep digging. we know it works.

I think we already have the answer:  your version of Excel is too old.

This highlights the main reason to learn how to write your own stuff.

Then your app can be obscure or old as the hills, and you can still get it to do what you need.

I used to see this problem regularly with people using "inherited" code.