Click here to Skip to main content
15,897,371 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: System.NullReferenceException: Check my solution someone, pls Pin
Luc Pattyn20-Jan-11 6:28
sitebuilderLuc Pattyn20-Jan-11 6:28 
AnswerRe: System.NullReferenceException: Check my solution someone, pls Pin
Eddy Vluggen21-Jan-11 1:04
professionalEddy Vluggen21-Jan-11 1:04 
QuestionGeneral Question about programming steps Pin
joyfullboy2997319-Jan-11 2:17
joyfullboy2997319-Jan-11 2:17 
AnswerRe: General Question about programming steps Pin
Pravin Patil, Mumbai19-Jan-11 4:12
Pravin Patil, Mumbai19-Jan-11 4:12 
AnswerRe: General Question about programming steps Pin
Manfred Rudolf Bihy19-Jan-11 11:03
professionalManfred Rudolf Bihy19-Jan-11 11:03 
AnswerRe: General Question about programming steps Pin
T210219-Jan-11 14:36
T210219-Jan-11 14:36 
JokeRe: General Question about programming steps Pin
joyfullboy2997320-Jan-11 0:53
joyfullboy2997320-Jan-11 0:53 
QuestionOrphan Question [modified] - Has a Home now! Pin
Soulus8318-Jan-11 19:52
Soulus8318-Jan-11 19:52 
I didn't find a suitable forum to ask this so I ask for your superior experience and knowledge.

I have been commended the task of building some sort of "automation" for one report we usually hand in the form of units required to satisfy a given demand on a given product. All needs to be done in Excel though Unsure | :~

So, situation is like this:
I have an spreadsheet which contains the given demand of a finite number of artifacts, handled by product code, and with dates and expected pieces for this dates:
Model		4-Jan	11-Jan	18-Jan	25-Jan	1-Feb
WFW8300SW	198	11	20	35	0

Each product code has a corresponding catalog of components for this product, which goes in another spreasheed given the following format:
WFW9550WL		
item		description			qty
W10270180	Some silly piece of Machinery	1

This spreadsheet contains all product codes and component codes in the same 3 columns.
Finally, in this same second workbook, there is an spreadsheet which contains the components for the component code's component! ( WTF | :WTF: ) in the following arrangement:
PartNo		Description			Supplier	Family		W10159465	W10261477	W10074160	8540050
W10270180	PPGV30				WPenn		Family1		5		10		0		1


What is the expected result? Easy, the amount of pieces of pieces's pieces and their codes of course XD
First of all, could it be possible to do in VB for Applications alone? May be that is late at night but I got stuck on here. I'm also trying with a Office solution but may be lack of understanding of the component model that I haven't figured this out. If you have any suggestions, all are well accepted Big Grin | :-D
If I come with a solution before, I'll let you know and even post the resulting code in case anyone faces a similar requirement Big Grin | :-D

Thanks CP! Good night, and good luck!

moved on Wednesday, January 19, 2011 2:04 AM

modified on Wednesday, January 19, 2011 9:59 AM

AnswerRe: Orphan Question Pin
Andy_L_J18-Jan-11 20:01
Andy_L_J18-Jan-11 20:01 
QuestionPre-requisites for email program Pin
Uma Kameswari18-Jan-11 19:42
Uma Kameswari18-Jan-11 19:42 
AnswerRe: Pre-requisites for email program Pin
Dave Kreskowiak19-Jan-11 2:20
mveDave Kreskowiak19-Jan-11 2:20 
GeneralRe: Pre-requisites for email program Pin
Uma Kameswari24-Jan-11 18:28
Uma Kameswari24-Jan-11 18:28 
AnswerRe: Pre-requisites for email program Pin
_Erik_19-Jan-11 5:29
_Erik_19-Jan-11 5:29 
QuestionCHM html help called from VB6 application works but can't be searched [modified] Pin
reto.knaak14-Jan-11 4:02
reto.knaak14-Jan-11 4:02 
QuestionCommunication between VBscript and command prompt window Pin
Tim_abcd14-Jan-11 1:35
Tim_abcd14-Jan-11 1:35 
AnswerRe: Communication between VBscript and command prompt window Pin
Dave Kreskowiak14-Jan-11 3:57
mveDave Kreskowiak14-Jan-11 3:57 
GeneralRe: Communication between VBscript and command prompt window Pin
Tim_abcd15-Jan-11 20:38
Tim_abcd15-Jan-11 20:38 
QuestionNumber of files in a folder Pin
Central_IT13-Jan-11 1:48
Central_IT13-Jan-11 1:48 
AnswerRe: Number of files in a folder PinPopular
Luc Pattyn13-Jan-11 1:58
sitebuilderLuc Pattyn13-Jan-11 1:58 
QuestionHow to detect the launched appliction? Pin
azusakt12-Jan-11 15:40
azusakt12-Jan-11 15:40 
AnswerRe: How to detect the launched appliction? PinPopular
Luc Pattyn12-Jan-11 16:21
sitebuilderLuc Pattyn12-Jan-11 16:21 
GeneralRe: How to detect the launched appliction? Pin
azusakt18-Jan-11 17:34
azusakt18-Jan-11 17:34 
AnswerRe: How to detect the launched appliction? Pin
JR21212-Jan-11 22:38
JR21212-Jan-11 22:38 
QuestionVb.Net - ListView - display items Pin
Central_IT12-Jan-11 1:52
Central_IT12-Jan-11 1:52 
AnswerRe: Vb.Net - ListView - display items Pin
Richard MacCutchan12-Jan-11 2:27
mveRichard MacCutchan12-Jan-11 2:27 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.