M
Michael
Hi ive got a problem with my macro this time...
I've got the table where i put details, than ive got query with
:"[Forms]![xxxxxxxxxx]![Text1]" formula. Which made me put the number that i
am interested in, than when i punch Enter it should transfer me to the excel
sheet with already preapared Report by me in Excel. I have 2 worksheets
called :Report Form, and Query, which is hidden. So basically access sends
query to the excel "Query" sheet in my Report and than its gonna be
automaticaly in my Report Form throw the formula =Query!A1, than other cell
=Query!C2, and so on but it doesnt WORK !! Ive got macro in Excell Sheet
maybe thats gonna help to help me
Sub Autpen()
' Autpen Macro
' Macro recorded 29/01/2004 by Mike
Sheets("Query").Select
Range("A2").Select
ActiveSheet.Paste
ActiveWindow.SelectedSheets.Visible = False
Application.CutCopyMode = False
ThisWorkbook.Saved = True
Application.DisplayAlerts = False
End Sub
It looks like something is wrong with the macro. Hopefully everybody
understands what i am trying to say and explain its hard...
Anyway thanks very much i can send my database by an e-mail if thats gonna
help to solve that problem.
I've got the table where i put details, than ive got query with
:"[Forms]![xxxxxxxxxx]![Text1]" formula. Which made me put the number that i
am interested in, than when i punch Enter it should transfer me to the excel
sheet with already preapared Report by me in Excel. I have 2 worksheets
called :Report Form, and Query, which is hidden. So basically access sends
query to the excel "Query" sheet in my Report and than its gonna be
automaticaly in my Report Form throw the formula =Query!A1, than other cell
=Query!C2, and so on but it doesnt WORK !! Ive got macro in Excell Sheet
maybe thats gonna help to help me
Sub Autpen()
' Autpen Macro
' Macro recorded 29/01/2004 by Mike
Sheets("Query").Select
Range("A2").Select
ActiveSheet.Paste
ActiveWindow.SelectedSheets.Visible = False
Application.CutCopyMode = False
ThisWorkbook.Saved = True
Application.DisplayAlerts = False
End Sub
It looks like something is wrong with the macro. Hopefully everybody
understands what i am trying to say and explain its hard...
Anyway thanks very much i can send my database by an e-mail if thats gonna
help to solve that problem.