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!

Excel Save Macro + Import

Status
Not open for further replies.

ebisabes

Technical User
Aug 11, 2006
71
US
If I create a macro to do a "Save as" for an excel file from .xls to .csv, and then import that file into my ADP PC Payroll for Windows it reads with everything as an error even though the macro is exactly what I do manually & the upload has no problems manually. Is this an ADP thing... anyone know?
 
Please post the code you are using - I don't have my telepathic abilities warmed up yet....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
Sub PRKYPEPI()
'
' PRKYPEPI Macro
' Macro recorded 8/1/2007 by Betsy
'
' Keyboard Shortcut: Ctrl+Shift+E
'
ActiveWorkbook.SaveAs Filename:="C:\ADP\PCPW\ADPDATA\prkypepi.csv", _
FileFormat:=xlCSVMac, CreateBackup:=False
End Sub
 
are you using a mac?:
FileFormat:=xlCSVMac

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
It's not going to record importing into ADP Payroll because that is completely outside Excel. You will probably need to consult ADP documentation to figure out how to automate that part of it.
 
in which case you shouldn't be saving it as a mac csv type should you....

rather than: FileFormat:=xlCSVMac
use: FileFormat:=xlCSV

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
ebisabes,

For future reference, please post VBA/Macro-specific questions in forum707

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top