Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / June 2007

Tip: Looking for answers? Try searching our database.

Importing data from text file without overwriting certain cells

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sean Murphy - 29 Jun 2007 21:32 GMT
I have a VBScript that writes Active Directory computer infromation to
a text file.  Excel imports the data from this text file and I build
charts reflecting the status of these machines.

I'm trying to monitor the progress of a migration from one domain to
another.

The script output indicates the computer is either in the source
domain, target domain, or unknown (because it is either offline or
access is denied).

My concern is, if I run the script a second time and a computer that
may have reported it was in the target domain (successful) the first
time may be offline and therefor no longer be successful. (Because the
cell will now change to unknown.)

I would like to import any new and/or updated data and NOT update a
cell that already has a value = the target domain (successful).

Does this make sense?

Thanks in advance for your attention.

Regards,
Sean Murphy
Paris - 30 Jun 2007 06:19 GMT
excel can read the file but it isn't database to store values...

i think you should try to build a database like access
read your text file and with access update query put new values to an
access table

           Sean Murphy       :
> I have a VBScript that writes Active Directory computer infromation to
> a text file.  Excel imports the data from this text file and I build
[quoted text clipped - 21 lines]
> Regards,
> Sean Murphy

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.