Data web query + autosave macro

MikkoF

New Member
Joined
Sep 18, 2017
Messages
2
Hello everyone,

Firstly I'm using Excel 2013 and Windows 8.1 and... sorry for my English.

I have workbook for me and my friends sport betting game for fun. We choose only few match from single day.
So i have query to take data from website and another sheet with taking only my match, our tips, results beetwen us, etc. I want share it like live results so I set query refreshing to 1 min. The file is in my 24/7 working computer in the OneDrive sync folder. So I can share view with my friends in near situation to "real time".

Everything working good, but problem is with autosave. I have macro for this and doesn't matter i use time refresh or sheetchange, every time its crush because alert say something like - This operation (save) will stoped query refresh. And give me choose I want save or not. I tried using application.wait after Me.save, but not working as well.

Do you have any solution or tip for this?
My VBA code:
Private Sub Workbook_SheetChange(ByVal Sh As Object, _
ByVal Target As Range)
If Not Application.Intersect(Target, Range("F3:F20")) Is Nothing Then
Call SaveWorkbook
End If
End Sub

Public Sub SaveWorkbook()
Application.Wait (Now + TimeValue("00:00:15"))
Me.Save
End Sub

Regards, Michael
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Forum statistics

Threads
1,214,945
Messages
6,122,393
Members
449,081
Latest member
JAMES KECULAH

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top