code to copy txt files from floppies

**hsmeet** · 11-16-2008, 08:29 PM

Hi all,

i m attaching excel sheet where i have to paste the data from txt files that come to me on floppies (18 floppies from 18 departments)

the floppies have data in rows. i have to omit first and last row of that txt file and copy all the rest rows in column H of my sheet Named "DATA". you may understand that this data has to be pasted one below the other in subsequent rows.
i then use MID formula to get the information from this data into column A to column F

MY PROB IS
that i want a button on my sheet DATA that i click to get data from inserted floppy in drive A.
code must check the file name
which is named in a convention as under

Example:
ICI short name of deptt
1 or 2 zone number which is always 1 or 2 and i have 2 DATA sheets i.e. DATA for zone 1 and DATA2 for zone 2
then comes the four digits for date and month
1211 where 12 is date and 11 is NOV month

help a code that reads the file with current (today's) date only and ignores all other files if any on the floppy. it should also ignore zone 2 if i m on DATA and it shud ignore zone 1 if i m on DATA2.
here i need two separate codes for my two sheets namely DATA and DATA2. DATA gets files for Zone 1 and in the second session the DATA2 gets files for Zone 2.

i know my prob is some tough but you guys are great at codes and i hope to get the solution.

thnx in advance

**rylo** · 11-16-2008, 08:53 PM

Hi

See how this goes. Assumes that the files will be on the root directory of the floppy. Didn't test it on a floppy.....

Please Login or Register  to view this content.

HTH

rylo

**hsmeet** · 11-17-2008, 12:08 PM

sorry sir,

i tried your code by copying it into new sub and then assigning the macro to a button.
when i click the button the system assesses the floppy but nothing else happens.

i m quite new to VBE and could not find the problem in code

please help

**hsmeet** · 11-19-2008, 08:24 PM

Hi All,
My problm remains unsolved

i hope i could not make you ppl understand my prob properly.

anyways,
i m doing this manually...
thanx u all

TC

**rylo** · 11-19-2008, 11:52 PM

Hi

1) Are the files on the root directory on the A drive? If not then where are they (what is the full path to one of the files.)

2) Try copying one of the files to C:\temp. Change the line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and see if that works.

3) If that doesn't work, then put up a copy of one of the text files, and the output file so we can review.

rylo

**hsmeet** · 11-27-2008, 09:48 PM

Dear Rylo,

it still does not work for me.
the source and output files are already posted by me in my first post above.

the txt.zip is having all the files that i have to copy to my output file "New One.xls" in its DATA sheet. rest is already mentioned in my first post.

please help

(sorry for late responding as i was away for some days)

**rylo** · 11-27-2008, 10:16 PM

Hi

Don't know what else to suggest. I put the file ICI11211.txt into C:\TEMP, then renamed it to ICI12811.txt. Put the code I gave you into module 1 of new one.xls, changed the drive and directory to reflect C:\temp and ran the code. Brought in the file OK.

rylo

code to copy txt files from floppies

LinkBack

Thread Tools

Rate This Thread

Display

code to copy txt files from floppies

it did not help

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions