- Katılım
- 29 Haziran 2005
- Mesajlar
- 158
- Excel Vers. ve Dili
-
MS Office Professional Plus 2013 64 Bit -Eng
MSSQL 2012 R2 64 Bit
Hello ,
I hope that you will help me about it.
I try to make a Standard Excel Application. This application can be copied to any destop and it can be used after making settings and then it should report.
When we open the Excel Work Book, the userform will want to enter user’s settings.
What are these settings?
• SQL Server( When we click the Combobox1, it will list all SQL Networks that are in my network)
• SQL USER (user should write manually to Textbox1)
• PASSWORD( user should write manually to Textbox2)
• DATABASE ( the datas should be listed (combobox2) whice are the datas of the choosen SQL Server, and the available one should be selected.)
How can I write the codes , which is about that the first combobox will show me the all SQL Server that are in my system? ?
Thank you for your help.
I hope that you will help me about it.
I try to make a Standard Excel Application. This application can be copied to any destop and it can be used after making settings and then it should report.
When we open the Excel Work Book, the userform will want to enter user’s settings.
What are these settings?
• SQL Server( When we click the Combobox1, it will list all SQL Networks that are in my network)
• SQL USER (user should write manually to Textbox1)
• PASSWORD( user should write manually to Textbox2)
• DATABASE ( the datas should be listed (combobox2) whice are the datas of the choosen SQL Server, and the available one should be selected.)
How can I write the codes , which is about that the first combobox will show me the all SQL Server that are in my system? ?
Thank you for your help.
Son düzenleme: