Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Filename import into excel


  • Please log in to reply

#1
RossSA

RossSA

    Member

  • Member
  • PipPip
  • 15 posts
Hi,

A client has given me a spreadsheet with filenames descriptions etc. She has also loaded all the corresponding images into an FTP folder that we provided. She has in the spreadsheet added her own bits to the filenames compared to those that are actually in the FTP folder i.e. filename in folder is trainer.jpg, her spreadsheet entry reads Nike airmax trainer.jpg

Is there someway I can open the FTP folder copy the files and then import all the filenames into an excel column? There are 175 files that need to done.

Please help, don't have time to waste typing each one out.

Thank you :tazz:

Ross

Edited by RossSA, 16 February 2006 - 07:32 AM.

  • 0

Advertisements


#2
dsenette

dsenette

    Je suis Napoléon!

  • Administrator
  • 26,019 posts
  • MVP
if you access the ftp site through I.E....with folder view...you should be able to just highlight the names and copy and paste them...
  • 0

#3
RossSA

RossSA

    Member

  • Topic Starter
  • Member
  • PipPip
  • 15 posts
Hi dsenette,

Thanks for responding. I just need to copy the names and their extensions and popoulate an excel spreadsheet. Not copy and paste the file.

Thanks,
Ross
  • 0

#4
dsenette

dsenette

    Je suis Napoléon!

  • Administrator
  • 26,019 posts
  • MVP
right...that's what i mean...when it shows up in explorer...you will see a list of file names...if you highllight these...all you're highlighting is the text on the page...not the files
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP