+ Reply to Thread
Results 1 to 9 of 9

How to the office report form excel data that will be automatically filled up by macro.

  1. 02-28-2017, 07:23 AM #1
    Rinkojhon
    Rinkojhon is offline
    Registered User
    Join Date
    04-10-2015
    Location
    Bangladesh
    MS-Off Ver
    Windows 2013
    Posts
    39

    How to the office report form excel data that will be automatically filled up by macro.

    Hi,

    I am trying to work on for few months but can make any positive results. I manually compile employees' leave records and added them on leave form one by one. After that, I print that sheets and employees sign on that. There are almost 300 employees working. So, this is a time killing tasks. To save my time and reduce my work pressure I need to fill those forms automatically.

    First I this can be done by MS access and talked this an access specilist but he suggest that MS excel is best option for that. There are some excel templates or macro for that.

    I have attached an exel file with 2 demo doc files (how I actulay need the file as an example)


    I need to get report like "Demo filled up_Leave Application Form _New (2016)" that will be automatically generated from that exel "Leave details" file in excel or doc into those blank spaces and I will just print those pages at a time.
    Leave details.xlsx
    Leave Application Form _New (2016).doc
    Leave Application Copy.jpg
    Thanks in Advance,

    Best,
    Rinko.
    Reply With QuoteRegister To Reply
  2. 02-28-2017, 08:22 AM #2
    MatrixMan
    MatrixMan is offline
    Valued Forum Contributor
    Join Date
    09-19-2008
    Location
    It varies ...
    MS-Off Ver
    Office365 - 64bit
    Posts
    862

    Re: How to the office report form excel data that will be automatically filled up by macro

    Hi Rinko. In the spreadsheet you have Staff ID, Staff Name, Leave Type, Leave Taken, Department, and the dates From & To, so 7 fields in total. In the leave form you want filled in there are other fields not listed in the spreadsheet - Code No. Designation, Address During Leave, and so on.

    So while we can populate the fields from the spreadsheet into a new leave form (and auto-print it for you as well) ... it will still not have all the fields populated so it probably won't save that much time. Do you want to provide the other fields or just go with it as it is?
    MatrixMan.
    --------------------------------------
    If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
    If your issue is now resolved, remember to mark as solved - click Thread Tools at top right of thread.
    Reply With QuoteRegister To Reply
  3. 02-28-2017, 10:18 AM #3
    MatrixMan
    MatrixMan is offline
    Valued Forum Contributor
    Join Date
    09-19-2008
    Location
    It varies ...
    MS-Off Ver
    Office365 - 64bit
    Posts
    862

    Re: How to the office report form excel data that will be automatically filled up by macro

    See attached file. To generate leave forms, select "Yes" in the column "Create Leave Form?" then click the button. Hope that's what you were after - for completeness, the code is below as well. 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 03-02-2017, 09:29 AM #4
    Rinkojhon
    Rinkojhon is offline
    Registered User
    Join Date
    04-10-2015
    Location
    Bangladesh
    MS-Off Ver
    Windows 2013
    Posts
    39

    Re: How to the office report form excel data that will be automatically filled up by macro

    Hi MatrixMan,

    Sorry for the confusion. Code ID is the Staff ID you mentioned. I just need to add "Designation" tab, remaining options will be filled by the employee manually.

    Thank you much. I got that file and working on it, how its work.

    Thank you.
    Rinko.
    Reply With QuoteRegister To Reply
  5. 03-02-2017, 03:58 PM #5
    MatrixMan
    MatrixMan is offline
    Valued Forum Contributor
    Join Date
    09-19-2008
    Location
    It varies ...
    MS-Off Ver
    Office365 - 64bit
    Posts
    862

    Re: How to the office report form excel data that will be automatically filled up by macro

    No problem - if this is now complete, please make the thread solved :-)
    Reply With QuoteRegister To Reply
  6. 03-03-2017, 12:30 PM #6
    Rinkojhon
    Rinkojhon is offline
    Registered User
    Join Date
    04-10-2015
    Location
    Bangladesh
    MS-Off Ver
    Windows 2013
    Posts
    39

    Re: How to the office report form excel data that will be automatically filled up by macro

    Hi MatrixMan,

    Sorry for disturbing you. Though it is working nicely but facing "run-time error" 1004. This is happening when I am using actual name. like - Md. Obaidur Rahman Baig (23 Characters), this is the logest name amoung my team members. it only works upto 11 (Characters), like - Md. Obaidur. Is there any solution for that?

    baig.JPG

    Thank You.
    Haniar.
    Last edited by Rinkojhon; 03-03-2017 at 12:31 PM. Reason: Attachment
    Reply With QuoteRegister To Reply
  7. 03-04-2017, 06:01 AM #7
    MatrixMan
    MatrixMan is offline
    Valued Forum Contributor
    Join Date
    09-19-2008
    Location
    It varies ...
    MS-Off Ver
    Office365 - 64bit
    Posts
    862

    Re: How to the office report form excel data that will be automatically filled up by macro

    It's just the naming of the sheet ... it's limited to 31 characters. I've changed it so the forms are sequentially numbered instead. Replace the code with the below: 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 03-07-2017, 09:17 AM #8
    Rinkojhon
    Rinkojhon is offline
    Registered User
    Join Date
    04-10-2015
    Location
    Bangladesh
    MS-Off Ver
    Windows 2013
    Posts
    39

    Re: How to the office report form excel data that will be automatically filled up by macro

    Hi MatrixMan,

    It is working, thank you for your help.

    Best,
    Rinko
    Reply With QuoteRegister To Reply
  9. 03-07-2017, 10:27 AM #9
    MatrixMan
    MatrixMan is offline
    Valued Forum Contributor
    Join Date
    09-19-2008
    Location
    It varies ...
    MS-Off Ver
    Office365 - 64bit
    Posts
    862

    Re: How to the office report form excel data that will be automatically filled up by macro

    You're welcome Rinko - thanks for the rep point and taking the time to say thanks

    Cheers, MM
    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. Office 2010: Transfer Form Content Control Data into Excel Database - Macro Help
    By Maredon2016 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-25-2016, 03:45 PM
  2. [SOLVED] Excel form writing filled data to another Excel file or sheet
    By G.Bregvadze in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-08-2014, 03:34 AM
  3. Excel macro to open an office form
    By garfman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-18-2013, 04:30 AM
  4. [SOLVED] How do I automatically transfer data from one Excel report to another?
    By s3a in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-08-2012, 01:38 AM
  5. Excel 2007 : Rum Macro EXCEL automatically MS Office 2007
    By excelex in forum Excel General
    Replies: 2
    Last Post: 07-29-2011, 01:52 PM
  6. Automatically filled in form
    By Xathrax in forum Excel General
    Replies: 4
    Last Post: 11-17-2010, 06:53 AM
  7. macro for a form properly filled
    By corchox in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-19-2010, 10:53 PM

Tags for this Thread

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