首页 \ 问答 \ VBA - 计算并打印许多行的答案(VBA - calculate and print answer for many rows)

VBA - 计算并打印许多行的答案(VBA - calculate and print answer for many rows)

 我仍然是vba的新手，我正在编写一个宏来计算两列中两个日期之间的时间，使用dateDiff然后打印它旁边的单元格中的差异。 我也想做一个直到空  
 A列保存开始日期B列保存结束日期C列将保留答案  
 我有一些有用的代码，但大部分内容是为了理解宏的目标和需求而改变的。  
Range("A2").Select
Do Until IsEmpty(ActiveCell)
 For i = 2 To 25
  date1 = ["A" & i]
  date2 = ["B" & i]
  answer = DateDiff("n", date1, date2)
  "C" & i = answer
 next i
Loop
 
 我感谢任何帮助！ 

I am still new to vba and am writing a macro to calculate the time between two dates in two columns using dateDiff then print the difference in the cell next to it. i would also like do use a do until empty 
Column A holds the start date Column B holds the end date Column C will hold the answer 
i have some useful code but most of it is written to understand the goal of the macro and needs changed. 
Range("A2").Select
Do Until IsEmpty(ActiveCell)
 For i = 2 To 25
  date1 = ["A" & i]
  date2 = ["B" & i]
  answer = DateDiff("n", date1, date2)
  "C" & i = answer
 next i
Loop
 
I appreciate any help!

原文：https://stackoverflow.com/questions/44440955

更新时间：2022-03-23 09:03

最满意答案

 尝试将您的客户端代码更改为：  
<script src="/socket.io/socket.io.js"></script>
<script>
    var socket = io.connect();
    socket.on("connect", function() {
        socket.on('news', function (data) {
            socket.emit('my other event', { my: 'data' });
        });
    });
</script>
 
 此外，为了能够转到/api/1...您需要注册相应的app.get ，例如app.get("/api/*", ... ，它将处理所有连接to /api/...否则预计您将收到404错误。 

Try to change your client code to: 
<script src="/socket.io/socket.io.js"></script>
<script>
    var socket = io.connect();
    socket.on("connect", function() {
        socket.on('news', function (data) {
            socket.emit('my other event', { my: 'data' });
        });
    });
</script>
 
Also, in order to be able to go to /api/1... you need to register the corresponding app.get, e.g. as app.get("/api/*", ..., which would handle all the connections to /api/.... Otherwise it is expected that you will be getting the 404 error.

VBA - 计算并打印许多行的答案(VBA - calculate and print answer for many rows)

最满意答案

相关问答

找不到Socket.io 404(Socket.io 404 Not Found)[2023-05-12]

我试过的每个端口上的Heroku上的Socket.io 404es(Socket.io 404es on Heroku on every port I tried)[2019-12-03]

Socket.io在Laravel进行民意调查404(Socket.io polling 404 in Laravel)[2022-09-06]

socket.io/1/?t=1437482662157 404未找到(socket.io/1/?t=1437482662157 404 Not found)[2021-11-26]

socket.io不一致连接(socket.io is not consistently connecting)[2022-07-22]

Express.js'socket.io/socket.io.js 404'(Express.js 'socket.io/socket.io.js 404')[2022-10-09]

在Socket.io上连接404(404 on Socket.io connect)[2022-12-08]

为什么socket.io给我404错误？(Why is socket.io giving me a 404 error?)[2022-04-15]

控制2个socket.io连接(Controlling 2 socket.io connections)[2022-08-21]

相关文章

最新问答