Forum

Sherry Fox
@webbers
Estimable Member
Joined: Dec 4, 2021
Last seen: Jan 25, 2025
Topics: 51 / Replies: 96
Topic
Forum
Replies: 1
Views: 295
Reply
RE: Upgrade VBA code to remove all " - Copy." files to clean up the computer

@Philip Treacy, Thanks so much, that was a great solution. I never thought of using the command prompt. All my duplicates are gone (about 15K fil...

5 months ago
Forum
Reply
RE: Dynamic Formula needs 2nd Criteria

@Riny, Thanks so much for your help!

10 months ago
Reply
RE: Dynamic Formula needs 2nd Criteria

@Riny van Eekelen, That works great. But now my boss wants it to be sorted by a field. Let's say the field is tbl_UPDATED[Project Number] ? How ...

10 months ago
Topic
Reply
RE: Save Version to Save Next Consecutive Number

I have beren working on this and I came up with a solution. I also factored in multiple file extension types and the 3-digit format which is my prefe...

10 months ago
Forum
Topic
Forum
Replies: 1
Views: 163
Reply
RE: Save As XLSX and Disable Query Refresh

@Hans Hallebeek, I just got this to work making some modifications on my own. I thought I would share my final code with you and anyone else on th...

11 months ago
Forum
Reply
RE: Save As XLSX and Disable Query Refresh

It kicked out with this error, and I circled the portion of the code that was highlighted since there was no traditional debugging.

11 months ago
Forum
Topic
Forum
Replies: 4
Views: 105
Reply
RE: VBA to generate dynamic spilled formulas including XLOOKUP w/multiple criteria

@Hans Hallebeek, I only have until Friday at my current company. I have been attempting to finish up as much as possible prior to the end of my co...

12 months ago
Forum
Reply
RE: VBA to generate dynamic spilled formulas including XLOOKUP w/multiple criteria

@Hans Hallebeek, I understand what you mean. I have seen the path that is connected to the template. I was just hoping there is some way around t...

12 months ago
Forum
Reply
RE: VBA to generate dynamic spilled formulas including XLOOKUP w/multiple criteria

@Velouria, I am doing this the way I could information to do it. I am only intermediate at best as far as VBA goes. And this one, is way more com...

1 year ago
Forum
Reply
RE: VBA to generate dynamic spilled formulas including XLOOKUP w/multiple criteria

@Hans Hallebeek, Yes, This macro would run from my Personal workbook. That is why the code was not in the sample file I supplied but was in my pos...

1 year ago
Forum
Page 1 / 10