Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 12th, 2004, 09:01 AM
Registered User
 
Join Date: Dec 2004
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default External db files to Excel, via VBA automation ??

Hi. I'm currently doing a project on simulation using ProModel and i need to export the data files which are in (*.idb) format to Excel spreadsheets. The classical method is the normal "cut and paste", however i'm required to automate this export procedure using VBA. Are there any specific codes that is able to export the (*idb) format( or any other external database formats) to Excel by using VBA?

Really hope someone can help me in this.

Regards.

 
Old December 13th, 2004, 04:56 AM
Authorized User
 
Join Date: Aug 2004
Posts: 54
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Open up the .idb file in Notepad to see if it is actually in a format that Excel can recognise. Otherwise most applications will export to a more common format such as .txt/.csv/.dbf etc.


-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows run faster.
It is easy until you know how.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Object Definitions in External Db pjm Access VBA 3 December 20th, 2007 04:24 PM
Querying external Excel datafile from excel utalwalk Excel VBA 1 March 30th, 2006 12:47 PM
(Access/VBA) E-Mail Automation Format MAB2005 Access VBA 9 August 3rd, 2005 08:34 AM
VBA programming of "Get External Data" John Hollingsworth Excel VBA 2 August 2nd, 2005 10:02 PM
how to Insert data into external db method Access VBA 5 May 4th, 2005 10:59 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.