Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #72.7K
~106 People Reached
Favorite Forums
|
With the below code I am getting the following error for the during Workbooks.Close. The error is "Wrong number of arguments or invalid property assignments". Here is my code Range("D2:D61").Select Selection.ClearContents Workbooks.Open "c:\Excel\SA2047679.csv" Range("G2:G61").Select Selection.Copy Windows("SA2047679_35.xls").Activate Range("D2").Select ActiveSheet.Paste Range("F2").Select Workbooks.Close "c:\Excel\SA2047679.csv" TIA
|