Excel macro language

[JPFred]

Hi gang. I have returned after a recent illness. Even though this question is not directly access related it does tie into a project I am working on.

Due to limited available of the access db program I am in the process of using access to create and maintain a card catalog database.

The librarian is requesting that I download that main database into an excel worksheet that will be used to lookup information for the students.

I am looking for a reference that will list all functions, commands, etc. that are available in the macro language.

Any input would be greatly appreciated.

Doc

 

[isladogs]

See this link for reference materials for all Office programs
http://codekabinett.com/page.php?Theme=10&Lang=1#office-automation-konstanten-vba-modul

 

[JPFred]

Unfortunately I only understand English and it seems that the link is in German?

 

[isladogs]

Click the translate button at top right

 

[jdraw]

And why is Excel the librarian's software choice. I think Pat has identified an underlying issue (making a recent list available) that could be solved by various means. (text file, excel, report, html page....)

 

[JPFred]

I agree. It is a tough to try to work within her parameters. The access to access issue comes down to funds. This is a private school that works on a very fixed budget. That is why my grandson's grandfather is writing a workable card catalog system and get them off of the paper cards.

What I am trying to do is use the one license to access that the school has to hold the actual database and periodically download a new spreadsheet to the 5 computers they have. I am trying now to do something in excel to give them some easy lookup functionality. The grade range is from pre-K to 12th so I have all ranges of age groups to deal with.

Wow and I thought I retired 8 years ago .