By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,455 Members | 2,293 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,455 IT Pros & Developers. It's quick & easy.

TransferSpreadsheet

P: n/a
Is there a way, when exporting a query to Spreadsheet, to export a
formula with it (other than as text) so that a user can further
manipulate data?

Or

Is there a way to trim the "'" from the beginning of the formula after
the export is complete? My intention is to make this as Idiot Proof
as possible. I don't want the End user to even have to think about
it.

Thanks
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
exporting is easy, you can use a macro 'output to'
or visual basic docmd.output .... or something along those lines, just have
a look in the help.

a way to trim the ' character would be to

right([string], len([string])-1)


---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.683 / Virus Database: 445 - Release Date: 12/05/2004
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.