SQL Server
Hiya,
We had some templates in Word built before my time, which use Bookmarks to match fields in a SQL Database. Does Excel has such 'bookmark' functionality or an equivalent, as I was hoping to copy the code into an Excel template for Invoices. If not, I have tried embedding an Excel object into an existing Word template, but the only problem is the object doesn't span across multiple pages; once it becomes to big, the whole thing jumps onto a new page. Can this be stopped? Thanks |
SQL Server
Excel doesn't have book marks but youo could embed the word document into an
excel worksheet. Then use the workbook as a templete to get your data. Use ACTIVATE to open the embedded word document. Now Excel could be the SQL database. Really the structure of an Excel Workbook and an Access table is identical. it is just the default application that is run. Your database open statement can either point to a MDB file or a XLS file. An Excel worksheet is an Access Table. A cell in a worksheet is a cell in an access table. The Head row in an excel worksheet is the table headings in access. "Andy Smith" wrote: Hiya, We had some templates in Word built before my time, which use Bookmarks to match fields in a SQL Database. Does Excel has such 'bookmark' functionality or an equivalent, as I was hoping to copy the code into an Excel template for Invoices. If not, I have tried embedding an Excel object into an existing Word template, but the only problem is the object doesn't span across multiple pages; once it becomes to big, the whole thing jumps onto a new page. Can this be stopped? Thanks |
All times are GMT +1. The time now is 07:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com