Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Has anyone tried to do anything like this? Part 1: I want to programmatically upload a formatted range on a worksheet (which may have some formulas) to a database as XML. Part 2: I then want to download same into another worksheet/workbook programmatically so that the formats and formulas are pasted exactly as uploaded in Part 1. I already do this for data with ADO and VBA/SQL easily with CopyToRecordset or looping round the rs. I'm looking for some high- level ideas on the range of possibilities for a range 'intact'. Any code samples out there pls? Thanks, Hiran |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I found a good place to start in Julitta Korol "Excel 2003 VBA
Programming with XML and ASP" Chap 25. I'd still like to find anyone who has already made this journey in some way. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Import New Database Query (Union Query) in Spreadsheet | Excel Discussion (Misc queries) | |||
Database import | Excel Programming | |||
Import from Excel into database using jet in VB.net | Excel Discussion (Misc queries) | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
Import of Database VB app into Excel Spreadsheet | Excel Programming |