Results for "Author: gil shabthai"

With this code I try to show you the different between ByVal and ByRef , I pass x variable by reference and see how it change and pass it by Value and get it with no change. Its very simple example that will help you to understand the different.

In this example I try to show you how to connect the ADO object to Excel file directy , without copy any data from the Excel file to DataBase first ( like MS access) , plesae vote for me :)

Write to 2 Excel Sheet at the same Woorkbook - With VB.

Make Excel document from Visual Basic. Input data to the excel sheet and make some changes to fonts , borders , colors.

This example shows you how to add from VB a custom property to Excel file ( you can do the same with most MS Office application ). With this code I can write the custom property to the file but after that I got an Error , so if you can help me with that it will be great.

I did not write this code by myself , i had found it at http://support.microsoft.com/support/kb/articles/Q246/3/35.ASP With this code you can transfer the contents of an ADO recordset to a Microsoft Excel worksheet by automating Excel , this code will work only with Excel 2000 or 2002 , for Execl 97 use my previous examples, or just look at this examlpe for basic knowledge at the IF statement.

With this code you will be able to select one or more language from a list , and then to get all the fonts that was installed on the operating system which support the languages that was chosen. So if you want to develop a word prossesor maybe you will find it useful - to change the font list when the user had change the language. some part of it i had found on the net ( I dont know who is the Auther) and more help from the MSDN.

With this code I try to show you the different between ByVal and ByRef , I pass x variable by reference and see how it change and pass it by Value and get it with no change. Its very simple example that will help you to understand the different.

In this example I try to show you how to connect the ADO object to Excel file directy , without copy any data from the Excel file to DataBase first ( like MS access) , plesae vote for me :)

Write to 2 Excel Sheet at the same Woorkbook - With VB.

Make Excel document from Visual Basic. Input data to the excel sheet and make some changes to fonts , borders , colors.

This example shows you how to add from VB a custom property to Excel file ( you can do the same with most MS Office application ). With this code I can write the custom property to the file but after that I got an Error , so if you can help me with that it will be great.

I did not write this code by myself , i had found it at http://support.microsoft.com/support/kb/articles/Q246/3/35.ASP With this code you can transfer the contents of an ADO recordset to a Microsoft Excel worksheet by automating Excel , this code will work only with Excel 2000 or 2002 , for Execl 97 use my previous examples, or just look at this examlpe for basic knowledge at the IF statement.

With this code you will be able to select one or more language from a list , and then to get all the fonts that was installed on the operating system which support the languages that was chosen. So if you want to develop a word prossesor maybe you will find it useful - to change the font list when the user had change the language. some part of it i had found on the net ( I dont know who is the Auther) and more help from the MSDN.

With this code I try to show you the different between ByVal and ByRef , I pass x variable by reference and see how it change and pass it by Value and get it with no change. Its very simple example that will help you to understand the different.

In this example I try to show you how to connect the ADO object to Excel file directy , without copy any data from the Excel file to DataBase first ( like MS access) , plesae vote for me :)

Write to 2 Excel Sheet at the same Woorkbook - With VB.

Make Excel document from Visual Basic. Input data to the excel sheet and make some changes to fonts , borders , colors.

This example shows you how to add from VB a custom property to Excel file ( you can do the same with most MS Office application ). With this code I can write the custom property to the file but after that I got an Error , so if you can help me with that it will be great.

I did not write this code by myself , i had found it at http://support.microsoft.com/support/kb/articles/Q246/3/35.ASP With this code you can transfer the contents of an ADO recordset to a Microsoft Excel worksheet by automating Excel , this code will work only with Excel 2000 or 2002 , for Execl 97 use my previous examples, or just look at this examlpe for basic knowledge at the IF statement.