I created a Form that will input Data into an Excel Table. I have too much data to use the built in Data Form that comes with Excel but I'm havin some problems with code for sending data from the spreadsheet to the Data Array & vice versa. Any help greatly appreciated.:smash:
Database Forms
-
-
-
Can you post a spreadsheet with a sample of the data?
-
Hi gixxer
Take a look at: J-Walk Enhanced Data Form v2
-
That J-Walk form is real nice and does almost all I need it to, however I am planning on selling the spreadsheet I'm building so it would not be appropriate to use it.
Thanx
-
Hi gixxer
I Think you can buy the code from John, not sure though. Drop him an email and ask him, he's a nice guy.
-
-
I purchased the password for the code but his Form is geared towards any table, mine is a specific table. The major problem Im having is that I get a Type Mismatch error in the part of the code that sends the data from the Data Array to the spreadsheet. -
Can anyone post a sample code for this type of form...I need just a little bit of help here
-
Hi gixxer
You will need to post what code you are having problems with and exactly what it is you want to happen.
:cheers:
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!