Search results

this link https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/convertto-xml?view=powershell-7 say the output are sistem.string Outputs System.String or System.Xml.XmlDocument how i can get them

yes but how can I get the xml file after i run script I run this PS c:\0> ConvertTo-Xml -InputObject temp_JSON.json -As document where is the file

I need to convert json file from web to xml file and i need very simple way... There are several data I need from json response... There are a lot of around but they are not very clear... I found some samples like this: PS c:\0> ConvertTo-Xml -InputObject temp_JSON.json -As String PS c:\0>...

You have ptrSAFE error only when you run your code on 64bit office version.... This issue is about running ACCESS 2003(32bit office version) on WIN10 .... Just follow YORR suggestion from above and graffic filters will allow you to use jpeg~jpg files in access 2003 ... I tried and it works

wow this is the solution..... I have the same issue as above and I worked normal for couple of months with access 2003 on win10 and then jpg file were just blocked.... I spent several days googling and trying everything to solve this and finally sollution was that simple like this one ...

I'd like to generate dynamic expression from string e.g. from string SF = subfolder ' varable "or each" & SF & "in fso.folders.. " to For each subfolder in fso.folders .... where subfolder is variable Actually I need to examine contents in the parent folder which contains n not known...

I'm trying to Copy file (e.g. picture) from android device (e.g. cell phone, tablet...) to PC, but i did stack I did get the path and read and execute shell command to the device folder like device =...

So finally i did open the file with device = "::{20D04FE0-3AEA-1069-A2D8-08002B30309D}\\\?\usb#vid_12d1&pid_1082&mi_00#6&15652f25&0&0000#{6ac27878-a6fa-4155-ba85-f98f491d4f33}" Call CreateObject("Shell.Application").ShellExecute(device & "\Internal storage\DCIM\CAMERA\12.jpg") WOW I GOT IT...

this give me some hope ... step by step... Portable device does not work but i choose computer shell:::{20D04FE0-3AEA-1069-A2D8-08002B30309D} so i did: sub test() Dim objShellAPP Set objShellAPP = CreateObject("Shell.Application") COMPUTER =...

that link could be some start, it works but for the printers.. Set objFolder = objShellAPP.Namespace("::{2227a280-3aea-1069-a2de-08002b30309d}") ' Printers and Faxes but i cant find arguments or value for external storage

I need to get path string to android device or its sd card as be able to copy or get some files(e.g. pictures) to process further.... As I red around not so menu samples about ... 1. I tried go get the file with file dialog "f = Application.FileDialog..." but the directory has not been showed...

Now I use wininet.dll library to get file and calculate progres of dowloading action .... it is something like this: Do If InternetReadFile(hRequest, VarPtr(Buffer(0)), BUF_SIZE, dwBytesRead) Then If WriteFile(hFile, VarPtr(Buffer(0)), dwBytesRead, dwBytesWritten, 0) Then...

I need to decrease default timeout (which is about 30 sec) in executing the followed code Private Const BUF_SIZE As Long = 4096 ' allocation buffer Private Const INVALID_HANDLE_VALUE As Long = (-1) Private Const CREATE_ALWAYS As Long = &H2&...

Enable and disable usb port .... Is it possible enable and disable a usb port via vba? An example of using this would be if I had a light plugged in a usb port and the code would turn it on and off. Or maybe is there s some...

Thanks a lot vbaInet.... I spend a whole week fighting with this... Finally I can import Cyrillic text into my tables with xml... BTW... I just little modify your code so I hope this post will be hopefull for another users... By the way there are no enough answers about this around net... NOTE...

I create file with for xml auto : exec master..xp_cmdshell 'bcp "select * from mytable" as ROW for xml auto , elements, queryout "c:\file.xml" -T -C 1251 -w -r -t' But I don't why root element does not want to be created... This does not work: exec master..xp_cmdshell 'bcp "select * from...

Problem is about encoding of the files somehow... The new file = var = firstline & vbcrlf(text from start file) & var & lastline has wrong encoding because start file has Cyrillic characters inside... so when i try to import xml in access tables...error is appearing like iligal characters...

The problem is that if i get text from old file in vbcrlf beacuse of cyrillic charcters vb make some conversion of the characters and then file is not usefull so I can't delete old file... I need only to append line... the last line is ok i just append... but i can't insert first line in the text..

SQL 2000 database I can't create root element with for xml auto, root "root" with bcp the xml file is created but root is not created.. Is it common with SQL 2000 database This works... but root element is not created exec master..xp_cmdshell 'bcp "select * from mytable" as ROW for xml auto ...

I need to insert(append) first and last line in xml file... So I have xml file and I need to insert one line to the top and at the of the text... Xml file contains Cyrillic characters and method to recreate xml file is going wrong with characters conversions... The last line a can append easy...