- Community Home
- >
- Servers and Operating Systems
- >
- Legacy
- >
- Networking
- >
- Excel macro to display remote file.
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-17-2005 06:05 PM - last edited on 09-22-2013 07:19 PM by Maiko-I
04-17-2005 06:05 PM - last edited on 09-22-2013 07:19 PM by Maiko-I
Hi Guys,
How can I write a excel's macro script on my pc to copy a file from a Unix system and display the result every 5 minutes interval?
Thank u.
Best regards
Henry
P.S. This thread has been moevd from Archived Desktops and Workstations Boards > Windows based to Microsoft > networking. - Hp forum moderator
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-18-2005 09:04 AM
04-18-2005 09:04 AM
Re: Excel macro to display remote file.
Ron
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-18-2005 12:39 PM
04-18-2005 12:39 PM
Re: Excel macro to display remote file.
What I would like to do is the transfer the file over to the window system either thru ftp or any other means; is it possible to map a unix folder? then the program will used macro to generate a graph chart and refreshes every 5 mins or so. My main hurdle is to know how to transfer the file over from unix to window..
The information coming in should append the existing data - row by row
Thank u
Henry
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-19-2005 04:19 AM
04-19-2005 04:19 AM
Solutionhttp://www.cae.wisc.edu/site/public/?title=2ksamba
http://www.amherst.edu/it/web/unix/mapwin.html
This is how you write an ftp script in windows:
http://support.microsoft.com/?kbid=96269
I'm thinking it would be easier to have the UNIX system ftp the file to your box every five minutes. You could run War Ftp as an ftp server or use the sorry one that comes with Windows. Then your Excel program would only need to look in the receiving folder periodically and if it saw something grab the file and move it. You have to be careful with this since the possibility of a race condition exists. (Excel might try to get the file before FTP is completed and thus only get part of a file)
What I still don't understand is what the file looks like or represents. Is it just a single number, a string of numbers or something else. Does the file have the same name everytime or does it change. If it has the same name do we need to filter out the additions or process the info somehow?
So far it is starting to sound like MRTG would solve your problem better than Excel. It runs every 5 minutes and gets data from other systems by default with snmp but can also run a script instead then processes the data and draws a constantly updating graph which can be displayed by a web browser if desired. It's a free program. Runs on Perl which is also free. Originally designed to just monitor network traffic it has been expanded over the years to be very flexible.
http://mrtg.hdl.com/mrtg.html
Ron