Visual Basic宏将一些文本从一列剪切并粘贴到另一列 [英] Visual Basic Macro to cut and paste a bit of text from one column to another

问题描述

  我有一组看起来像这样的数据：

[2010/01/02 00:00:00] SRP TYPE 2：RSQP = -119; RSRP = ....

[2010/01/02 / 00:00:01] SRP Request Proceudre; CINR小于.....

我想写一个宏来削减时间戳并将其粘贴到另一列。有没有人有什么建议。我尝试在Excel 2007中录制这个宏，但它没有用。

最好的问候

 

解决方案

Excel宏用VBA编码，而不是VB.Net。 这个论坛涵盖了VB.Net。 如果你在VBA论坛上发帖，你将有更好的机会获得答案

http://social.msdn.microsoft.com/Forums/en-US/isvvba/threads 或Excel for Developers论坛
<标题="Excel for Developers Forum"href ="http://social.msdn.microsoft.com/Forums/en-US/exceldev/threads"target ="_ self">
http：// social。 msdn.microsoft.com/Forums/en-US/exceldev/threads

Hi,

   I have a set of data that looks like this with a single column:

[2010/01/02 00:00:00] SRP TYPE 2: RSQP = -119; RSRP = ....

[2010/01/02/ 00:00:01] SRP Request Proceudre; CINR Less Than .....

I would like to write a macro that cuts the timestamp and pastes it on to another column. Does anyone have any suggestions. I tried recording this Macro in Excel 2007 but it didn't quite work.

Best Regards

 

解决方案

Excel macros are coded in VBA, not VB.Net.  This forum covers VB.Net.  You will have a better chance of getting an answer if you post in the VBA forum http://social.msdn.microsoft.com/Forums/en-US/isvvba/threads or the Excel for Developers forum http://social.msdn.microsoft.com/Forums/en-US/exceldev/threads

这篇关于Visual Basic宏将一些文本从一列剪切并粘贴到另一列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！