I’d like to know what I’m doing wrong with this VBA code, I want the data to refresh every 10 seconds. Any help please?
Dim Timer as Date Sub Refresh_Data()
Application. OnTime Timer, "Refresh_Data” ActiveWorkbook. RefreshAll
ActiveWorkbook. Save
End Sub

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

Check with ChatGPT

likefunny

The most common issue I had with my coding was when I created a variable for a name that was already taken

like

I’m not in front of a computer but I could swear there is an option within excel to do this without VBA

like

Thank you!

like

Agree, ChatGPT

like

What's the error?

like

No error… just doesn’t work

Where do you set or update the value of "Timer"? You defined it but didn't set its value. I would refresh and save first, then set the time to now+10 seconds, then schedule it to run again.

See the examples here: https://learn.microsoft.com/en-us/office/vba/api/excel.application.ontime

like

I did that on top of application on time… I guess I didn’t type that out😅

Related Posts

Hi,

Is connect week in Fidelity mandatory for employees ?

How much I can expect monthly take home salary. I pay rent 1LPA,1.5 LPA 80c. Any suggestions to minimize the tax deductions?

Post Photo
like

Is it only me who has shifted to Pune?😂
It's so boring to sit at home alone with office not starting soon.
If anyone who has shifted feels the same😂 let's meet🥂

like

Is Barclay's a good bank to work for? I'm looking for all feedback - the good, the bad, and the ugly

like

When you walk in Friday morning to a dumpster fire of a file (that you’ve never worked on before) sitting on your desk, with no note or email to go with it. It’s as if I’m supposed to magically divine what to do with it. 🤦🏼‍♀️

like

If you’re an attorney and someone asks how you are and you respond with: “Living the Dream”. Please stop.

likefunnyhelpful

I think BCC is the next coin coming to Coinbase

Londoners, I have a friend visiting me for Easter and am looking for ideas on where to take her besides the regular touristy stuff - pls help!
Plus, what’s the best theater show you’ve seen lately? Thank you 😊

like

Whether amount added on meal voucher through company can be transferred to bank account?

like

Does CGI send rejection mail?

Can those not picked in lottery earlier this year and whose status still reads submitted still expect a selection over the next 2 months in case those selected are denied approval?

like

My wife is worried about her job. She works as a vendor to wipro.her manager told her to send resume and docs to upload, they will transition her from vendor to wipro payroll. Her parent company is asking her to tell wipro not interested.she wants to get converted to wipro permanent payroll. Is there any NOC required from vendor?pls comment

like

Women- if your husband says he fantizes about xyz actresses and models- how would you feel?

likefunny
like

Curious how folks are governing/auditing their HRIS data. Wondering if this always done it manually.

like

Saw someone asking about high-rise apartments in Mott Haven earlier. Just moved into a new apartment building here and honestly it’s not as bad as I thought. New buildings are safe and pretty spacious (relatively speaking). Downside is not really much to do around this area and food delivery is not great. Hope this is helpful for any one who is looking at this area.

like

Is having a part-time weekend and weeknight gig frowned upon?

like

Can you sell your used shrm cp books from the learning system? If so where?

like

Hello fishes,

Sap basis is better for future or should I move to web development??

Pls share your views.

I have total experience of 3 years in sap Basis and I'm currently at 10.5 LPA.

Switching to web development is good decision???

like

Additional Posts in Excel Genius

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

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

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Anyone know what these badges are?

Post Photo
likefunny

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

like

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

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