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?
strUrl = "https://abc.sharepoint.com/sites/QA/_api/lists/getbytitle('TestingInformation')/items"
.Open "GET", strUrl, False
Content = .ResponseText
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
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?
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
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 -
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.
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
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.)
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
* but it keeps saying that A and Z are not declared
The second one is :
Dim A as integer
Dim L(26) as string
For A=65 to 90
** 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
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) asCharFor k AsInteger = 0To25
letters(k) = Chr(Asc("A") + k) ' add the index value to the value of character A, and convert back to a character
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.
"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.
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
TextBox2.Text = Clipboard.GetText
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?
Last Visit: 31-Dec-99 19:00 Last Update: 4-Dec-22 5:21