I currently have a spreadsheet that has a few graphs that takes data from specific points. I have a text file that can currently be opened, then be copy pasted into that current spreadsheet. Once pasted, all of the formats from the text file are correct. I'm trying to create a macro that will paste it into the currently opened spreadsheet.
i've tried code like http://www.pcreview.co.uk/forums/macro-copy-daily-text-file-t978817.html the last post, but it didn't end up working. An error got flagged on his second line.
I created one macro that didn't work. it opened the text file, but also opened a new excel file and put the text into that file rather than the specific spreadsheet in the current file I wanted.
does anyone know of a macro that would work?
I'm not exactly an excel guru so any help is greatly appreciated.
i've tried code like http://www.pcreview.co.uk/forums/macro-copy-daily-text-file-t978817.html the last post, but it didn't end up working. An error got flagged on his second line.
I created one macro that didn't work. it opened the text file, but also opened a new excel file and put the text into that file rather than the specific spreadsheet in the current file I wanted.
does anyone know of a macro that would work?
I'm not exactly an excel guru so any help is greatly appreciated.
Last edited: