Programming, website development forum
DaniWeb Programming
and Web Development Community
Get latest updates by RSS
Loading
HomeRecent PostsRevenue SharingRegisterContact UsLogin

Username  
Password    
Forgot your password? | Register  
Welcome to TechnicalTalk.Net forum! It seems that you are not a member yet. To interact with other members and to post on the forum. Get a free account now
Earn money on this forum
Advertise with us...
+ TechnicalTalk » Programming and Web Development » Classic ASP 3.0 » Macro to Export data To a new Workbook in excel?
Quick Links:
Want to earn money on forum? visit --> Earn money on forum
Del.icio.us Digg FURL FaceBook Stumble Upon Reddit SlashDot Google Bookmarks Technorati Yahoo My Web 
Pages: [1]   Go Down
 
  Email this topic  |  Print
0 Members and 1 Guest are viewing this topic.

Macro to Export data To a new Workbook in excel?

 
webmaster forum
singam  Offline

Reputation Power: 2
singam has no influence.
 
Regular Coder
Posts: 50
Topics: 19
June 20, 2010, 09:36:38 PM
So i have a Database, the path to which is S:/database. xls. . . . . . and i have another excel sheet wherein i want to record a macro which exports the data from that "database. xls" sheet to another workbook so that people can view that data without opening the "database. xls". . . . . . .

i tried recording a macro which on pressing the command button ( or pressing the shortcut key for running macro) opens database. xls copies the data, open another workbook and then pastes the data and then closes the database. xls. . . . . . .

however when i do that the problem is that i get a question that do u want to copy a huge amount of data to the clopboard ETC. . . . . .
Proofreading | SEO Copywriting
« Last Edit: June 04, 2011, 10:43:19 AM by Admin »
 
webmaster forum

Reputation Power: 1
pavithra has no influence.
 
New Poster
Posts: 3
Topics: 0
August 06, 2010, 04:47:39 AM
I have VBA code in Excel that imports an access query into Excel, performs some calculations on it, sorts it, groups it and adds subtotals.  Is there a way to export this new data into a new excel file, without including all the code and command buttons? I need to send it to customers.  Any help is greatly appreciated.
« Last Edit: June 04, 2011, 10:43:40 AM by Admin »
 
webmaster forum
dianna  Offline

Reputation Power: 2
dianna has no influence.
 
Regular Coder
Posts: 88
Topics: 10
 WWW
August 10, 2011, 01:31:23 AM
Hi been looking around a bit and could not really find a good solution to, with VBA, export two worksheets from a workbook into a new workbook and save it in a predefined directory.
Pakistan's Local Search engine
 
  Email this topic  |  Print
Pages: [1]   Go Up

 
Jump to:  



Home | Advertise | Forum Help | Privacy Policy | Contact us
Powered by SMF 1.1.16 | SMF © 2011, Simple Machines


Google visited last this page May 09, 2012, 12:58:08 PM