Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Import XML spreadsheet from database with VBA

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Import XML spreadsheet from database with VBA

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import New Database Query (Union Query) in Spreadsheet klock Excel Discussion (Misc queries) 2 September 24th 09 01:30 AM
Database import [email protected] Excel Programming 3 February 28th 08 07:40 PM
Import from Excel into database using jet in VB.net Andy HP Excel Discussion (Misc queries) 0 February 7th 08 08:33 AM
database query not showing foxpro database How I import data mangat New Users to Excel 1 June 24th 07 03:31 PM
Import of Database VB app into Excel Spreadsheet No Name Excel Programming 0 February 19th 04 06:23 PM


All times are GMT +1. The time now is 08:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"