Importing Files

[Ryujin]

Good Morning Friends ,

I need help to get a fuction to import Excel Files with VBA ,
I need to import the File it is entered in a Worksheet with the Name "Info" .

For Help you I will send the Excel that im working and the Excel that I want to import

Best Regards and ty

 

[Ruddles]

I don't know what to say - it's working here perfectly.

When the program stops with an error, press Debug and open an Immediate window (Ctrl-G), then type:-

?ThisWorkBook.Name
?wbImport.Name
?wsImport.Name

What do you get?

Is there anyone else reading this who is able to test this?

 

[Ruddles]

One more suggestion: place that code in a general code module, not a sheet code module. Maybe when the new sheet is activated, the code is losing track of where it is.

 

[Ryujin]

Appears That!

?ThisWorkBook.Name
ProgramaDavid.xlsm
?wbImport.Name
Transporte.xlsm
?wsImport.Name
Sheet1

Friend Were i can send u the files to you Check it?

 

[Macropod]

Cross-posted at:
https://www.excelforum.com/excel-programming-vba-macros/1181857-importing-files.html
https://gurudoexcel.com/forum/viewtopic.php?f=12&t=4525
http://chandoo.org/forum/threads/importing-files.34053/
http://www.planilhando.com.br/forum/viewtopic.php?f=10&t=24352
http://www.ozgrid.com/forum/showthread.php?t=203776
Please read Mr Excel's policy on Cross-Posting in rule #13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

 

[Ruddles]

Macropod, unfortunately I don't have a login for any of those other (inferior) boards. If you wish to lock this thread, please feel free to do so.