+ Reply to Thread
Results 1 to 1 of 1

save two sheets contains data and shapes , pictures to directory as PDF

  1. #1
    Forum Contributor
    Join Date
    06-17-2021
    Location
    Asia
    MS-Off Ver
    2019
    Posts
    219

    save two sheets contains data and shapes , pictures to directory as PDF

    Hello
    I have two sheets names(SALES & PURCHASE) contain data from column B:I
    each sheet strat from row 18 , invoice number is existed in shape (Rectangle 55)
    the invoice number will be for both sheets(SAL189-01-023-INV01,PUR189-01-023-INV01)
    before row18 contains some pictures and shapes to enter DATE and NAMES .so what I want :
    first: create two folders names are (SALES & PURCHASE) in this directory "C:\Users\PC TUBB\Desktop\INVOICES"
    second: create folders names are years based on current year inside folders (SALES & PURCHASE)
    third: create folders names are months (JANUARY, FEBRUARY....) inside folders (YEARS) for each sheet.
    fourth: save every sheet based on invoice number is existed in shape (Rectangle 55) inside folder month based on current month as PDF
    fifth: every time run the macro should replace the files insides the months folders .
    I hope to don't forget another thing
    thanks in advance.
    Last edited by tubrak; 01-31-2023 at 11:36 AM.

+ 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. [SOLVED] Save all sheets except 2 as separate PDFs in the same directory
    By xceler8or in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-24-2018, 09:38 AM
  2. [SOLVED] Remove sheet shapes, leave pictures?
    By B.W.B. in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-07-2017, 02:23 PM
  3. Accessing Hidden Sheets By Clicking Pictures and Inserted Shapes
    By daniel75211 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-26-2016, 10:09 AM
  4. Replies: 8
    Last Post: 01-11-2015, 06:01 PM
  5. Replies: 1
    Last Post: 05-02-2014, 06:18 AM
  6. [SOLVED] Save Multiple Sheets as Text File // Abliity to Choose Directory for Saving Location
    By nhi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2013, 01:19 PM
  7. [SOLVED] Creating an excel macro to open and save sheets to a different directory
    By sem in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-29-2005, 03:05 PM

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