+ Reply to Thread
Results 1 to 1 of 1

What is creating my workbook name?

  1. #1
    Forum Contributor Rick_Stanich's Avatar
    Join Date
    11-21-2005
    Location
    Ladson SC
    MS-Off Ver
    Office365
    Posts
    1,167

    What is creating my workbook name?

    I have a series of excel templates (With macros) that collects data from a CMM (Coordinate Measuring Machine).
    The data is read from three text files.
    I have managed to decipher how the "Characteristic.xlt file is setup and can manage my data that is placed.
    The templates are triggered internally by the CMM software.

    The text files have variables that uses the CMM programs name: 60022-100_1_Manifold Chem-Milled Stock_11-16-23
    and an incremental part counter so I end up with an excel file named: 60022-100_1_Manifold Chem-Milled Stock_11-16-23_40.xls

    I need to know what code is generating the workbook name.
    I have attached the templates and an XLS file that works with the templates along with three text files (Comma delimited?) and an example workbook that is created (I manually rename these).
    60022-100_1_Manifold Chem-Milled Stock_11-16-23_EB-D23-037_10.xls

    I can't seem to figure out what code creates the name of the workbook so I can change it?
    This is kind of a long shot, as I don't think you can run the templates/macros and compile data without being triggered by the CMM software.
    As always, any help is appreciated.

    P.S.
    When the Chqaracteristic_Test1.xlt files is opened, DO NOT click on the "Enable Content" button. (This will cause an INI file error to pop up).
    There is an "X" at the far right (In the yellow area), use it to remove the warning. See image: Capture.PNG
    Attached Images Attached Images
    Attached Files Attached Files
    Regards

    Rick
    Win10, Office 365

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Creating new excel workbook reports from data in spreadsheets in separate workbook
    By KristenBCK in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-18-2023, 08:49 PM
  2. Creating separate workbook (saving it in excel and pdf) from main workbook
    By john ashtar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-10-2020, 04:09 AM
  3. [SOLVED] Creating workbook from cell value - Directory created but workbook not saved as
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-14-2017, 09:04 AM
  4. Creating a new workbook, copying sheets & saving workbook - Subscript error
    By amphinomos in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-30-2014, 09:04 AM
  5. Replies: 4
    Last Post: 06-06-2011, 04:08 PM
  6. Replies: 5
    Last Post: 08-30-2010, 05:04 PM
  7. Replies: 0
    Last Post: 04-06-2010, 05:54 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1