Anybody know if you can access an older version of an excel file (like from version history) using vba?

Trying to write a script to compare old versions and list changes since a given date

like
Posting as :
works at
You are currently posting as works at

Related Posts

Hi all,

I have 2 offers..

Pwc AC- senior analyst guidewire- 22l fixed
S&P global market intelligence- senior product manager- 23-24 l fixed

What is a better opportunity wrt growth, brand, role etc?

Please help !

like

Holding an offer of 20.5LPA. Now selected for C1 band at Capegemini. How much should I ask?
YoE 6.10, Tech Stack AWS DevOps, CCTC 10.5 LPA
Capgemini

like

Hi Folks,

Looking to enroll my kid for Gymnastic classes near Balewadi. She is 5 years old.
Does anyone know of any good coaches and academy nearby Balewadi stadium?

like

I currently do insurance defense but have been wanting to do more meaningful work, especially for the cause of helping other minorities. I have an offer from an employment discrimination firm that I’m considering taking. Anyone here do employment discrimination? If so, are you fulfilled by your work?

like

I am currently working in advertising with experience on fintech & CPG. I would like to work in tech marketing, specifically Google’s APMM program.
I’ve been studying some PM/PMM books/podcasts/videos, attending Google events, and want to keep learning more to try to prepare myself as much as I can.
What resources helped you get into product marketing/Google?
Has anyone here moved from advertising to tech?
Would love to hear from a marketer about their experience getting into Google.
Thank you

like

Litecoin up 40% today 👀

like

Has anyone have an experience they want to share in using a paid resume service to boost an opportunity they were able to get?

I had just 3 rounds completed and my last round was with all the team members. Can we expect more rounds moving forward? Or this was the final?
How much we can expect for Manager with 11.6 YOE

like

How is the salesforce practice at EY GDS?
Please specify about the future growth opportunities, yearly increments, etc

like

When recruiters send job descriptions via email or LinkedIn, what stops the candidate from looking up the clients themselves and applying directly and using the lack of commission as a bargining chip?

like

Damn was hoping this was a bowl for automotive consulting 😆

like

Lol went to dinner at the inlaws. We recently got engaged after dating for over a decade. FIL waited until my SO and MIL were out of the room and said, "I have no idea why you two finally decided to do this, but for MILs sake, thank you"
I didn't realize we were still causing stress, but that was a very sweet moment.

likefunny

If IBM nominates for H1B, how long does it take to know the status?

like

Anyone know of a good place to print quality brochures without having to put a second on your house to buy them?

like

Curious to know - what was your undergrad degree in?

like

Looking into moving to Amsterdam soon (yayy!) and I was trying to understand what the average salary in our industry is / cost of life in the city?
Mid-weight 4yo planner here.

like

Please tell me the truth

Post Photo
likefunny

Any recommendations for you pick farms?

like

Hi, I need help from you travel gurus if possible.

I'm landing in Arlanda / Stockholm at 720am and hoping to catch the 810am flight from Stockholm to Amsterdam. Is this enough time to make the flight?

They're separate tickets that I'm buying, although the airline is the same (Scandinavian Airlines) so should be the same terminal. Also flying business and won't be checking luggage.

Thanks!!

like

Any single ladies interested to hang out this weekend?

like

Additional Posts in Excel Genius

Had an interesting issue this past week. Batch of client data looked normal in Excel, but when imported into our analysis software that we use for larger data sets and their manipulation (cont.)

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

Help! Excel won’t let me navigate using my keys anymore, arrow keys and enter will not move me to the next box. This is happening on multiple docs. Please explain how to fix this as if you’re talking to someone who is excel dumb (because you are).

like

Best way to learn Spotfire? Just watch YouTube videos?

I’ve got some lookups to do but inconsistent unique identifiers (names with Bob G01 vs Bob G1). More experienced fish, what’s the best way to perform look ups with this kind of unclean data? Got a few

like

Is there an easy way to convert a manipulated pivot table to a normal table but automatically retain all the subtotal formula and grouping? For example, I have a pivot table with 3row fields (country, region, customer) And a 1 column field by month. I want to make a presentation to show top 5 customer by country and region….and group rest as “all other”….thanks’!!🙏

like

Does anyone have experience setting up automated queries on Excel for Mac? I am trying to automate a paid search pacing document but am running into an issue with the Excel Power Query not being able to log in to Search Ads 360.

like

I’ve toggled the “Show Formula” setting and it changes nothing. File format is xlsx, so that shouldn’t be the issue. Any ideas why these are showing the formula instead of the output?

Post Photo
like

Mac iWork Numbers question: is there a GPS co-ordinates function? Looking to pull location information & calculate distances between locations in the sheet.

like

Public schools use Google for everything. So they use Microsoft Office as little as possible. Even Office 365 isn’t used much. I teach an exploratory class to 8th graders for Google docs and sheets since the school tech doesn’t support the educational MS Office 365. I like the MS Office desktop version because it does so much more than 365. I relate how Google does things similar to MS Office but not to the level that Office does.
Do businesses use Google docs, sheets, & the rest for anything?

like

When you F2 a cell to display cell references. Is there a way to navigate to that cell reference quickly without having to scroll and find the highlighted reference cell?

Thank you

like

How does an interest bearing equity instrument affect the equity value? For example, If the coupon on the equity instrument is say 16% and the Equity IRR of the project funded with this equity is 15% and I were to discount the FCFE at 12%, should this give me a negative value?

like

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

like

Anyone have a easy formula to turn “2 years 6 months” into 2.5? Thanks!

Hello,
How do I randomly pick one name from a list in excel that has identical names?
Example:
Warehouses names
Ana
Ana
Hou
Hou
Aus
Aus

Every name repeats itself several times. But each of them has different lot numbers associated with them. I only need to pick one lot number number from each warehouse randomly. Is there a formula for that in excel?

like

I’m 26 y/o and working as a sales coordinator (basically an assistant) for 5 national account managers in the investment banking industry. I have a BS in Finance and am series SIE, 7 and 63 licensed. I’m only making $50k a year (before taxes). There are a lot of aspects I enjoy about my job but the pay is not cutting it. Recently, I have found a passion for working with data in excel and I want to try to make a career pivot into business analytics but not sure where to start. Advice?

like

This isn’t exactly an excel question, but is there a way to clear the “last modified by” history on an excel document in SharePoint? Accidentally opened a file i shouldn’t have.

likefunny

Can anyone recommend a specific video on pivot tables?

like

If I’m creating a comp set and a row of numbers will not adjust the number of decimals no matter how many times I adjust it in the “format cells” window, what could be the reason for this and how can I get around it

like

Is there a trick to analyzing more than 1MM rows in excel?

likefunny

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal