Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating formatted Excel File from a Query Output

Status
Not open for further replies.
CSHANKY

CSHANKY

IS-IT--Management
Jun 4, 2003
20
US
I have a Access query (query1) that I export to an Excel file (excel1.xls). I run a macro (macro1) that formats my excel1 file the way I want it. [This part is all done]

I would like automate this whole sequence of running query1 , opening the file excel1 and running macro1, through "click of a button" on an Access form (form1).

Would a kind soul please provide me the step-by-step guide on how to do it ?

Please note my programming skills are next to nothing - but I can generally follow instructions. :)
 
Status
Not open for further replies.

Similar threads

OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
675
OCM
OCM
Moss100
  • Locked
  • Question
Upgrading from Access 2013 - whats the best option
Replies
2
Views
540
Moss100
Moss100
lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
577
lmcate
lmcate
TheresAlwaysAWay
  • Locked
  • Question
Searching for a way to get Access to retrieve and use data from a hard drive file not within Access 3
Replies
13
Views
248
TheresAlwaysAWay
TheresAlwaysAWay
TheresAlwaysAWay
  • Locked
  • Question
Convert PDF to Excel spreadsheet within Access 2
Replies
10
Views
356
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top