For a experienced user of ACCESS (not necesary a programer), requiere only a little procedure written in visual basic and triggered by any action and/or button
You can write a letter in Excel, but not a book because it`s not a word processor.
Why try to manage resources stored in same kind of database whit Excel if you have Access or any other software?
Regards
Every time that you digit or paste a field that include the right slash ("/") in a a cell, you have problems whit a intrinsic tendency of EXEL to assume it is a date.
Few month ago, was publishied a smart trick that suggested digit SPACE as first entry.It works!
IRstuff
Obviusly, search had be done extensively in HD. Refer your appreciate answer about path "C:\Documents and Settings\YourUserName\Application Data\Microsoft\Excel\XLSTART" the last 4 subrirectories do not exist (\Application Data\Microsoft\Excel\XLSTART).
The fact is new...
I migrate from Windows 98 to Windows 2000. I save my personal.xls with all macros but I could not find where must be located in Windows (the old Excel -> Start).
I generate a new personal.xls that works, but is imposible find it on directory. Any suggestions?
Thanks in advance
You need a program called "DISTILLER" included in ADOBE ACROBAT.
It works exactly as a new printer wich is instaled in your PC. By sending your draw, from AUTOCAD, to this new printer, it would generate not a plot, but a file PDF with the name you assign. This file could be open with...
HARD WAY
Make a pivot table from the query, source of your report
EASY WAY
From inside your report (in ACCESS), select TOOLS, analize with WORD, from WORD select "select all", "Copy" and Close.
Open EXCEL and "Paste".
With minimun format you can arrange all that stuff
