System Information - cannot be collect

Similar Threads:

1.Use VBA to collect information from Excel cells to av word doc

2.Use VBA to collect information from Excel cells to av word documen

I have reference Office 11.0 Object lib. as a default. To get all the Excel 
objects i activate the Microsoft Excel 11.0 Object library.

Then i can brows it all, by then i create a VBA code then VBA can't use the 
Excel Objects as  :
Dim Text as string 
Text=cstr(Workbooks("BookName.xls").Worksheets("SheetName").Cells(1,1))

I have tried a line i use in VB6

Dim XLS
Dim Text as string 
set XLS = GetObject(, "Excel.Application")

XLS.Workbooks("BookName.xls").Worksheets("SheetName").Cells(1,1))

This gives med tha same as
Text =cstr(Exel.Workbooks("BookName.xls").Worksheets("SheetName").Cells(1,1))

I can brows the object model, but i can't use it.

Is there an other code that enebles the Excel object model in WORD.

Best regards





-- 
yvind

3.Collect Logical Drive Information

I am trying to collect logical drive information for every server in
our environment and write the information to a semicolon delimited
text file. For each logical drive I am recording the DeviceID, Disk
Size, Free Space, and then calculating the consumed space and writing
each value to the text file. The goal is to be able to import the data
into Excel so all the columns line up correctly. The problem I am
having is that each server could have a different number of logical
drives. I am recording other information (IP Address) after the
logical drive information and I want that information to consistenly
start in the same column.

I don't have any problem getting the script to run correctly and
collect the information, just formatting it into useable data in
Excel. Any suggestions would be appreciated.

Thanks

4.How to collect disk space information

Hello folks. I am trying to write a script where i can put a list of
server in a text file and get information on their disk utilization.
Something like Free disk, used disk , Total disk. Can anybody point me to
some samples? It will be executed against Win2k servers.

Thanks

5.collect contact information

I am not a programmer, only network and systems admin who knows enough
to be dangerous.

I would like to collect information such as addresses and phone numbers
from end users and save the results to a database.  I will ultimately
import that data into Active Directory.

I am using a Kix Script that contains some VB and uses WMI to collect
hardware information and save it to a table in an SQL database.  I
would like to collect information such as addresses and phone numbers
from end users and save that to the SQL database as well.

Can someone help me with the following.  Here is my logic:
1.  Detect the username at login and match it to the username field in
SQL database.

2.  If address and phone number are blank than pop up a form for them
to fill out.  Clicking OK will save the fields to the database.  Also
register the date the form was filled out.

3.  If address and phone number are NOT blank.  Verify if it is older
than 90 days.  If it's older, pop up the form.  if Not, continue
through the script.

thanks!
Brian

6. Using forms to collect information

7. collecting the information of a custom DataBoundControl

8. need to collect event information at end of application