I am currently using the code "Selection.Past eSpecial Paste:=xlValues " for a macro that pastes values only. Does anybody know the command for paste as CSV?
-
-
Just use the menu option "Convert Macro's to Visual Basic".
The auto append will show all parameter values.
Nic;o) -
This code is currently in Excel, and there's no option for "Convert Macros to Visual Basic" in ExcelComment
-
The Excel Macro's are recorded in VBA, thus you can find it by recording the operation and check the contents in the Macro editor.
This is the Access topic area, thus my assumption that we're dealing with Access macro's :-)
Nic;o)Comment
Comment