+ Reply to Thread
Results 1 to 4 of 4

VBA or Macro extract range from excel and save as prn file

Hybrid View

  1. 07-23-2021, 08:31 AM #1
    Switchblade IX
    Switchblade IX is offline
    Registered User
    Join Date
    06-18-2021
    Location
    Bloemfontein, south Africa
    MS-Off Ver
    2019
    Posts
    65

    VBA or Macro extract range from excel and save as prn file

    Hi Everyone,

    I'm stuck once again. I don't know much about vba/macros and would like to write something into attached file to extract the range highlighted in yellow and save that range as a prn file.

    I would also like to link the vba/macro to a button at the top of the sheet to make it easy for the operator to execute it once the prices have been changed
    Attached Files Attached Files
    Last edited by Switchblade IX; 07-23-2021 at 08:35 AM.
    Reply With QuoteRegister To Reply
  2. 07-23-2021, 09:31 AM #2
    Mumps1
    Mumps1 is online now
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,876

    Re: VBA or Macro extract range from excel and save as prn file

    Try the attached file. It will save the prn file in the same folder as your Test Scale Program file using the same file name.
    Attached Files Attached Files
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.
    Reply With QuoteRegister To Reply
  3. 07-23-2021, 09:43 AM #3
    Switchblade IX
    Switchblade IX is offline
    Registered User
    Join Date
    06-18-2021
    Location
    Bloemfontein, south Africa
    MS-Off Ver
    2019
    Posts
    65

    Re: VBA or Macro extract range from excel and save as prn file

    Hi Mumps1

    Thanks A Million!!!

    Works like a charm
    Reply With QuoteRegister To Reply
  4. 07-23-2021, 09:53 AM #4
    Mumps1
    Mumps1 is online now
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,876

    Re: VBA or Macro extract range from excel and save as prn file

    You are very welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] save excel file as CSV (specify the range and the path)
    By abdi1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-21-2021, 01:16 PM
  2. Extract text - save to excel file
    By Pykie in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 03-26-2019, 06:34 PM
  3. VBA to Extract to Excel the file from Website then Save and then Open
    By 200yrs in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-12-2015, 04:29 AM
  4. Macro to extract a tab from one file, add it to a master template file and then save as
    By SweetSorcery in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-03-2014, 11:36 AM
  5. Extract range between two values and save as new file
    By GDM69 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-19-2013, 10:09 AM
  6. [SOLVED] Save new excel file from range
    By dalerdd in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-15-2013, 04:48 PM
  7. [HELP] How to save selected range in a seperate excel file
    By bigpappi23 in forum Excel General
    Replies: 3
    Last Post: 02-22-2013, 03:57 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1