Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 20th 20, 04:17 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2020
Posts: 16
Default Importing multiple .txt files in a directory

Hi All

I have looked at, and tried many variants of this from google searches, but none thus far do what it is i'm looking to do.

I recall seeing something similar to what I am hoping to achieve, but for the life of me, I can't remember where or when.

All the text files have the same "," delimitation and the data structures are identical, there will be as many as a 100 files in the folder.

Ideally the code will loop through each file, then copy/append the data into Sheets("Import") starting at Row(2)

I will then add the code to move all the copied files into a new "Folder:\\Processed Files" so the main folder will always be empty for the daily Rinse/Repeat.

As always, many thanks in advanced for your time.

Cheers
Mark.

  #2   Report Post  
Old March 20th 20, 06:19 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1,182
Default Importing multiple .txt files in a directory

Hi All

I have looked at, and tried many variants of this from google searches, but
none thus far do what it is i'm looking to do.

I recall seeing something similar to what I am hoping to achieve, but for the
life of me, I can't remember where or when.

All the text files have the same "," delimitation and the data structures are
identical, there will be as many as a 100 files in the folder.

Ideally the code will loop through each file, then copy/append the data into
Sheets("Import") starting at Row(2)

I will then add the code to move all the copied files into a new
"Folder:\\Processed Files" so the main folder will always be empty for the
daily Rinse/Repeat.

As always, many thanks in advanced for your time.

Cheers
Mark.


Hi Mark,
Can you provide a sample file AND the File Explorer Address to your network
share? A sample of the target worksheet headings (row1 fieldnames) will also be
helpful!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
  #3   Report Post  
Old March 23rd 20, 12:17 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2020
Posts: 16
Default Importing multiple .txt files in a directory

Hi Garry

Thanks for your time.

Apparently, this is not going ahead, due to the fact the person who asked for it, didn't bother to tell me, all the files are actually PDF's, not CSV's, so no stress anymore.

I even thought about there being a way to do the same for these, and there is, sadly though <sigh, the company I.T. gestapo, won't give me access to the PDF libraries.

In the end, I just shrug and walk away as it's not work the brain hemorrhage.

Cheers
Mark.
  #4   Report Post  
Old March 23rd 20, 05:10 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1,182
Default Importing multiple .txt files in a directory

Hi Garry

Thanks for your time.

Apparently, this is not going ahead, due to the fact the person who asked for
it, didn't bother to tell me, all the files are actually PDF's, not CSV's, so
no stress anymore.

I even thought about there being a way to do the same for these, and there
is, sadly though <sigh, the company I.T. gestapo, won't give me access to
the PDF libraries.

In the end, I just shrug and walk away as it's not work the brain hemorrhage.

Cheers
Mark.


No surprise there! Regardless, the source files the PDFs were created from
should work. Or.. they could be coverted to txt files.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
  #5   Report Post  
Old March 24th 20, 01:09 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2020
Posts: 16
Default Importing multiple .txt files in a directory

Hi Garry

100% agree. I did see some nifty code to extract the raw data from PDF, which is why I went to I.T. for access to the Acrobat Libraries.

In-as-much-as, I fully appreciate they're likely pigeon-holed with guidelines and policy, but i'm also leaning toward there being a plausible smattering of narcissistic joy!!

It's times like this, I question if they're on the same side of improvement & innovation when it comes to data management.

Thanks again for your time and thoughts.

Cheers
Mark.



  #6   Report Post  
Old March 24th 20, 05:16 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1,182
Default Importing multiple .txt files in a directory

Hi Garry

100% agree. I did see some nifty code to extract the raw data from PDF, which
is why I went to I.T. for access to the Acrobat Libraries.

In-as-much-as, I fully appreciate they're likely pigeon-holed with guidelines
and policy, but i'm also leaning toward there being a plausible smattering of
narcissistic joy!!

It's times like this, I question if they're on the same side of improvement &
innovation when it comes to data management.

Thanks again for your time and thoughts.

Cheers
Mark.


IT people in general are rather stiff-necked about everything, pretty much. If
the data you're after was printed to PDF from a text editor or word processor
or whatever utility app then you could just use a PDF converter to revert that.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
  #7   Report Post  
Old March 24th 20, 07:51 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2020
Posts: 1
Default Importing multiple .txt files in a directory

On Tuesday, March 24, 2020 at 10:16:40 AM UTC-7, GS wrote:
Hi Garry

100% agree. I did see some nifty code to extract the raw data from PDF, which
is why I went to I.T. for access to the Acrobat Libraries.

In-as-much-as, I fully appreciate they're likely pigeon-holed with guidelines
and policy, but i'm also leaning toward there being a plausible smattering of
narcissistic joy!!

It's times like this, I question if they're on the same side of improvement &
innovation when it comes to data management.

Thanks again for your time and thoughts.

Cheers
Mark.


IT people in general are rather stiff-necked about everything, pretty much. If
the data you're after was printed to PDF from a text editor or word processor
or whatever utility app then you could just use a PDF converter to revert that.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


My utility, PDF Architect, does a credible job of converting PDF's to text, word, excel, Image, HTML...
  #8   Report Post  
Old March 25th 20, 01:22 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1,182
Default Importing multiple .txt files in a directory

On Tuesday, March 24, 2020 at 10:16:40 AM UTC-7, GS wrote:
Hi Garry

100% agree. I did see some nifty code to extract the raw data from PDF,
which is why I went to I.T. for access to the Acrobat Libraries.

In-as-much-as, I fully appreciate they're likely pigeon-holed with
guidelines and policy, but i'm also leaning toward there being a plausible
smattering of narcissistic joy!!

It's times like this, I question if they're on the same side of improvement
& innovation when it comes to data management.

Thanks again for your time and thoughts.

Cheers
Mark.


IT people in general are rather stiff-necked about everything, pretty much.
If the data you're after was printed to PDF from a text editor or word
processor or whatever utility app then you could just use a PDF converter
to revert that.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


My utility, PDF Architect, does a credible job of converting PDF's to text,
word, excel, Image, HTML...


Yes, I have this (and others)!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Joel - Importing multiple text files to 1 spreadsheet, now importing from excel files Volker Hormuth Excel Programming 7 April 9th 09 06:55 PM
importing text files into excel from a set directory on a montly b j Excel Programming 1 October 31st 08 10:21 PM
importing data from mulitple files in a directory charles Excel Discussion (Misc queries) 1 October 24th 08 02:04 AM
Accessing Excel files within multiple levels of a directory Barb Reinhardt Excel Programming 4 May 15th 07 07:12 PM
importing files from a directory dr chuck Excel Programming 2 June 19th 06 04:08 PM


All times are GMT +1. The time now is 09:08 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017