-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
weekly report
-
C
VBA that references the most recent file in a folder
I am fairly new at VBA and am attempting to write a macro that references the most recent weekly report in a folder. My current code looks like this... Workbooks.Open Filename:="S:\SherwinWilliams\Oracle Reports\6-13-2018.xlsx" Windows("6-13-2018.xlsx").Activate It works fine, however...- Captain_Conman
- Thread
- dates file reference report vba weekly report
- Replies: 1
- Forum: Excel Questions
-
P
Outlook code works, but really slow. How to make it faster?
Hello everyone :) The code I`m using at the moment works and I get the needed data. BUT, unfortunately, the code is really slow... I use the macro to select a folder in Outlook and then extract all email information (name, sender, reviser and so on.), based on a week. So basically, a weekly...- pupsia
- Thread
- email macro outlook stats weekly report
- Replies: 4
- Forum: Excel Questions
-
S
Automatically create a copy every week
Hello everyone, I have a main worksheet. It contains data in columns A to E. The data changes/(is updated) every day. What i wish to do is, I want to create a new worksheet every week, name it by the date,.. This worksheet will contain data only from two columns A and E of the main worksheet...- seepra
- Thread
- auto - generate copies copy every week weekly report
- Replies: 6
- Forum: Excel Questions
