This was great! Been struggling with a small error for 3 days. LOL This video made me feel stupid because as usual I was looking for a big problem when the issue was small. THANKS!!
How about i have an existing excel file and then i want to open that and there i want to put the value? -Thank you so much for this. It's 2020 but your video is still useful 😍
Thank you! exactly what I was looking for! Is it possible to create VB program that will work with excel files even if the user don't have Office / Excel installed on his PC? For example the program will print range of cells or something?
Thanks for this video, easy and simple tutorial to get started Though I have a question, can I store a workbook in my program so I can use it like a template when I create a new workbook? (to avoid hard formatting via programming)
I think you can create a workbook in Excell. once saved and closed you can read the workbook as binary stream and save the stream. when you need to create a new copy just write to a file stream. hope this helps. Regards Frans
Thanks for this video ! Just one small question. Lets say I have another button which would replace A1 value with another without closing excel or a sheet. How to do that ?
Hail Frans, nice tut, but after finishing working with data transfer, the EXCEL process remains working (visible through the Application Monitor) despite all Quit and Nothing commands. As the matter of fact, my app monitors a certain Excel file periodically, say once per 10min. I would not want my memmory be innundated with useless stuff. If there is a way to make a more silent reading from Excel files?
Hello people, I love these videos, keep them up...I am using visual studio 2008 (I know behind a bit) trying to work with excel. I've added the references, and interop, but now trying to create a reference but am not seeing the code sense give me an "excel.applications" am I missing an import or something?Thanks in advance. I haven't worked with VB.Net in a while. sorry
Brian Link how to link up .mdb file with excel in vb6.I have string, float and tag table in mdb file I want that data in Excel.Excel will save with date
Hi frands123..great video I need to know how to import data from a worksheet or data files,to make a graph in VB6.It'll be cool if u can answer me thx.
@quigglesg If you have imported the interop into the project then there should not be a problem, But it may help searching for the error number on google.
Hi Frans. I'm new to Visual Studio and I'm using VS Community 2019. I'm trying to followthe Tut and when I get to Installing the COM References to Microsoft Excel 16.0 Object Library, I click OK but nothing happens. It is not in the list after the OK.
Hi Ghyslain, Does the componenet show in the referances box? It wont install the component referance twice. Another check you can do is to ensure the version you are trying to install is not locked. Try and give the computer a restart and update. This will release any apps using the component.
Do you know how to create a project in vb that will allow me to open up an excel file I want to give out the EXE file but in side the EXE file I want to contain the excel workbook that I have produced ??? Any Ideas
I am trying to delete a given row (for example, Row # 25 from an excel file) programatically (using VB.NET). Can you share some code please? I can open the file, add text to any cell, search and find a given string. Thanks,
Hi Please help ???? 1. I want to open an existing workbook in excel with Visual Basic2008 2. Everything works fine until the code to Hide rows. 3. I have a code below but it doesn’t work 4. I do not know how to link the module (if needed) to my project 5. My project is exe and works from a Form in Visual Studio and excel should be hidden 6. My workbook has 2 worksheets.Worksheet 1 and 2 is the same i want to have worksheet2 (Print sheet) not to show the blank rows.(to hide them) Thanks in advance Hassen
hi Hassen Mansoor, Ok to open an existing workbook all you need to do is to replace the MyExcal.workboks.add with MyExcel.workbooks.open("filelocation"). As for the hidden rows, they are concidered to be active rows even when you hide them. Hiding a row only changes the visability and not anything else. Item4 I dont know what module you are referring to. if the module is created with your application it will automaticqlly be deployed with the project to build a single application. hope this helps
ashish adhikari it is actually simpler than you think. MyExcel.save or MyExcel.Workbook.Save .There are options you can find online, for example how to define the location and the workbook name when you save it...
Hi coolpunkdude, Firstly these comment areas does not allow programmers to write code in them, so to get the code to you I'll need to email them. You can subscribe to my channel and send a friend request, this way we will be able to e-mail the code and I can then help you. Regards Frans
Hi coolpunkdude, One again, if you need help please subscribe or send a friend request. I can not send large bundles of information on the comments area and it also doesnt accept code. Regards Frans
your lesson has been the first one very very simple and clear: congratulations !
This was great! Been struggling with a small error for 3 days. LOL This video made me feel stupid because as usual I was looking for a big problem when the issue was small. THANKS!!
Thanks Bro
This has helped me a lot.
Appreciate
Appreciate. This exectly what I was looking for.
Thank you, very nice and helpful video tutorial.
How about i have an existing excel file and then i want to open that and there i want to put the value?
-Thank you so much for this.
It's 2020 but your video is still useful 😍
This was very useful for my project. Thank you.
Thank you! exactly what I was looking for!
Is it possible to create VB program that will work with excel files even if the user don't have Office / Excel installed on his PC?
For example the program will print range of cells or something?
No problem, thanks for the comment.
Thanks for this video, easy and simple tutorial to get started
Though I have a question, can I store a workbook in my program so I can use it like a template when I create a new workbook? (to avoid hard formatting via programming)
I think you can create a workbook in Excell. once saved and closed you can read the workbook as binary stream and save the stream. when you need to create a new copy just write to a file stream. hope this helps. Regards Frans
***** Thank you for quick response... After some googling I will probably be able to do it (I am newbie but I got the concept)
Great stuff, regards Frans
Thanks for this video !
Just one small question. Lets say I have another button which would replace A1 value with another without closing excel or a sheet. How to do that ?
Very useful to get started - many thanks
thanks from mexico, great!!!
fast and well explained
at last someone that can teach vb2010 properly, wd
i really loved your video..
thanks a lot.
www.punepackermover.com/index.html#contactus
Hail Frans,
nice tut, but after finishing working with data transfer, the EXCEL process remains working (visible through the Application Monitor) despite all Quit and Nothing commands. As the matter of fact, my app monitors a certain Excel file periodically, say once per 10min. I would not want my memmory be innundated with useless stuff. If there is a way to make a more silent reading from Excel files?
Hello people, I love these videos, keep them up...I am using visual studio 2008 (I know behind a bit) trying to work with excel. I've added the references, and interop, but now trying to create a reference but am not seeing the code sense give me an "excel.applications" am I missing an import or something?Thanks in advance. I haven't worked with VB.Net in a while. sorry
+Mark Ryan Try
Dim MyExcel As New Microsoft.Office.Interop.Excel.Application
Brian Link how to link up .mdb file with excel in vb6.I have string, float and tag table in mdb file I want that data in Excel.Excel will save with date
@@brianlink391 thanks it works for me
Is there a way to append to a column? To add to a blank cell in the column with out parsing the data?
Hi paezcampos, Thank you for the great comment.
Hi frands123..great video
I need to know how to import data from a worksheet or data files,to make a graph in VB6.It'll be cool if u can answer me thx.
@quigglesg If you have imported the interop into the project then there should not be a problem, But it may help searching for the error number on google.
Great! Thanks.
Hi Frans.
I'm new to Visual Studio and I'm using VS Community 2019.
I'm trying to followthe Tut and when I get to Installing the COM References to Microsoft Excel 16.0 Object Library, I click OK but nothing happens. It is not in the list after the OK.
Hi Ghyslain, Does the componenet show in the referances box? It wont install the component referance twice. Another check you can do is to ensure the version you are trying to install is not locked. Try and give the computer a restart and update. This will release any apps using the component.
Do you know how to create a project in vb that will allow me to open up an excel file
I want to give out the EXE file but in side the EXE file I want to contain the excel workbook that I have produced ???
Any Ideas
I am trying to delete a given row (for example, Row # 25 from an excel file) programatically (using VB.NET). Can you share some code please? I can open the file, add text to any cell, search and find a given string. Thanks,
Thnks very much. it was excellent :)
Hi coolpunkdude, I almost forgot I made this tut...LOL to get the value from the cell is easy:
me.lable1.text = MyExcel.ActiveCell.Value
Regards
Frans
+Frans Dietrichsen
Wow nice tutorial i really appreciate this :) anyways ,sir how to auto log the data in excel using vb.net? thanks
thanks sir
great thx very very very much!!
Hi
Please help ????
1. I want to open an existing workbook in excel with Visual Basic2008
2. Everything works fine until the code to Hide rows.
3. I have a code below but it doesn’t work
4. I do not know how to link the module (if needed) to my project
5. My project is exe and works from a Form in Visual Studio and excel should be hidden
6. My workbook has 2 worksheets.Worksheet 1 and 2 is the same i want to have worksheet2 (Print sheet) not to show the blank rows.(to hide them)
Thanks in advance
Hassen
hi Hassen Mansoor, Ok to open an existing workbook all you need to do is to replace the MyExcal.workboks.add with MyExcel.workbooks.open("filelocation"). As for the hidden rows, they are concidered to be active rows even when you hide them. Hiding a row only changes the visability and not anything else. Item4 I dont know what module you are referring to. if the module is created with your application it will automaticqlly be deployed with the project to build a single application. hope this helps
Thank a lot
how do we save the excel file later through the programme??
ashish adhikari it is actually simpler than you think. MyExcel.save or MyExcel.Workbook.Save .There are options you can find online, for example how to define the location and the workbook name when you save it...
How to write code in C#.Net
How to read cell data?
@deesooner LOL We have all done that before..Your welcome.
Thanks! =D.
@xxwzaebd No Problem, Happy Coding
Hi coolpunkdude, Firstly these comment areas does not allow programmers to write code in them, so to get the code to you I'll need to email them. You can subscribe to my channel and send a friend request, this way we will be able to e-mail the code and I can then help you.
Regards Frans
Merci
Hi coolpunkdude, One again, if you need help please subscribe or send a friend request. I can not send large bundles of information on the comments area and it also doesnt accept code.
Regards
Frans
hi FRANS DIETRICHSEN, i'm a student in VIETNAM, i want to write a application use visual basic , cuold you give me your email ?