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!

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

Need Help With Macro Button in Excel 2007

Status
Not open for further replies.

lrdave36

Technical User
Jan 6, 2010
77
US
Hey guys,


I'm trying to design an auto-import for an employee which will automatically import Access table data directly into Excel.

The easiest way I found is to record myself manually doing the import and save it as a macro. Then create a command button that will launch the macro.

I was able to do this with my initial testing, but they need to run this import process each month so how can I repeat the process on new spreadsheets without having to recreate the macros each time? Kinda defeats the purpose that way.

Can anyone help?

 
You run into problems when you want to have X on a specific tab.
Do they need to actually save the data on the other sheets?

Sounds like a candidate for having 1 sheet that has a refreshable sheet with the last month/(X days) on it, which they can just copy to a new sheet, as needed.

Lodlaiden

If [blue]you have problems[/blue], I want [green]source code[/green] AND [green]error messages[/green], none of this [red]"there was an error crap"[/red]
 


hi,
how can I repeat the process on new spreadsheets without having to recreate the macros each time?
Well didn't you SAVE the macro somewhere?

Please repost your question and the macro in forum707, where you will have a better chance of getting some good tips.

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
I think I figured it out. I saved the file as a macro enabled template or workbook instead of a spreadsheet file.
 


If you are ADDING a querytable each time your macro runs, your process is flawed.

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top