Opening 3 different files with VBA

[kenman]

Hello, I'm a VBA user wannabe, trader, and am really interested in learning about all the possibilites wuth Excel. What a great program, now that I've touched the service and have read part of your "VBA and Macros for microsoft Excel"
I'm trying to write a vba macro on a master sheet that will open, go through or at least let me answer the questions about delimeters, date columns, etc., for 3 different files. The files are updated daily, with the date at the end of the file name changing showing the current date, the beginning part of the name different based on where it's coming from, and teh extension different for 3 different files.
The 3 different files are loaded onto 3 different sheets in the same workbook..
Is there any way to, if nothing else, get the program to open where the file is, pause the program so that I can get the 3 files loaded into my workbook, so that I can run the VBA programs I have on the 3 different sheets?

Thanks, you've got a great site and I look forward to learning more as I go along...
kenman

 

[Tazguy37]

Welcome to the Board!

Have you looked at the OpenText method? (Example from VBA Help follows):

Workbooks.OpenText filename:="DATA.TXT", _
    dataType:=xlDelimited, tab:=True

You can just open the files in your code (though they'll most likely go into their own windows). But you can move the sheets to a single workbook if you need to after they've been imported.

Hope that helps!

 

[kenman]

Hi Taz, Thanks for the info, I'll give it a try and see what happens..