Zeitpunkt Nutzer Delta Tröts TNR Titel Version maxTL Do 11.07.2024 00:00:08 230.247 +96 16.986.698 73,8 Mastodon π 4.3.0... 500 Mi 10.07.2024 00:00:15 230.151 +117 16.972.485 73,7 Mastodon π 4.3.0... 500 Di 09.07.2024 00:01:07 230.034 +122 16.958.186 73,7 Mastodon π 4.3.0... 500 Mo 08.07.2024 00:00:26 229.912 +78 16.944.690 73,7 Mastodon π 4.3.0... 500 So 07.07.2024 00:01:05 229.834 +87 16.931.802 73,7 Mastodon π 4.3.0... 500 Sa 06.07.2024 00:01:05 229.747 +84 16.926.091 73,7 Mastodon π 4.3.0... 500 Fr 05.07.2024 00:00:51 229.663 +114 16.916.454 73,7 Mastodon π 4.3.0... 500 Do 04.07.2024 00:00:49 229.549 +1 16.902.639 73,6 Mastodon π 4.3.0... 500 Mi 03.07.2024 00:00:06 229.548 -5 16.887.661 73,6 Mastodon π 4.3.0... 500 Di 02.07.2024 00:01:44 229.553 0 16.872.533 73,5 Mastodon π 4.3.0... 500
Steven P. Sanderson II, MPH (@stevensanderson) · 11/2022 · Tröts: 786 · Folger: 317
Do 11.07.2024 04:31
π **Unlocking VBA from R!** π
Use the `FileDateTime` function in VBA to get a file's last modified date, executed directly from R! Here's how:
VBA in Excel: Create a macro to fetch the file modification date.
R Setup: Utilize the `RDCOMClient` package to interact with Excel.
Run VBA from R: Open the workbook, execute the macro, and retrieve the resultsβall from R!
#RStats #VBA #DataScience #Automation
Post: https://www.spsanderson.com/steveondata/posts/2024-07-10/
[Öffentlich] Antw.: 0 Wtrl.: 0 Fav.: 0 · via Web