MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Import workbook


Posted by Yuri on November 01, 2001 12:41 PM

Hello, I need to automate everyday import from one excel
file to another. I need to write the code to pop up a window
were you can choose the file. Then have a choice of which
worksheet from that file to import into the new file. I am not
that fluent with VB and i can't figure how to do that.
If anyone can help i would greatly appreciate it.


Posted by Mark W. on November 01, 2001 12:44 PM

What version of Excel are you using? (nt)

Posted by yuri on November 01, 2001 12:46 PM

Re: What version of Excel are you using? (nt)

OFFICE/EXCEL 2000

Posted by Mark W. on November 01, 2001 12:52 PM

Re: What version of Excel are you using? (nt)

Why not use it's new Get External Data feature
that allows you import text files and prompt
for the file name of the text file each time
the external data range is refreshed? No VBA
code is needed.

Posted by yuri on November 01, 2001 12:58 PM

Re: What version of Excel are you using? (nt)

When i try doing that it tells me that there is no
existing tables.

Posted by Mark W. on November 01, 2001 1:12 PM

Are you choosing...

...the Data | Get External Data | Import Text
File... menu command? Doesn't it open an
Import Text File dialog?