Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > URL's of VB samples
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 2nd May 00:09
raj
External User
 
Posts: 1
Default URL's of VB samples


IF you find some good ones...please do let me know
Cheers,
Raj
  Reply With Quote


  sponsored links


2 21st May 21:28
martin
External User
 
Posts: 1
Default URL's of VB samples & Object Browsers


Thanks Michael,

I may need to borrow some of the script you placed there
actually...

Along with VB sample scripts, is there a place that I can
get help on the actual classes, functions, properties etc
of the excel object? As when looking through the object
browser in Excel there isn't any help on each function or
property.


Simply what I am doing, and I suppose I need to know if
conceptually this is possible first and foremost is...

I have 3 columns and hundreds of rows of data, text in
column A, and numbers in columns B and C.

In A1, there is a header and the next 10-15 rows and
associated datd in columns B and C is the data I want.
After that there is are two blank rows, then again another
header and then again another 10-15 rows of data in the 3
columns.

The constant here is blank rows between the data in
columns.

There are only 2 different headers in the A column, so I
suppose the code would need to.

From A1, look for text "Header One", then copy all the
data below that header (and data in columns B,C next to
it), until 2 blank rows are found. Then output this to
another worksheet labelled "Header One"

And then the code can run the same code but looking
for "Header Two" and all data below till 2 blank rows
found, then output to worksheet "Header Two"

Sounds complex, but I'm sure it isn't for some!

Cheers,

Martin
  Reply With Quote
3 21st May 21:29
michael holzemer
External User
 
Posts: 1
Default URL's of VB samples & Object Browsers


No problem. MSDN will have all the information you are looking for on the
Excel application object

--
Regards,

Michael Holzemer

Please reply in newsgroup

Learn script faster by searching here
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/scriptcenter/default.asp

*************************************************
  Reply With Quote
4 1st June 15:17
mayayana
External User
 
Posts: 1
Default URL's of VB samples


I'm not sure that these are all still active but you can try them:

http://cwashington.netreach.net/
http://home.att.net/~wshvbs/index.htm
http://billsway.com/vbspage/
http://scripting.winguides.com/
http://www.borncity.de/
http://www.serialscripter.com/
http://www.windows-script.com/
http://www.winscripter.com/
http://homepages.go.com/~sbondi/powerscripting/
http://home.sprintmail.com/~mpryor/
http://www.swynk.com/winscript/
http://www.wshscripting.com/
http://www.jsware.net/jsware/scripts.html


--
--
  Reply With Quote
Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666