Converting From VB.Net or C# to VBA

N

Neil

I have some code I need to convert from VB.net to VB or VBA (I will be
using it in Access 2010). The code is to upload a document to a
SharePoint library (using the SharePoint Foundation 2010 Managed COM).
The original code was in C#. I used a C# to VB.Net converter to get it
into VB.Net. Now I need to get it into VB or VBA. Is it possible?

Here is the original C# code (from
http://msdn.microsoft.com/en-us/library/ee956524.aspx):

using System;
using System.IO;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Wordprocessing;
using Microsoft.SharePoint.Client;
// The following directive avoids ambiguity between the
// System.IO.File class and Microsoft.SharePoint.Client.File class.
using ClientOM = Microsoft.SharePoint.Client;
class Program
{
static void Main(string[] args)
{
ClientContext clientContext =
new ClientContext("http://intranet.contoso.com");
using (FileStream fileStream =
new FileStream("NewDocument.docx", FileMode.Open))
ClientOM.File.SaveBinaryDirect(clientContext,
"/Shared Documents/NewDocument.docx", fileStream, true);
}
}

And here is the code after it was converted to VB.Net:

Imports System.IO
Imports DocumentFormat.OpenXml.Packaging
Imports DocumentFormat.OpenXml.Wordprocessing
Imports Microsoft.SharePoint.Client
' The following directive avoids ambiguity between the
' System.IO.File class and Microsoft.SharePoint.Client.File class.
Imports ClientOM = Microsoft.SharePoint.Client
Class Program
Private Shared Sub Main(args As String())
Dim clientContext As New ClientContext("http://intranet.contoso.com")
Using fileStream As New FileStream("NewDocument.docx", FileMode.Open)
ClientOM.File.SaveBinaryDirect(clientContext, "/Shared
Documents/NewDocument.docx", fileStream, True)
End Using
End Sub
End Class

Any idea how this would look in VB or VBA?

Thanks!

Neil
 
T

The Mad Ape

Neil said:
I have some code I need to convert from VB.net to VB or VBA (I will be
using it in Access 2010). The code is to upload a document to a
SharePoint library (using the SharePoint Foundation 2010 Managed COM).
The original code was in C#. I used a C# to VB.Net converter to get it
into VB.Net. Now I need to get it into VB or VBA. Is it possible?

Here is the original C# code (from
http://msdn.microsoft.com/en-us/library/ee956524.aspx):

using System;
using System.IO;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Wordprocessing;
using Microsoft.SharePoint.Client;
// The following directive avoids ambiguity between the
// System.IO.File class and Microsoft.SharePoint.Client.File class.
using ClientOM = Microsoft.SharePoint.Client;
class Program
{
static void Main(string[] args)
{
ClientContext clientContext =
new ClientContext("http://intranet.contoso.com");
using (FileStream fileStream =
new FileStream("NewDocument.docx", FileMode.Open))
ClientOM.File.SaveBinaryDirect(clientContext,
"/Shared Documents/NewDocument.docx", fileStream, true);
}
}

And here is the code after it was converted to VB.Net:

Imports System.IO
Imports DocumentFormat.OpenXml.Packaging
Imports DocumentFormat.OpenXml.Wordprocessing
Imports Microsoft.SharePoint.Client
' The following directive avoids ambiguity between the
' System.IO.File class and Microsoft.SharePoint.Client.File class.
Imports ClientOM = Microsoft.SharePoint.Client
Class Program
Private Shared Sub Main(args As String())
Dim clientContext As New ClientContext("http://intranet.contoso.com")
Using fileStream As New FileStream("NewDocument.docx", FileMode.Open)
ClientOM.File.SaveBinaryDirect(clientContext, "/Shared
Documents/NewDocument.docx", fileStream, True)
End Using
End Sub
End Class

Any idea how this would look in VB or VBA?

Thanks!

Neil
Click to expand...

I have no idea but you may want to try http://experts-exchange.com. They
may figure it out but you pay for the service.
 
A

Arne Vajhøj

I have some code I need to convert from VB.net to VB or VBA (I will be
using it in Access 2010). The code is to upload a document to a
SharePoint library (using the SharePoint Foundation 2010 Managed COM).
The original code was in C#. I used a C# to VB.Net converter to get it
into VB.Net. Now I need to get it into VB or VBA. Is it possible?

Here is the original C# code (from
http://msdn.microsoft.com/en-us/library/ee956524.aspx):

using System;
using System.IO;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Wordprocessing;
using Microsoft.SharePoint.Client;
// The following directive avoids ambiguity between the
// System.IO.File class and Microsoft.SharePoint.Client.File class.
using ClientOM = Microsoft.SharePoint.Client;
class Program
{
static void Main(string[] args)
{
ClientContext clientContext =
new ClientContext("http://intranet.contoso.com");
using (FileStream fileStream =
new FileStream("NewDocument.docx", FileMode.Open))
ClientOM.File.SaveBinaryDirect(clientContext,
"/Shared Documents/NewDocument.docx", fileStream, true);
}
}

And here is the code after it was converted to VB.Net:

Imports System.IO
Imports DocumentFormat.OpenXml.Packaging
Imports DocumentFormat.OpenXml.Wordprocessing
Imports Microsoft.SharePoint.Client
' The following directive avoids ambiguity between the
' System.IO.File class and Microsoft.SharePoint.Client.File class.
Imports ClientOM = Microsoft.SharePoint.Client
Class Program
Private Shared Sub Main(args As String())
Dim clientContext As New
ClientContext("http://intranet.contoso.com")
Using fileStream As New FileStream("NewDocument.docx",
FileMode.Open)
ClientOM.File.SaveBinaryDirect(clientContext, "/Shared
Documents/NewDocument.docx", fileStream, True)
End Using
End Sub
End Class

Any idea how this would look in VB or VBA?
Click to expand...

It could be difficult translating those .NET library
calls into equivalent COM calls.

I say that the easiest way forward us to rewrite the C# console
app above to expose a COM interface and then call that from VBA.

Arne
 
A

Arne Vajhøj

I have no idea but you may want to try http://experts-exchange.com. They
may figure it out but you pay for the service.
Click to expand...

E-E is what was used 5-10 years ago. Today it is SO.

But I find it a bit distasteful to suggest other
fora than usenet given that there are usenet groups
where this question could be answered.

Arne
 
T

The Mad Ape

Arne said:
E-E is what was used 5-10 years ago. Today it is SO.

But I find it a bit distasteful to suggest other
fora than usenet given that there are usenet groups
where this question could be answered.

Arne
Click to expand...

I don't see too many helping him out. Do you? If you find it distasteful
you whiny bitch then help him out or **** off.

TMA
 
N

Neil

Thanks, everyone, for your replies! I actually found another way to
accomplish this that didn't use the SP Foundation COM. So, was able to
write it directly in VBA. Thanks for the input, though. Appreciate it!

Neil
 
M

Martin Crouch

I have some code I need to convert from VB.net to VB or VBA (I will be
using it in Access 2010). The code is to upload a document to a
SharePoint library (using the SharePoint Foundation 2010 Managed COM).
The original code was in C#. I used a C# to VB.Net converter to get it
Click to expand...
Any idea how this would look in VB or VBA?

Thanks!

Neil
Click to expand...

You could do it by building a COM interop library to wrap the .NET
sharepoint stuff as COM.

Here's an example:
http://richnewman.wordpress.com/2007/04/15/a-beginner’s-guide-to-calling-a-net-library-from-excel/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting VB.Net to VBA 3
translate dll/tlb (for Excel as client) from VB.net to C# 1
Problem transferring VBA code w/ ProcOfLine & ProcBodyLine to VB.NET 0
Still trying to serialize treeview in C# 0
From C to VB.NET (Part III) (Background image in TextBox) 5
C# OO - 1.1 - going from vb.net to c# 5
Excel VBA Paste of Range with PrefixCharacter fails from VB.NET 1
To Serialize or Not to Serialize? 1

Top