Page 4 of 4 FirstFirst ... 234
Results 31 to 33 of 33

Thread: VBA script for conditional copy, format & paste from workbook1 to workbook2

  1. #31
    Board Regular mumps's Avatar
    Join Date
    Apr 2012
    Location
    Toronto, Canada
    Posts
    8,297
    Post Thanks / Like
    Mentioned
    94 Post(s)
    Tagged
    5 Thread(s)

    Default Re: VBA script for conditional copy, format & paste from workbook1 to workbook2

    If you want to save the workbook without losing the macro, you must save it as a macro-enabled file which will change the extension to "xlsm".
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  2. #32
    Board Regular
    Join Date
    Mar 2012
    Posts
    57
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA script for conditional copy, format & paste from workbook1 to workbook2

    hi mumps

    yes, workbook which contain our macro is always saved as macro-enabled file.
    here, our macro processing specified data of macro-enabled file & creates a new file which has been saved as an csv file. (for further processing by a tool).
    only saving the file with content as csv causing issues.

  3. #33
    Board Regular
    Join Date
    Mar 2012
    Posts
    57
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA script for conditional copy, format & paste from workbook1 to workbook2


Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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