Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Joining SQL Server Stored Procedure to SQL Server Table | Excel Programming | |||
Excel spreadsheet still pointing to old server after server move | Excel Programming | |||
can not locate the internet server or proxy server | Excel Programming | |||
Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
problem updating link from Novell server to windows server #REF er | Excel Discussion (Misc queries) |