|
Hi,
I have below code to calling SharePoint REST API through VBA in Excel but I got the Erorr: 2147024891, System.UnauthorizedAccessException. Any idea how to fix this issue?
.
Sub Button3_Click()
strUrl = "https://abc.sharepoint.com/sites/QA/_api/lists/getbytitle('TestingInformation')/items"
With CreateObject("MSXML2.ServerXMLHTTP.6.0")
.Open "GET", strUrl, False
.Send
Content = .ResponseText
End With
MsgBox Content
End Sub
|
|
|
|
|
That's an error from the server, which suggests that you're not authorized to retrieve the requested information.
NB: If the server requires authentication, you will need to use SetRequestHeader to send the appropriate authentication header. How you do that will depend on the required authentication scheme. For example, "basic" authentication requires a Base64-encoded combination of the username and password.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Hallo,
can I ask a question about agilitypack here?
From this website
https://update.kbv.de/ita-update/
I need a listing of the directories and files (ListDirectoryDetails under FTP). From this I would like to make a TreeView. This is fully programmed in C# and has been populated with FTP up to now. I am missing the file list on this website with HTTP. Is there a code snippet somewhere for this problem with the agilitypack?
Best regards
Norbert
|
|
|
|
|
|
Thanks. With FTP everthing has gone very well so far. But now the server has been switched off and access is only possible via HTTP(s). Please visit this website Index of /ita-update
How do I get the directories and file links for a offline TreeView with the HtmlAgilityPack? There does not seem to be any other way with Vb.Net
Best regards
Norbert
|
|
|
|
|
So the server admin turned off FTP and I don't think you can get the server directories via HTTPS. Unless you install a tool on the server with higher permissions that will supply the directories to the browser (HTTPS) you are probably not going to be able to do what you want.
Caveat - I have limited knowledge of this area so a better answer may come along.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|
|
HTTP won't give you a folder structure. You have to get the root page, parse it for any subdirectories (if available), then make another request for each directory, building out a data structure as you go.
|
|
|
|
|
Hello
Im IT manager in small company and
I have around 100 user, im building an IT helpdesk tool and i thinking to add more features than add/search/edit/tickets
I need something so useful like run a service directly from my tool.
Every time to close a ticket, i connect to user pc and if i need to edit something, i've to using the local administrator user & password
Any idea to skip this process (like single sign from my pc)
Simthing like push a packet to the target pc to run the cmd or explorer++ with using (my credentials) the local admin credentials
Note:
I've the local admin user & password
(All users working with Microsoft account)
I've access on Azure Active Directory admin center.
|
|
|
|
|
|
I wondered if anybody had an examples of/lessons on creating a google doc in .Net using Visual Basic. I understand you use documents.create in the Google API and then use documents.batchUpdate to update the blank document with all the formatting and text but I am having difficulty understanding how exactly you create the set of updates.
Basically we have an existing program written in vb.net which, amongst a lot of other things, creates (from a number of sources) tailored MS Word documents. However the company would like to modify the module which does this so that it creates a Google doc rather than an an MC Word document. This would be my first foray into the Google API and any pointers would be gratefully appreciated.
(PS, Yes I know it might be better to do it in another language, but that would be a major re-write of the whole thing rather than just a module and there are not the resources for that at present.)
|
|
|
|
|
|
Hey everybody I have this question in visual basic which I need help with which is
create an array (26) and then use for loop to:
1. assign to its elements the English letters from A to Z.
2. print the letters on a Message boxes.
If any body know how to solve it the right way please help because it keeps giving me errors and I need to turn it as an assignment fast .
Thanks in advance.
|
|
|
|
|
Member 15348251 wrote: it keeps giving me errors
Unless you show your code and the complete details of the errors, it is impossible for anyone to help.
|
|
|
|
|
The thing is I'm new to visual basic because it's a mandatory requirement to graduate in our university so you can say I'm a beginner in it . So can you help in solving it for me if you may.
|
|
|
|
|
As I said, without the details of the code and the errors we cannot begin to guess what the problem is. And if you thought that someone here would write your assignment for you, I am afraid you are in the wrong place.
|
|
|
|
|
As I said I'm a beginner in this subject and I found two codes that might apply to this mater
The first one is :
Dim L(26) as string
Dim X as integer
For X= A to Z
Msgbox (L(X))
Next
* but it keeps saying that A and Z are not declared
The second one is :
Public
Dim A as integer
..............................
Dim L(26) as string
For A=65 to 90
Msgbox(chr(A))
Next
** I think the second one is the proper one . But if there is a thing that I can do to make it better or if you can explain how to write the code the right way I will be thankful
|
|
|
|
|
In the first case you have declared an array of integers, but you are supposed to be using characters. if the second one works then that looks fine.
|
|
|
|
|
Ok nice is there anything I can do to make the second code better or any advice about it like if you were to write it differently what would you add to it in your point of view.
|
|
|
|
|
I cannot really judge, as I do not know what your teacher is expecting from you.
|
|
|
|
|
My apologies, but I had to go somewhere at short notice yesterday. Having had some time to review my answers I suggest the following code:
Dim letters(26) as Char
For k As Integer = 0 To 25
letters(k) = Chr(Asc("A") + k)
Console.Write("{0}", letters(k))
Next
Console.WriteLine("")
I have used the Console.Write method merely as a testing tool. You can replace it with: Msgbox(letters(k)) and it will still work.
|
|
|
|
|
While we are more than willing to help those that are stuck, that doesn't mean that we are here to do it all for you! We can't do all the work, you are either getting paid for this, or it's part of your grades and it wouldn't be at all fair for us to do it all for you.
So we need you to do the work, and we will help you when you get stuck. That doesn't mean we will give you a step by step solution you can hand in!
Start by explaining where you are at the moment, and what the next step in the process is. Then tell us what you have tried to get that next step working, and what happened when you did.
If you are having problems getting started at all, then this may help: How to Write Code to Solve a Problem, A Beginner's Guide[^]
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
i built one program but facing problem what i try to do is when i select items from combobox eg. Primary vertical(PV), secondary vertical(SV) etc. next textbox will auto take serial no. like PV-01/today_date, next entry will be PV-02/today_date and so on and when next day again i try to add entries serial no. started from PV-01/.....
I AM USING VB 2010 with access database for this.
dont know what to do i am new in vb
|
|
|
|
|
You have already posted this in QA:
Text box auto takes serial no when items select form combo box[^]
You didn't provide enough information for anyone to help you. Reposting exactly the same thing isn't going to change that.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
So if i copy something, it goes directly into "Textbox2" but sometimes the same text as "Textbox1" goes into "Textbox2" regardless of it not being "allowed". (see code below)
Private Sub Timer1_Tick(sender As Object, e As EventArgs) Handles Timer1.Tick
Dim clip As String = Clipboard.GetText
If clip.StartsWith(TextBox1.Text) Then
Else
TextBox2.Text = Clipboard.GetText
End If
End Sub
The timer has an interval of 100ms (i think my pc isnt to slow to handle it) but this also happens if the timer has a interval of 3000ms or anything higher (it just happens later). What is the issue here?
|
|
|
|
|
Member 14954903 wrote: What is the issue here?
Impossible to tell. It is possible that between the moment your code reads the clipboard and the next statement, the contents of Textbox1 changes. You need to add some debug code to try and find out exactly what data exists in each place.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
