Programming Help

Web Development



What's Here?

  • Members: 136,278
  • Replies: 478,654
  • Topics: 74,563
  • Snippets: 2,566
  • Tutorials: 675
  • Total Online: 2,265
  • Members: 98
  • Guests: 2,167

Welcome to Dream.In.Code
Getting VB.NET Help is Easy!

Join 136,278 VB.NET Programmers for FREE! Get instant access to thousands of VB.NET experts, tutorials, code snippets, and more! There are 2,265 people online right now. Registration is fast and FREE... Join Now!




Update/refresh worksheet in excel using VB2005

 
 Reply to this topicStart new topic

Update/refresh worksheet in excel using VB2005
bellaelysium
13 Oct, 2008 - 10:03 PM
Post #1

New D.I.C Head
*

Joined: 8 Jun, 2008
Posts: 32
Is there a way where I can update/refresh all active sheets in the workbook or active workbook without having to open up new workbook all over again once the data is updated or something using VB 2005?


Here's an idea of what I am planning:

For e.g, there are 4 data series in a chart(in excel) and the user will tick in listbox items (in VB user interface) which data series they want to view.

After that, they will click the "ok" button and the whole workbook will refreshed (i have several chart sheets in one workbook), enable the user to see which data series they want to view.

This will happen continously until the user close the VB application.


The excel workbook is exceuted externally.
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 12/2/08 05:20AM
Invision Power Board v2.1.7 © 2008  IPS, Inc.
Licensed to: MediaGroup1

Live VB.NET Help!

VB.NET Tutorials

Reference Sheets

VB.NET Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month