Jan 26, 2006 #1 N nebisman Full Member level 4 Joined Apr 13, 2002 Messages 226 Helped 10 Reputation 22 Reaction score 9 Trophy points 1,298 Activity points 1,849 scope excel sorry if this is offtopic Can I store data from a excel template into a specific formatted plain text file, only using excel and macros?
scope excel sorry if this is offtopic Can I store data from a excel template into a specific formatted plain text file, only using excel and macros?
Jan 26, 2006 #2 N Nart Junior Member level 2 Joined Nov 26, 2005 Messages 24 Helped 0 Reputation 0 Reaction score 0 Trophy points 1,281 Activity points 1,483 Re: a simple question i think it must be. but i dont know how?
Jan 27, 2006 #3 ahmad_abdulghany Advanced Member level 4 Joined Apr 12, 2005 Messages 1,206 Helped 102 Reputation 206 Reaction score 22 Trophy points 1,318 Location San Jose, California, USA Activity points 11,769 Re: a simple question nebisman said: sorry if this is offtopic Can I store data from a excel template into a specific formatted plain text file, only using excel and macros? Click to expand... What is the template type you mean??
Re: a simple question nebisman said: sorry if this is offtopic Can I store data from a excel template into a specific formatted plain text file, only using excel and macros? Click to expand... What is the template type you mean??
Jan 28, 2006 #4 N nebisman Full Member level 4 Joined Apr 13, 2002 Messages 226 Helped 10 Reputation 22 Reaction score 9 Trophy points 1,298 Activity points 1,849 Re: a simple question a template that is generated for the software that captures data from a scope. is three column simple excel data no more.
Re: a simple question a template that is generated for the software that captures data from a scope. is three column simple excel data no more.
Jan 28, 2006 #5 yurble_vn Newbie level 5 Joined Dec 26, 2005 Messages 9 Helped 1 Reputation 2 Reaction score 0 Trophy points 1,281 Activity points 1,370 Re: a simple question Just select all the data in excel and paste to txt editor. It will be separate by a tab character if you wan to have a comma delimited, or space delimited, just go to save as and select text (comma delimited) or text (space delimited)
Re: a simple question Just select all the data in excel and paste to txt editor. It will be separate by a tab character if you wan to have a comma delimited, or space delimited, just go to save as and select text (comma delimited) or text (space delimited)