J
joe
How do I format raw data using the VB Macro recorder. I have tried to drop
data from the clipboard to the spreadsheet and, using the text import
wizard, it shows up as expected. When I invoke the macro later it appears
as just raw data and it is not populated to the rows/cells. I am trying to
get where I can read an email, populate a spread sheet and build a chart. I
got a long way to go, because I cannot get the macro to put the data in
correctly. The text data is copied from an email then pasted into a sheet.
After pasting, using the wizard works well. When using the macro, it just
gets pasted as raw data.
Thanks
Joe
data from the clipboard to the spreadsheet and, using the text import
wizard, it shows up as expected. When I invoke the macro later it appears
as just raw data and it is not populated to the rows/cells. I am trying to
get where I can read an email, populate a spread sheet and build a chart. I
got a long way to go, because I cannot get the macro to put the data in
correctly. The text data is copied from an email then pasted into a sheet.
After pasting, using the wizard works well. When using the macro, it just
gets pasted as raw data.
Thanks
Joe