Headstrong2740
New Member
- Joined
- Nov 17, 2014
- Messages
- 1
Hi all... I have been searching for reasonable solutions to this process.
So i have a Folder that is storing data from a test process. This means there are multiple files to copy from.The files have an extension of .tdms or .tdms_index. These each have two worksheets in it. The second one called "Untitled" contains the raw data I want.
I want to have an excel workbook run a VBA program to pull the data from the second sheet in each file with only the .tdms extension (not the .tdms_index). Here is the twist.... i think... I need it to create a new worksheet (tab) in the workbook to show that file name in the tab AND be based off the second tab titled "Template".
There is a column in the template that says X,Y,or Z data or Augur Data. the associated raw data needs to be placed into those 4 columns.
So for example.. the first file is 1H012345678910. The VBA needs to pull the raw data from the second sheet in that file and copy it to "Data Analysis.xlsm" into a new sheet after the template sheet with the tab called 1H012345678910. THat sheet has to be created to copy the template layout.
I included a copy of the workbook to give you an idea of what it needs to do.
HELP! This is for a senior design project Im working on and this was a last minute twist to the project that has caught me and my group off guard.
Please ask questions if this is not clear... the first tab (graphs) has some explination on it. The file can be found here.
http://wikisend.com/download/753836/Data Analysis.xlsm
(only good for 7 days before its deleted)
So i have a Folder that is storing data from a test process. This means there are multiple files to copy from.The files have an extension of .tdms or .tdms_index. These each have two worksheets in it. The second one called "Untitled" contains the raw data I want.
I want to have an excel workbook run a VBA program to pull the data from the second sheet in each file with only the .tdms extension (not the .tdms_index). Here is the twist.... i think... I need it to create a new worksheet (tab) in the workbook to show that file name in the tab AND be based off the second tab titled "Template".
There is a column in the template that says X,Y,or Z data or Augur Data. the associated raw data needs to be placed into those 4 columns.
So for example.. the first file is 1H012345678910. The VBA needs to pull the raw data from the second sheet in that file and copy it to "Data Analysis.xlsm" into a new sheet after the template sheet with the tab called 1H012345678910. THat sheet has to be created to copy the template layout.
I included a copy of the workbook to give you an idea of what it needs to do.
HELP! This is for a senior design project Im working on and this was a last minute twist to the project that has caught me and my group off guard.
Please ask questions if this is not clear... the first tab (graphs) has some explination on it. The file can be found here.
http://wikisend.com/download/753836/Data Analysis.xlsm
(only good for 7 days before its deleted)
