I have a Task like below
I have client machine path (i.e., C:/Folder1) in excel office js.
I am passing that path to macro vb and reading files by below code.
In below for each loop myFile is my file object
My Quetion is: how to post the data from macro vb to Web Api?
Sub LoopThroghEachFile(mySourcePath)
Dim ShellObject As Object, MyObject As Object, MySource As Object, myFile As Object, dirObject As Object, iCol As Byte
Set ShellObject = CreateObject("Shell.Application")
Set dirObject = ShellObject.Namespace(mySourcePath)
Set MyObject = CreateObject("Scripting.FileSystemObject")
Set MySource = MyObject.GetFolder(mySourcePath)
If iRow = 0 Then
iRow = 1
End If
On Error Resume Next
For Each myFile In MySource.Files
Next
Set ShellObject = Nothing
Set dirObject = Nothing
Set MyObject = Nothing
Set MySource = Nothing
End Sub