ClipboardFusion RSS: How to make a Macro paste a pinned item

RE: How to make a Macro paste a pinned item

Binary Fortress Software — Wed, 25 Sep 2019 13:59:20 GMT

I was able to put something together that should work for you. I've modified Keith's code a little to check for the weekend after each day, so the Macro should work if you run it on a weekend, or if the time you want to add spans for more than one week.

I hope this works for you!

Code
Copy
Select All

using System;
using System.Collections.Generic;

public static class ClipboardFusionHelper
{
    public static string ProcessText(string text)
    {
        // Set the days to add and get the current date/time
        int daysToAdd = 7;
        
        // Get the date
        DateTime date = DateTime.Now;
        
        // Fix the date in case it's a weekend
        if (date.DayOfWeek == DayOfWeek.Saturday)
            date = date.AddDays(2);
        else if (date.DayOfWeek == DayOfWeek.Sunday)
            date = date.AddDays(1);
        
        // Add the days one at a time, and check for a weekend after each time
        for(int i = 0; i < daysToAdd; i++)
        {
            // Add one day
            date = date.AddDays(1);
        
            // Check if the new date is a Saturday or Sunday, if so, add some more days
            if (date.DayOfWeek == DayOfWeek.Saturday)
                date = date.AddDays(2);
            else if (date.DayOfWeek == DayOfWeek.Sunday)
                date = date.AddDays(1);
        }
        
        // Convert the date/time to text
        text = date.ToString("dd.MM.yyyy hh.mm.ss");
        
        // Paste and return the text to the clipboard
        BFS.Clipboard.PasteText(text);
        return text;
    }
}

RE: How to make a Macro paste a pinned item

Binary Fortress Software — Fri, 15 Mar 2019 13:44:51 GMT

Since it's friday, I've had a chance to try out your code, and I realized a limitation.
If I want to add 3 working days, it only adds 3 days, and sets monday, instead of seeing that its been a weekend, and adding another 2 days.

RE: How to make a Macro paste a pinned item

Binary Fortress Software — Tue, 12 Mar 2019 09:44:56 GMT

Maybe not, but it looks like it should work for me. Thanks a bunch.

RE: How to make a Macro paste a pinned item

Binary Fortress Software — Mon, 11 Mar 2019 18:56:17 GMT

I'm not sure if this is the best way to do it, but it should work

Code
Copy
Select All

using System;
using System.Collections.Generic;

public static class ClipboardFusionHelper
{
    public static string ProcessText(string text)
    {
        // Set the days to add and get the current date/time
        int daysToAdd = 7;
        DateTime currentDateTime = DateTime.Now;
        
        // Set the potential new date/time
        DateTime newDate = currentDateTime.AddDays(daysToAdd);
        
        // Check if the new date is a Saturday or Sunday, if so, add some more days
        if (newDate.DayOfWeek == DayOfWeek.Saturday)
            newDate = newDate.AddDays(2);
        else if (newDate.DayOfWeek == DayOfWeek.Sunday)
            newDate = newDate.AddDays(1);
        
        // Convert the date/time to text
        text = newDate.ToString("dd.MM.yyyy hh.mm.ss");
        
        // Paste and return the text to the clipboard
        BFS.Clipboard.PasteText(text);
        return text;
    }
}

RE: How to make a Macro paste a pinned item

Binary Fortress Software — Fri, 08 Mar 2019 09:19:50 GMT

Thanks again. This has been very helpfull. I want to make it skip weekends. Possibly holidays, I see some commands on stack overflow for AddBusinessDays, but that doesnt follow the syntax in use here. Is there a way to do it in the code you already made for me?

RE: How to make a Macro paste a pinned item

Binary Fortress Software — Thu, 17 Jan 2019 19:16:14 GMT

No worries, glad we could help!

RE: How to make a Macro paste a pinned item

Binary Fortress Software — Thu, 17 Jan 2019 09:34:44 GMT

Nice. This works. Thank you for your help.

RE: How to make a Macro paste a pinned item

Binary Fortress Software — Wed, 16 Jan 2019 19:57:15 GMT

Ok, try this out:

Code
Copy
Select All

using System;
using System.Collections.Generic;

public static class ClipboardFusionHelper
{
    public static string ProcessText(string text)
    {
        int daysToAdd = 4;
        DateTime currentDateTime = DateTime.Now;
        
        text = currentDateTime.AddDays(daysToAdd).ToString("dd.MM.yyyy hh.mm.ss");
        BFS.Clipboard.PasteText(text);
        return text;
    }
}

RE: How to make a Macro paste a pinned item

Binary Fortress Software — Wed, 16 Jan 2019 19:31:33 GMT

dd.mm.yy and if possible hh:mm:ss but not essential.

RE: How to make a Macro paste a pinned item

Binary Fortress Software — Wed, 16 Jan 2019 19:25:14 GMT

To get the pinned text in the first slot you need to use index 0, and you have to call BFS.Clipboard.SetText, like so:

BFS.Clipboard.SetText(BFS.ClipboardFusion.GetLocalPinnedText(0));

You can get the date in a macro as well. What format do you need the date to be in?

How to make a Macro paste a pinned item

Binary Fortress Software — Wed, 16 Jan 2019 09:41:04 GMT

I am in the process of setting up macros that navigate between text boxes.
Most of them I can use the BFS.Clipboard.PasteText for, but I have 1 field that changes, and it's a date/time field.
So I decided to set up a pinned item in the #1 slot, with the date and time I want to use every time the macro is run.
So if the date changes, I just change the pinned item, not the macro.

I assumed I could use one of the BFS.ClipboardFusion statements to do this, but if I use BFS.ClipboardFusion.GetLocalPinnedText(1); my current clipboard item is not updated. When I try to paste, it just pastes what ever I had copied before I ran the macro.

How can I make this work?

Alternatively, is there a way where I can just get the date, and set it to say 4 days from now, and paste that?

ClipboardFusion RSS: How to make a Macro paste a pinned item

RE: How to make a Macro paste a pinned item

CodeCopySelect All

RE: How to make a Macro paste a pinned item

RE: How to make a Macro paste a pinned item

RE: How to make a Macro paste a pinned item

CodeCopySelect All

RE: How to make a Macro paste a pinned item

RE: How to make a Macro paste a pinned item

RE: How to make a Macro paste a pinned item

RE: How to make a Macro paste a pinned item

CodeCopySelect All

RE: How to make a Macro paste a pinned item

RE: How to make a Macro paste a pinned item

How to make a Macro paste a pinned item

Code
Copy
Select All

Code
Copy
Select All

Code
Copy
Select All