473,327 Members | 2,007 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

VBA function in Access not found when importing

Hey

I have no problem importing an access table into excel using VBA in excel.

But if the access table uses a VBA funtion inside access this function can not be found when I try to import the table.

Anyway to get around this? Thanks
Sep 14 '10 #1
4 1312
patjones
931 Expert 512MB
I have personally never had to do this, but it sounds like you need to define the function in VBA within Excel, just as you do in Access. I'd try pasting the function definition into an Excel VBA window, compiling, and then checking to see if the function pops up when you try to use it in a formula in the spreadsheet.

Pat
Sep 14 '10 #2
TheSmileyCoder
2,322 Expert Mod 2GB
An access table cannot use a function.

If I understand you correctly, you wish to call a function you have coded in Access from Excel? Is this during or after your transfer of data from Access to Excel?

Also is the function you want to call located in a forms module, or in its own module?

Please post the code of the function here as well.
Sep 14 '10 #3
Yes, during the transfer of data from access to excel.

The function is located in its own module.

I think Ive tried to copy the function into excel VBA, but didnt work. (not found)

Ill post the code tomorrow. I dont have it here.
Sep 14 '10 #4
TheSmileyCoder
2,322 Expert Mod 2GB
Im not that into Excel vba programming, but plz note that there are several places in Excel in which to place code. There is the worksheet, the workbook, and excel modules. Im not really sure what the placement of the code means, but you could try the different places.
Sep 14 '10 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Andreas Emmert | last post by:
Hi there, I'm trying to import a csv file into my MySQL database. Unfortunately the number format for the price column is formatted in German style, i.e. XX,XX (decimals separated by comma not...
2
by: Binary Dave | last post by:
Looking for some help. Not really sure if this is VBA or Access. I'm using Access97, and using the TransferText command, and I want the text file to come into the Access table as is; no sorting....
5
by: Mark Dicken | last post by:
Hi All, I am trying to Pass A Collection To A FUNCTION ??? (Access 2000) I have a Class called BO (for Business Objects) Within BO I have a Function called ShowCollection Public Sub...
2
by: Chris Hankey | last post by:
I having a strange and annoying problem where Access crashes when the user copies (to the clipboard) the results of a query. The message is not very helpful. It simply says - "Microsoft Access...
5
by: Alex | last post by:
Hi, I have an aspx file that creates a custom class object and calls a method which should return a DataSet. It throws a: Description: The application attempted to perform an operation not...
0
by: ss | last post by:
i read a few posts about global function access. well i am not interested in global functions. rather, i am seeking for a way to may my call in ASPX pages but not the code behind. for example:...
1
by: Alan | last post by:
OK this is a weird one. I've got an import routine going whereby name and address data is pulled into a table from a csv file. I'm having strange results when importing postcode/zip data into...
0
by: cwho.work | last post by:
Hi! We are using apache ibatis with our MySQL 5.0 database (using innodb tables), in our web application running on Tomcat 5. Recently we started getting a number of errors relating to...
3
by: dolphin | last post by:
Hello everyone! Can a static member function access non-static member? I think it is illegal.Is it right?
1
pradeepjain
by: pradeepjain | last post by:
hii guys i am trying to use open filer...but on login its giving this error "auth_pam function not found"..can any one tell abt this auth_pam or any link where i can read abt this.... Thanks,...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.