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 / Programming / January 2006

Tip: Looking for answers? Try searching our database.

problem with import files by excel macro

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Raven - 20 Jan 2006 08:23 GMT
Hello,

I need to write/record a macro that takes multiple files(UNIX files)on
the local computer and then copy all their content back to a sheet of
the excel and then manipulate the data to generate a report. I
particularly need help with macros that can import multiple files. I
have come across an excel application whose button can prompt a windows
and import ONE file to do similiar thing. However, what I want to do is
more sophisticated. Do you have any idea?? do you have any resources
from the web?? Thx!!
Martin Fishlock - 20 Jan 2006 08:45 GMT
Why not make a list of the files to import and then work through the list
importing the processing the file as required.
Signature

HTHs Martin

> Hello,
>
[quoted text clipped - 6 lines]
> more sophisticated. Do you have any idea?? do you have any resources
> from the web?? Thx!!
Raven - 20 Jan 2006 08:56 GMT
oh, because the files are logs from several servers whose names change
daily.

and thx NickHK
 
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.