save to excel file

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: majikman (majikman.166jeg_at_excelforum-nospam.com)
Date: 05/13/04 

Date: Thu, 13 May 2004 00:38:42 -0500

i have a workbook that i'm working on and when hits the BeforeSave
event, i'd like to have specific cells of the file saved to another
excel file located on a server. i would like to be able to do this
without opening the file on the server because the file is quite large
and it would be rather slow for the user to save if the user has to
open the remote excel file each time just to save. i'm told i can do
this with odbc or ado but i'm not sure exactly how that works. i've
seen some documentation for vb and for accessing ms access files but i
don't know about excel files. can someone please point me to some
documentation or give me a sample? thanks. 

---
Message posted from http://www.ExcelForum.com/

Relevant Pages

  • RE: TransferSpreadsheet - how to get it to overwrite
    ... I don't know what documentation you read that says it replaces the existing ... TransferSpreadsheet into the Access table from the Excel file. ... > However the app sometimes uses a bound data grid to display data from ...
    (microsoft.public.access.externaldata)
  • Re: Using Visual Basic 6.0 to manipulate data in Excel files
    ... "API" is typically used when requesting information on accessing the Windows ... documentation on their Visual Basic 6 API to access/manipulate/etc Excel ... macros in Excel so that I can press a button in one Excel file "a.xls", ... Dim mXLApp as Excel.Application ...
    (microsoft.public.vb.general.discussion)
  • xlrd and cPickle.dump
    ... I have to work with a very large excel file and I have two questions. ... the documentation says that cPickle.dump would be the best way ... to create the pickle file, ... dictionary would be the best way to sort out the repeats ...
    (comp.lang.python)
  • Importing excel file
    ... I want to be able to read an Excel file into my application. ... want to display it in a view, I just want to be able to read the ... with automation, but that's all very confusion, and I can find no ... documentation at all on it. ...
    (microsoft.public.vc.mfc)
  • Re: Problem importing excel data
    ... I assume you're importing to an existing table. ... So Columns A to I and Rows 1 to 110 are being used for the report. ... have cells with text for the questions and cells that are blank for the ... name) of an Excel file: ...
    (microsoft.public.access.externaldata)