Solved

Auto. refresh the sheet

Posted on 2015-01-07
8
78 Views
Last Modified: 2015-02-07
Hi,
I have the relevant connection and script (shown as attached) to refresh the Excel sheet, using the data from Sql server. Is there any other auto. way to do the refresh, using VBA codes?
0
Comment
Question by:HuaMinChen
  • 4
  • 2
8 Comments
 
LVL 10

Author Comment

by:HuaMinChen
ID: 40537266
Here is the attached file.
t926.png
0
 
LVL 3

Accepted Solution

by:
Bahloul earned 500 total points
ID: 40537514
you can use Microsoft task scheduler from run > taskschd.msc

that will gives you automatic schedule to run VB script or specific app just create basic task it's straight forward to finalize it .

Bahloul.
0
 
LVL 10

Author Comment

by:HuaMinChen
ID: 40537547
Can I have more details to the way you suggested? Thanks.
0
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 
LVL 3

Expert Comment

by:Bahloul
ID: 40537573
0
 
LVL 10

Author Comment

by:HuaMinChen
ID: 40539359
But I mean the way to use VBA codes, to auto refresh the relevant script, originally shown to this thread.
0
 
LVL 10

Author Comment

by:HuaMinChen
ID: 40539460
But I mean the way to use VBA codes, to auto run the relevant script, originally shown to this thread.
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 40595437
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
vb6, excel Run-time error 1004 method 'close' of object 'workbooks' failed 7 50
TT Auto Dashboard 13 92
Added a column screws up code 5 57
Allow space in this pattern 2 58
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question