Calendar using VBA scripting

[alex.ransome]

Hi,

My wife uses an Excel spreadsheet for her Home Education planning, but each month I have to print the next month out and manually change the dates.

She uses Monday to Friday evrery week, so what would be the script to ask for the date you want the calendar to start from and then how many months and the pages are then created using that information.

Many thnaks for any suggestions.

[alansidman]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[alex.ransome]

Hi,

Thanks for responding.

I have attached a mock up, I've added a comment which I hope explains better what I'm trying to get.

Cheers.

[alansidman]

Use this macro to set the starting date:

Please Login or Register  to view this content.

change J2 to read = D2 +1 and then change O2 to read J2 +1, etc. This will give you a template you can use over and ove.r

[alex.ransome]

Thanks for the help!

I'm beginning to understand script and can 'read' what's going to happen. My problem is I don't where to paste the code, I can open editor but does it need to go in the workbook or Sheet1. I have put it in both places but the prompt doesn't come up.

I've added a button instead and the wife can at least press the button to call your date script.

Much thanks again.

[AkaTrouble]

hiya

am attaching a file i am currently working on for a similar problem

it is not a direct solution to your problem but might help with ideas

note all the VBA is unprotected so you can copy paste edit any of it

this version creates today and the next 6 days on opening the workbook

the master sheet is what is used as template for creating new

( and a lot of thanks from members here for getting me this far)

[alansidman]

@alex.ransome

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button