Macro converted to function won’t work the same

Topic

New Reply

Post deleted by jp2558

Reply | Quote

Replies

please post the code access created so we can see what is happening

Reply | Quote

Function modImportInvitees()
On Error GoTo modImportInvitees_Err

DoCmd.TransferSpreadsheet acImport, 8, “tblInviteeImportWorkfile”, “c:tempevent.dif”, True, “”
Beep
MsgBox “Invitee Import Completed Sucessfully.”, vbInformation, “Invitee Import Process”
DoCmd.Close acForm, “Import_Invitees”

modImportInvitees_Exit:
Exit Function

modImportInvitees_Err:
MsgBox Error$
Resume modImportInvitees_Exit

End Function

Reply | Quote

I hope this helps. Thanks

Reply | Quote

Never mind – after hours of frustration I’ve convinced the user that they must save their data to excel and then ‘save_as’ from excel as a *.CSV file. Seems to be an effective workaround.

Reply | Quote

I suspect the problem is that the file you’re trying to import doesn’t have an xls extension. TransferSpreadsheet is not one of my favorite actions, and it breaks easily. However, just changing the name of your file from a .dif to a .xls might solve your problem. Does Excel recognize the file if you try to open it with that extension?

Reply | Quote