Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default Popluating data from ms access

Hello all,

I was wondering if anyone can give me a hand. I just created a button
that has code within it to open a new work book and rename some tabs.
The next thing i need to do is some how be able to popluated the excel
sheets with data from MS access queries into the correct tabs in
excel. Can someone guide me in the right direction in vba ? thanks
in advance.

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Popluating data from ms access

Hi

Check out
http://www.rondebruin.nl/accessexcel.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message ups.com...
Hello all,

I was wondering if anyone can give me a hand. I just created a button
that has code within it to open a new work book and rename some tabs.
The next thing i need to do is some how be able to popluated the excel
sheets with data from MS access queries into the correct tabs in
excel. Can someone guide me in the right direction in vba ? thanks
in advance.

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Popluating data from ms access


Uzytkownik napisal w wiadomosci
ups.com...
Hello all,

I was wondering if anyone can give me a hand. I just created a button
that has code within it to open a new work book and rename some tabs.
The next thing i need to do is some how be able to popluated the excel
sheets with data from MS access queries into the correct tabs in
excel. Can someone guide me in the right direction in vba ? thanks
in advance.


F1(CopyFromRecordset)


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
How do I access the access data via Excel 2002 with auto update ? karthik Excel Programming 1 February 9th 07 01:56 PM
popluating a list box without having duplicates [email protected][_2_] Excel Programming 1 January 10th 07 07:58 PM
Importing data from Access to Excel, but I need to vary the table from Access Liz L. Excel Programming 3 June 6th 06 02:12 AM
Calculate data from Access and return to Access Mary Fran Excel Programming 0 January 17th 06 02:10 PM
Access data -work in Excel- save in Access s_u_resh Excel Programming 1 October 25th 04 12:52 PM


All times are GMT +1. The time now is 03:37 PM.

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

About Us

"It's about Microsoft Excel"