i have teh above code from vb.net to create dropdown in excel dynamically
Please Login or Register to view this content.
this is working fine
the dropdowns are displayed in each row as per the range given
i am openinng excel from Vb.net
the issue is each dropdown has differnt name
i need to populate all the dropdowns created with data from datbase in vba
as the dropdowns r created dynamically how do i get the names to populate the dropdowns in vba
Aren't you creating a reference to each dropdown when you create it?
If you aren't then you should be because you could use that reference to populate the dropdown.
If posting code please use code tags, see here.
i jst have the above code for creating dropdown for the range of rows in a partcialr column
how do i create a reference in vb.net & access it in vba workbook?
Why do you need to access it in the workbook?
Don't you want to populate it when you create it in the VB.Net code?
I am opening the Excel sheet Template from vb.net with few records from vb.net ie Exporting data from the application
when the Excel template gets opened with the data the user needs to just eneter Qty in each row & select a data from the dropdown which is created in each line
so i think i dont need the reference of dropdown in vb.net once its exported,
if i am able to populated the dropdown in vba as all the dropdown will have the same data from datatable
let me know whts the best
populating the dropdown from vb.net code & then exporting wuld take time , i suppose
Why would it take time and what exactly would you be exporting?
i wuld be exporting the items , ie itenmane , itmid, qty, item desciption ,, etc
the items can be 50- 100 at a time so it will take say 100 rows of excel sheet & there will be 100 dropdowns
so is there a way by which i can populate the dropwn when its exported but before opened for user
Yes, populate it just after you've created it in the VB.Net code.
as said by you i tried to populate the dropdown created from code
below code creates the dropdown for n no of rows
but i get tge error asPlease Login or Register to view this content.
Unable to cast COM object of type 'System.__ComObject' to class type 'System.Web.UI.WebControls.DropDownList'. Instances of types that represent COM components cannot be cast
to types that do not represent COM
i feel it little confusing
i am creating the dropdown for excel dynamically from vb.net code , so the names of the controls are not knwn
instead of populating it from vb.net code how do i populate each dropdown controls created with data from database
2) i exported some data to excel with blank dropdown
when i try to save the exported excle sheet i get error saying that the excel is corrpouted & cannot be saved
if i remove the code for dropdown i can save it properly
In the last code you posted there's nothing to populate a dropdown.
Also you still don't create a reference to the dropdown when you create it.
If you had a reference then you could use it when populating the dropdown.
By the way, dropdowns don't have a caption property.
my need as explained is
1) data from database will be exported to excel with X no of items
when exporting column K needs to have dropdown filled with data from database
the dropdown shld appear in all the X rows
so i had created the dropdown using .ADD method from my vb.net code
2) after exporting the user will select values from the dropdown & save the excel sheet for importing in database
hope i am clear
how do i create a reference to dropdown or how fo i get the id or name of each dropdown created so that it can be used in code
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks