I'm using excel 2000, I have A sheet that I call historic, It's a database
recording every action that I make in the other sheets. the problem is that
the sheet is full (65000 +)
and I would like to save the information at every transaction. My
application is run with visual basic for application. Is there a way in
visual basic for application to control an external database (like access)
from excel.
Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire
Veuillez sélectionner un problème
Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
michdenis
Is there a way : oui
"Richard P." <Richard a écrit dans le message de news: I'm using excel 2000, I have A sheet that I call historic, It's a database recording every action that I make in the other sheets. the problem is that the sheet is full (65000 +) and I would like to save the information at every transaction. My application is run with visual basic for application. Is there a way in visual basic for application to control an external database (like access) from excel.
Is there a way : oui
"Richard P." <Richard P.@discussions.microsoft.com> a écrit dans le message de
news:61D428D6-7D0F-4D33-8487-3B47A570704A@microsoft.com...
I'm using excel 2000, I have A sheet that I call historic, It's a database
recording every action that I make in the other sheets. the problem is that
the sheet is full (65000 +)
and I would like to save the information at every transaction. My
application is run with visual basic for application. Is there a way in
visual basic for application to control an external database (like access)
from excel.
"Richard P." <Richard a écrit dans le message de news: I'm using excel 2000, I have A sheet that I call historic, It's a database recording every action that I make in the other sheets. the problem is that the sheet is full (65000 +) and I would like to save the information at every transaction. My application is run with visual basic for application. Is there a way in visual basic for application to control an external database (like access) from excel.