lovemuscle2005
Board Regular
- Joined
- Dec 28, 2004
- Messages
- 99
Hi All
I have a bit of a problem.
I have an excel sheet which within in holds a MS Query. I have in the excel book a simple macro:
Aut
pen()
Range("A2").Select
Selection.QueryTable.Refresh BackgroundQuery:=False
Application.WindowState = xlNormal
Application.WindowState = xlNormal
Application.WindowState = xlNormal
Application.WindowState = xlNormal
Application.WindowState = xlMinimized
Application.WindowState = xlNormal
Application.WindowState = xlMaximized
I'm trying to run this from Access to try and make a process seemless. Can anyone tell me how to convert this to be able to call excel to run it
As always thanks in advance
I have a bit of a problem.
I have an excel sheet which within in holds a MS Query. I have in the excel book a simple macro:
Aut

Range("A2").Select
Selection.QueryTable.Refresh BackgroundQuery:=False
Application.WindowState = xlNormal
Application.WindowState = xlNormal
Application.WindowState = xlNormal
Application.WindowState = xlNormal
Application.WindowState = xlMinimized
Application.WindowState = xlNormal
Application.WindowState = xlMaximized
I'm trying to run this from Access to try and make a process seemless. Can anyone tell me how to convert this to be able to call excel to run it
As always thanks in advance