We have a "shared" work book we all work in. Here at work, I have some incompentant computer workers who claim they KNOW MS sooo well and have certificates etc. I have been trying to learn macros but have not made one yet. I have uninstalled the addin and so far so good, but I cannot categorically say that this was the cause.ĭoesn't seem to cover the issue I describe
#RUN EXCEL VBA ON SHAREPOINT SITE CODE#
The only thing I could suspect was I think this started around about the time I installed xlDennis' code library. Some days I can work without this problem, other days I encounter this 2 or 3 times. I can't work out when it goes into this mode.
Clicking save just invokes the same msgbox again. If I close the workbook I am prompted to save, close without saving or cancel. Using Save As doesn't either do anything, the dialog is not displayed and if I am doing via the File menu then the File menu is exited and the previous ribbon tab is displayed (i.ethe one I was on before clicking 'File') Found others suffering the same but haven't found any conclusive answer yet.Įvery so often when I attempt to save a file, (including save as), Excel won'r let me.
#RUN EXCEL VBA ON SHAREPOINT SITE HOW TO#
csv, close the window and then open that file up again, that dang scientific format is back.ĭoes anyone have any idea of how to work around this? Once I have successfully gotten the numbers to display as the long-chain number, how can I get them to "stick" so that they don't revert back to scientific format when I reopen the file? I have tried creating an Excel doc from scratch and entering text in Text format, to see if this created a cleaner file. csv file), the numbers are back to being displayed in scientific format. So if I do that, close the Excel window, and then open again (as the. I have saved as a TXT file, pasted the longer number and it displays correctly. I have been successful at preventing Excel from coverting that long number into scientific format. csv files, so this is how I need to save my doc (with this extension). csv file in order to upload to an application that parses out the. I am working with an Excel spreadsheet and saving it as a. MsgBox Err.Number & ": " & Err.I know this question has been asked a bajillion times, so I apologize for the redundancy. ObjectHTTP.SetRequestHeader "SOAPAction", strSOAPAction ObjectHTTP.SetRequestHeader "Content-Type", "text/xml charset=utf-8" ObjectHTTP.Open "Get", strURLService, False "" & spBASE_URL & spDOC_LIB & "/" & spFILE_NAME & "" & _ StrURLService = spBASE_URL & "_vti_bin/copy.asmx" ObjectElement.nodeTypedValue = BinaryFile ObjectElement.DataType = "bin.base64" 'Type Base64 Set ObjectHTTP = CreateObject("Microsoft.XMLHTTP")ĭoEvents 'Pause before trying to open, just in case it hasn't closed yet. Set ObjectElement = ObjectDOM.createElement("TMP")
Set ObjectDOM = CreateObject("Microsoft.XMLDOM") Set ObjectStream = CreateObject("ADODB.Stream")
MsgBox "File not found.", vbCritical, "Upload File" 'So, this instance is specific to the SLMDashData.xlsx upload 'Because the SOAP Method requires constants, it's probably not possible to make this generic.
(I used this as I wanted it to write some Metadata with the document.) From it, you can probably figure out a way to perform yourĭesired download. You exact desire is unclear, so I'll just post the following code that shows a very complex SOAP method to Upload a file.
0 kommentar(er)
