I have to do a lot of copying and pasting from Excel into PowerPoint. It's sort of like grown-up arts and crafts time at work.
I'm trying to write macros to do much of that work for me, but without a Record Macro function in PowerPoint, it's a challenge for me, as I'm not a programmer.
In Excel, I use a formula to determine my current fiscal week, which is ="Fiscal Week "&weeknum(today())-5. In PowerPoint, I have a text object that has the right formatting and the right size and position, named "FWQ" that the result of my Excel formula should replace.
Is there a way to take the formula result (in Cell C1 in Excel, for instance) and edit a text object in PowerPoint to match?
Thanks for any suggestions or help you can offer!
I'm trying to write macros to do much of that work for me, but without a Record Macro function in PowerPoint, it's a challenge for me, as I'm not a programmer.
In Excel, I use a formula to determine my current fiscal week, which is ="Fiscal Week "&weeknum(today())-5. In PowerPoint, I have a text object that has the right formatting and the right size and position, named "FWQ" that the result of my Excel formula should replace.
Is there a way to take the formula result (in Cell C1 in Excel, for instance) and edit a text object in PowerPoint to match?
Thanks for any suggestions or help you can offer!
