Record a macro in Excel and then use that to automate your update. John Harvey
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vince Teachout Sent: Monday, September 24, 2007 9:18 AM To: ProFox Email List Subject: Re: VFP9: Excel Automation - Still Here Desmond Lloyd wrote: > Still breathing: > Hey, > > Got a rather large list of Excel files that need to have the print headers updated. Any automation gurus out there that can point me in the general direction of updating these? > > Many TIA, > Desmond You'll have to be a bit more specific. Are you talking about something like "replace cell B1 with "TESTING123"' in all spreadsheets, or setting the worksheet header value, or what? [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@shelbynet.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
