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!

Macro - Automated

Status
Not open for further replies.
MikeMcKeown

MikeMcKeown

Programmer
Apr 1, 2003
69
GB
I have created an macros in an adp project that does exactly what I would like it to do.

Replaces a current Excel file with the new information.

The problem is that this needs to be run each week and I would like some way of automating it.I have tried doing this all in SQL Server however you cannot delete the contents of the Excel file and replace it with the new details instead it just replaces it

Is there a way to do this? I tried a DTS package??
 
Status
Not open for further replies.

Similar threads

childrenfirst
  • Locked
  • Question
Macro to download the most current .adp to user's computer 1
Replies
14
Views
53
PWise
PWise
psimon88
  • Locked
  • Question
macro to import objects from another ADP file? 1
Replies
3
Views
39
mp9
mp9
famehrie
  • Locked
  • Question
To Macro or Not to Macro
Replies
1
Views
22
ZmrAbdulla
ZmrAbdulla
macroCharlie
  • Locked
  • Question
Access Project asks for User and Password when Converting Macros to VB
Replies
0
Views
18
macroCharlie
macroCharlie
kensaffer
  • Locked
  • Question
Macro Helpurgently needed on using Update SQL Command
Replies
0
Views
15
kensaffer
kensaffer

Part and Inventory Search

Sponsor

Back
Top