Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Refreshing / sharing an Excel spreadsheet

I've written a standalone application to (via VBA) to make changes to
an existing Excel file. The app works but the Excel file must be
closed. After the app is run the file can be opened to see the
results. The Question: Is there a way to run my app against the Excel
file while its **open** then perform some kind of refresh to see the
changes?? I'd like to avoid the open/close cycle if at all
possible....

Any/all help would be much appreciated...
Thanks in advance.

Don-
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Refreshing Pivot Table on a protected spreadsheet tab EarlyBirdie Excel Discussion (Misc queries) 1 July 5th 09 07:31 AM
Partially refreshing spreadsheet Josh A Excel Worksheet Functions 0 February 6th 09 07:07 PM
Sharing access to an Excel spreadsheet? Victor Delta[_2_] Excel Discussion (Misc queries) 3 January 31st 09 04:43 PM
Sharing Excel Spreadsheet Sid Excel Discussion (Misc queries) 0 September 13th 07 01:54 AM
How can I maintain spreadsheet formating when refreshing import da Jason Excel Discussion (Misc queries) 0 July 8th 05 09:31 PM


All times are GMT +1. The time now is 12:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"