?
Solved

Auto. refresh the sheet

Posted on 2015-01-07
8
Medium Priority
?
95 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
7 Comments
 
LVL 11

Author Comment

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

Accepted Solution

by:
Bahloul earned 2000 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 11

Author Comment

by:HuaMinChen
ID: 40537547
Can I have more details to the way you suggested? Thanks.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
LVL 3

Expert Comment

by:Bahloul
ID: 40537573
0
 
LVL 11

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 11

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 53

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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

The password reset disk is often mentioned as the best solution to deal with the lost Windows password problem. In Windows 2008, 7, Vista and XP, a password reset disk can be easily created. But besides Windows 7/Vista/XP, Windows Server 2008 and ot…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

589 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