How to trigger in Office Read-only yellow ribbon message?
Hi, Is there a way how i can show/trigger in Office (Word, Excel) a yellow ribbon message "Read-only This document was opened in read-only mode..."? I have my custom WebDAV server where i serve my files (Word, Excel files) Already tried: - To return 403 Forbidden on LOCK. (didnt worked) - RemovedMS-Author-Via Header (Didnt worked) Also is there a way how i can show that Session is expired?
Merge multiple XML files (with same layout) into 1 merged XML file (addition of data needed)
Hi, I don't have any experience with XML and I don't seem to have found any other discussion that could help me further. I would like to combine multiple XML files that have exactly the same lay-out but different data (different multiple amounts) into 1 file that keeps the original layout but adds up the amounts of the different data rows. My idea was to use power query on the folder where I will monthly download the individual XML files, automate the merging process including the necessary additions and export the 'merged' XML file. Is that possible and if yes any instructions on how I could do this? What would be the necessary steps in setting this up? Thank you in advance!
Combinaison de sommes
Bonjour, Je travaille actuellement sur Excel, et je cherche un moyen de trouver une combinaison de sommes parmi une liste définie afin d'obtenir le résultat que je souhaite. Après avoir lu plusieurs articles, je dois normalement avoir accès à l'outil "Gestionnaire de noms". Il doit se trouver dans la partie Formules mais je ne le vois pas. Quelqu'un pourrait m'expliquer à quoi serait-ce dû ou bien une autre méthode pour ce que je cherche ? Merci d'avance.
Excel - percentage
Hi all, I've got a table with some data where few columns are different percentage. I am pasting this percentage every month from my source where are these formatted as numbers. So for example I have 45 in my source and want to copy that and paste it to my excel table as 45%. However, when I do this it displays as 4500% Is there a way how to paste it as a 45% without the need of formula or changing the source to 0.45? Than you for any advise
Excel - Enter Numbers in a column
Excel VBA macro-Need help to correct macro-number rows in a column I am a novice on this site and Excel VBA within macros. Trying to finish the macro without errors. Using pick button to run the macro. Fill in the yellow column with quantity, math is done with columns B10*G10= in H10 Go to the Next sheet Move all rows which have B column greater than 0 - all works fine Start of macro works fine - remove all blank rows if Column B is blank. The problem is to renumber column A rows after all blank rows are deleted. This is what I want the result to be: Here is the current macro: Sub Button1_Click() Dim LastRow As Long, Firstrow As Long Dim r As Long With ActiveSheet Firstrow = 10 LastRow = .UsedRange.Rows(.UsedRange.Rows.Count).Row For r = LastRow To Firstrow Step -1 If .Range("B" & r).Value = "" Then .Range("B" & r).EntireRow.Delete End If Next r End With 'These attempts give me errors or just doesn't work '___________________________ 'With Range("A10:A" & Cells(Rows.Count, "B").End(x1UP).Row) ' .Value = Evaluate("Row(" & .Address & ")") 'End With '___________________________ 'Range("A10:A" & Range("B" & Rows.Count).End(x1Up).Row).DataSeries , x1Linear '___________________________ 'Range("A10).AutoFill Range("A10:A" & Range("B" & Rows.Count).End(x1Up.Row), x1FillSeries End Sub Can't seem to paste. Will attach file. Note: Excel version 2010 Thanks in advance, from Frustrated
New sheet tab creation issue
There are 15 tabs in the excel sheet( it is an already saved excel sheet on the desktop as ABC.xlsx). Out the 15 sheet tabs, i have deleted sheet4,sheet6,sheet11and sheet 13. Now my sheet selection is on sheet2.when i click on new sheet option(+) the new sheets created are sheet4,sheet6, sheet11 and sheet13, i want the new sheets to start from sheet16 instead it is creating all the old deleted sheets first..why?vlookup to search mulitple criteria and return the entire rows data
I am creating a couple of documents. Firstly a summary of all data for the whole business based on an agents quality. There will be headings such as name, team, date, etc on the Summary sheet. I am looking to then from a separate target sheet (individual Agent) to search the summary sheet using vlookup to search multiple criteria (name and date) to then pull that whole row of information across to the target sheet. I've search and attempted multiple formula's but am unable to get 1 to work. Has anyone any ideas for an excel novice please. Thanks.
Custom Sort list Exceeded, macro has too many line continuations, please help
I have a spreadsheet that creates a table and copies hidden forms to their respective items as individual tabs, there are sometimes support forms which have been labeled with a connecting A-D. I would like the Table of Contents to sort column A items 10,10A,10B,10C,10D,20,20A,20B,20C,20D,30 and so on. I have tried bring the list from the "sorter" tab in through options but got cut off around 880A mark. I amended the SORT Macro but got a line continuation error. I am doing this sort for 10-5550 with possible A-D available for each. Any way to make this happen?
