Hello friends,
I have created a form and store all the infomation of form to the one Database.xlsx file.
it will be updated day by day.
the path of this Database.xlsx is constant.
i want that when i click on Save button of userform then all the information of userform will be save in Database.xlsx file whitout opening it.
is it possible??
Please suggest me
Not without opening it, i dont think. You can open it as an invisible object?
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
You can use ADO. You can either open a recordset from the source workbook and add a new record to it, or just execute an INSERT INTO query.
Everyone who confuses correlation and causation ends up dead.
Hello friends,
thanks for reply
how can open it as an invisible object ??
Please suggest
dim o as excel.workbook set o=workbooks.open(filename) o.visible=false
Hello Sir,
I got a error, please see attached file
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
mohan.r1980 
Register To Reply
Bookmarks