Macro Security appears to be broken when docs are opened programmatically
Is anyone else experiencing this problem? It seems that when opening Word and Excel documents programmatically via the application object, macro security is bypassed. Its as though the security settings do not exist. E.g. create a Word dotm file or a DOC file with an AutoOpen macro. Set security to the highest level (disable without notification) then programmatically open the document. the macro runs. It happens in semi-annual channel 32 bit and 64 bit and both Win 10 and Win 11, Word and Excel. It cannot just a vba bug because we are also experiencing it with iManage documents when the opening is initiated from within the application. If anyone knows of a solution for this problem, your sharing would be very much appreciated.
All the macro parts are appeared as "{MACROBUTTON AcceptAllChangesShown}"
Hello. I am having trouble with my word format. All the macro parts are appeared as " { MACROBUTTON AcceptAllChangesShown } " after I opened a new reference style file from Endnote. I removed and reinstalled the office, but it didn't help. I am currently using Office Home & Student 2016. Need help!Assigning Macros in MS Teams Excel Workbooks to Buttons
Good Afternoon everyone, I have a workbook with a VBA Macro assigned to an Activex Control button. When opening the workbook I got an error message saying that form controls were not compatible outside of the MS Excel Desktop app. To get around this problem, I removed the Activex form control and inserted a shape in to the workbook which had the macro assigned. when the workbook is open in Desktop, clicking on the shape prompts the macro to run, however when the same workbook is open in teams, clicking the shape just selects it and doesnt prompt the macro to run. My question is: Are Macros completely incompatible with excel files hosted on MS Teams? And if they are, how do I add in a button or visual aid that once clicked, executes the macro? TIA Dan V
Power query refresh times out intermittently when pulling data from Sharepoint and Google Sheets
About 1 out of 5 times, Power Query in Excel will get hung up when pulling data from a .CSV or .TXT data file stored on our Sharepoint site.( I also have this problem at times when pulling data from Google Sheets into Excel via Power Query.) I have checked all the data source credentials in Excel and everything looks fine. In the lower right had corner of Excel, it will simply say "Connecting to datasource..." and then nothing happens. After 5 or 10 minutes or so, I can hit ESC to end the process. I am trying to run this process within an Excel Macro. The fact that it runs some of the time, but not all of the time leads me to believe that perhaps the issue is with Sharepoint itself. Hence, my posting to this forum. If I run the Power Query from the VBA Macro, it will throw a VBA error whenever it gets stuck when trying to pull data from the Sharepoint folder. Again, this only happens about 1 out of 5 times the Macro is run. Here is some of the M Code ( I replaced our company site name with XXXXXXX in the sample code below) for the Power Query that gets stuck, which is being run from a VBA Macro in Excel: Source = SharePoint.Files("https://xxxxxxx.sharepoint.com/sites/DataWarehouse", [ApiVersion = 15]), #"Filtered Rows1" = Table.SelectRows(Source, each ([Folder Path] = "https://XXXXXXX..com/sites/DataWarehouse/Shared Documents/ACT/Contacts/Sharepoint Reference/")), #"Events txt_https://xxxxxxx/ sharepoint com/sites/DataWarehouse/Shared Documents/ACT/Contacts/Sharepoint Reference/" = #"Filtered Rows1"{[Name="Charity Events.txt",#"Folder Path"="[URL]https://XXXXXXX.sharepoint.com/sites/DataWarehouse/Shared[/URL] Documents/ACT/Contacts/Sharepoint Reference/"]}[Content], #"Imported CSV" = Csv.Document(#"Events txt_https://xxxxxxx/ sharepoint com/sites/DataWarehouse/Shared Documents/ACT/Contacts/Sharepoint Reference/",[Delimiter=",", Columns=1002, Encoding=65001, QuoteStyle=QuoteStyle.None]), Any ideas why Power Query gets hung up Intermittently when pulling data from Sharepoint? Also, is there some code I could use in my VBA Macro that would tell it to skip the Power Query refresh step and move to the next step if it gets hung up? Thanks in advance for any help you can provide! MattCustom 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?Macros en Excel 365 HOME
Buen dia. Agradezco un apoyo a mi siguiente problema. Tengo Office 365 HOME.. estoy tratando de grabar Macros y realizo los ajustes y corre correctamente Pero el problema es salir del archivo y volver a abrirlo.. ya que sale un error siempre Y no se guarda la macro.. He realizado lo mismo con Office 365 PRO PLUS y funciona sin problema la apertura. Hay que activar algo en la licencia Office 365 Home para grabar macros o NO ES POSIBLE! GraciasWorkbook_Open() fails to open
I built a macro that uses the function Workbook_Open() and then executes stuff which, as I understand it, should kick off as soon as the spreadsheet it opened. I've saved the spreadsheet as .xlsm and I can run the macro manually but it doesn't run itself when the spreadsheet is opened. I think the spreadsheet was originally created using 2003 and I'm using it in 2010. Could that be the problem?
Show filtered data in one spreadsheet clicking buttons in another
Morning, champions! Two spreadsheets in one workbook. In one spreadsheet I have thousands of rows. I have identified about 350 groupings of these rows and by clicking one of 350 corresponding links in an accompanying index spreadsheet (in same workbook) I want to show only the filtered rows in the first spreadsheet. I imagine I would tag the grouped rows with a numerical identifier. However there may be occasions where the same row falls into different groupings of rows so I don't know if this kind of straightforward identifier would work. Desired process User selects index spreadsheet Finds required story ID Clicks corresponding link or macro button Original spreadsheet appears automatically filtered to display only rows corresponding with Story ID. Is this possible? Or could the desired data simply appear in third spreadsheet that would in effect act as a view of filtered data? Thank you so much.
