Import data from unknown workbook name

**Jamesraywebber85** · 05-21-2018, 11:38 AM

I have this code which a report is generated and it is not a constant name except the beginning of the file name which is "_ttv-".

Please Login or Register  to view this content.

Its not pulling the data like I need it to. The workbooks name always changes after I generate it - after it copies that data over, I would like the "_ttv-" workbook to close. Any help would be greatly appreciated! Thank you in advance!

**JLGWhiz** · 05-21-2018, 01:34 PM

Its not pulling the data like I need it to.

This tells me nothing that I can use to fix it.

The workbooks name always changes after I generate it

Is this a problem, or just a statement of fact?

I would like the "_ttv-" workbook to close

If you want to save the workbook then

Please Login or Register  to view this content.

If Not then

Please Login or Register  to view this content.

Place this statement before the 'Next wb' statement.

**Fluff13** · 05-21-2018, 02:55 PM

How about

Please Login or Register  to view this content.

This will save the _ttv workbook

**PCI** · 05-21-2018, 04:34 PM

What makes the difference with your previous thread

https://www.excelforum.com/excel-pro...3-import-data-

A remake with file closing ...!

Please Login or Register  to view this content.

Import data from unknown workbook name

LinkBack

Thread Tools

Rate This Thread

Display

Import data from unknown workbook name

Re: Import data from unknown workbook name

Re: Import data from unknown workbook name

Re: Import data from unknown workbook name

Thread Information

Users Browsing this Thread

Similar Threads

Import data to a workbook from another workbook with relative path

Can I have Excel search another workbook for data and import it to my current workbook?

Import data from closed workbook, export data to closed workbook - rename current workbook

[SOLVED] Import data from an excel workbook to another workbook without manually selecting

import data from a closed workbook to another opened workbook

Collecting Data from multiple sheets of a workbook and import them into new workbook

[SOLVED] Import/Copy some data from one workbook to a similar workbook

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions