We help IT Professionals succeed at work.

Where do I put this, What am I doing wrong in my TransferSpreadsheet

slatefamily
slatefamily asked
on
I have this in Access 2007 module:

Function ExportNewborn_HCH()

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7, "qryNeedsCorrection_HCH", "P:\Newborn Service Line Reports\NewbornServiceLineReport_HCH.xls", False, "Needs Correction"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7, "qryHCHPivotNewborn", "P:\Newborn Service Line Reports\NewbornServiceLineReport_HCH.xls", False, "Pivot"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7, "tblNewbornServiceLineReport_HCH", "P:\Newborn Service Line Reports\Newborne"

End Function


-------------------------

I have the macro do open module, it opens this but when I click run it is searching for a macro it doesn't do anything.
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2016
Commented:
in the Action column of the macro place

Action

RunCode



Function Name ExportNewborn_HCH()  

Author

Commented:
Awesome Thanks!  I use to work in access heavily, but I have been a stay at home mom for the last couple of years and obviously I am a little rusty.
CERTIFIED EXPERT
Top Expert 2016

Commented:
:-) don't worry about being away for a while and being rusty, a small drop of wd40 can handle that.. ;-0

Explore More ContentExplore courses, solutions, and other research materials related to this topic.