Macros and VBA
6485 TopicsMacro buttons not working
Hi, when I try to run a macro using its buttons, the buttons do not respond, animate, or function. Often a box will hover above the button containing its text, and when I am able to click on the box the macro runs; however, the buttons themselves are completely non-responsive. I can run macros successfully from the quickaccess toolbar.182KViews0likes19CommentsHave multiple CONVERT cells update when any one cell's value is changed
I want to create an excel document that helps my team set correct parameters (Max feed rate, acceleration, etc...) for various CNC machine controllers that use different units of measurement. I know the formulas, and understand how CONVERT works, and can set it up so that, for example ## "/min in one cell converts to ##mm/s in another. What I would like to do is have this work so that when any of the cell values are changed all the rest of the related cells update accordingly based on the conversion applied to their cell. For example, depending on the machine and controller, I can have axis accelerations presented in four different units: mm/s^2 mm/min^2 in/s^2 in/min^2 I would like to be able to have all four of the above cells be populated with the correct acceleration value, and when any one of the four is updated the remaining three cells are all automatically updated to reflect this change. My initial research shows I will likely need to use Macros/VBA, but I have yet to come across an example use case similar to mine. I would appreciate knowing if this can be done, if I am on the right track with using macros, and any suggestions as to how it can be accomplished. If I can get it to work for the above example I feel I can take that experience and apply it to the other parameters. Thank you, Tom60Views0likes3CommentsTwo lists of transactions. Want to create one large 'combined' one.
I have a workbook which I use for tracking transactions across two bank accounts. Each account has a separate 'ledger' sheet which lists all the incomings and outgoings. I want to create a third sheet which shows the entries of both accounts in one combined ledger. I would like it to be sorted by date and to have one column to indicate which account the entry is coming from. This is a link to a a dummy workbook with three sheets: Combined, Account 1 and Account 2 so you can see what I mean. https://1drv.ms/x/c/eea13e24843cdffd/EdNz2TLk0hJEueH-abYJF6ABxp69AS5eU0NqCOG4vlZAXQ?e=iYZ2Do If this is possible, please could someone with better skills than me please advise! Thanks!73Views0likes3CommentsMacro to copy
Hello all you "Brilliant Minds" here is a chance to prove your "Excel-ence. I want to copy a value to one cell from the source which is random and as I haven't a clue about this stuff I asked Microsoft CoPilot. Being on the 4th version Where Microsoft excel still will not accept Microsoft CoPilot's creation, I am appealing to the Community. So here is your chance to prove that you are smarter than CoPilot. Here we go, everything but attach a file. If anyone is interested send me an email so I can send a couple of small files. Donald67Views0likes2CommentsWorking with workbooks shared via Teams/Sharepoint
Hello Excellers, I need some insight on an issue that I am not sure what the source is... A) We sometimes share workbooks via Teams. You know when you are in a particular chat and next to the name of the chat at the top of the screen you see Shared and then you see Files button a bit below the Shared menu and when you click on that Files button you will see a list of what workbooks are shared. B) So I wrote some VBA code to download a copy to the Downloads folder like that: Dim RetVal As Long Dim SharePointFileURL As String Dim LocalDownloadPath As String Dim FileName As String RetVal = URLDownloadToFile(0, SharePointFileURL, LocalDownloadPath & FileName, 0, 0) If RetVal = 0 Then MsgBox "File successfully downloaded to: " & LocalDownloadPath & FileName, vbInformation This will message be replaced by the code we need to run... but for now I needed an indicator that it finished downloading. Else MsgBox "Failed to download the file. Please check the URL or your network connection.", vbExclamation End If So RetVal is = 0, and I do see the workbook in the \Downloads folder and it has a size of 4KB and the correct Date Modified time stamp, BUT When I try to open the workbook via the Excel desktop application I get the message: Excel cannot open the file "File name here" because the file format or file extension is not valid. Verify that the file is not corrupted and that the file extension matches the format of the file. The workbook should be 34KB in size and that 4KB file is not what I need??? Any ideas how to manage this, saving a workbook from a SharePoint / Teams file location to the computer so that we can run VBA code on it. GiGi107Views0likes4CommentsCompile Error
I regularly create CPRs using Excel. This has always worked just fine, then the other day it suddenly stopped working and Excel gave me the following error message: "Compile error in hidden module: cpInterview. This error commonly occurs when code is incompatible with the version, platform, or architecture of this application. Click 'Help' for information on how to correct this error." I did click "Help" and a brief article popped up that did not help me resolve this issue. I don't understand why my report worked one day and then suddenly didn't work the next day. That makes no sense to me. I contacted Microsoft and they were completely useless, said this wasn't in their scope and there was nobody who could help me from their end. That also makes no sense to me since this is a Microsoft issue, but they told me to post in this online forum to try to seek help from other users. Does anybody know why this error suddenly happened and, more importantly, how to fix it??? I heavily rely on the CPR function to do my job and this is causing me a lot of hardship. I have Microsoft Office Home 2024 running on a Windows 11 HP Laptop. Thank you!56Views0likes2CommentsI need to learn how to use the LET function in Excel...
Hello Excellers, I am using a complex If statement to figure out if a machine is ready to receive work. I need to check if the machine is online, or broken down, or off line for some reason or another, Has a Human worker to work on the machine, and on and on... I am thinking would a LET function help in making the IF function more accurate, and less complicated? I have not worked with the LET function, and I think I would like to learn about it. Any nice resources for examples and tutorials? Thanks in Advance! GiGi!95Views1like4CommentsAs any one found cool icons to use on a Custom Ribbon?
Hello Excellers, I just finished making a neat custom ribbon for an application, and I am wondering if anyone has found a cool and neat place to grab some icons for the button faces specially if in color. My ribbon looks nice, and most importantly it works as intended, but I am kind of thinking it could be more colorful. So far I only used the built-in stuff. Thanks for any hints. GiGi95Views1like2CommentsMS Excell application for Client database working under Windows XP.
Hi all, In my company we have a MS Excell application for Client database working under Windows XP. For Windows 10 it wrks now under a virtual box. I want it to work with Windows 11! How is the best and efficient way to do that? Hope someone can help me out. Thanks for cooperating. Eric70Views0likes1CommentWinFix Toolkit (All Windows 10 & 11 Repair Tools in One Excel)
After I published this small information tool (Excel (365 & 2016) with network information), several people contacted me and asked if I had a tool with Excel for general service tasks that, while available in Windows, are a bit scattered and confusing. So, I've prepared this small tool for Service Level 1, with most of the service options included. Hardware Repair Tools Repair Action Label Description Reset Windows Update Components UpdateReset Stops related services, renames cache folders, restarts services. Check System File Integrity (sfc /scannow) SFC Scans and repairs corrupted system files. Check Disk for Errors (chkdsk /f /r) CHKDSK Scans hard drive sectors and attempts repair. DISM Health Restore (dism /online /cleanup-image /restorehealth) DISM Repairs Windows image and component store. Network Reset (netsh int ip reset, netsh winsock reset) NetReset Resets TCP/IP and Winsock catalog. Flush DNS Cache (ipconfig /flushdns) DNSFlush Clears DNS resolver cache. Device Manager (open) DevMgr Opens Device Manager for hardware inspection. Software Repair Tools (examples) Repair Action Label Description Microsoft Office Quick Repair OfficeRepair Launches Office repair tool (Quick or Online). Reset Microsoft Store StoreReset Runs wsreset.exe to reset Store cache. Repair OneDrive OneDriveReset Resets OneDrive client (onedrive.exe /reset). Windows Defender Full Scan DefenderScan Triggers Windows Defender antivirus scan. Reset Windows Firewall FirewallReset Restores default firewall rules. Reset Windows Search Index SearchReset Rebuilds Windows search index. Clear Temp Files TempClean Deletes temporary files and folders. Reinstall UWP Apps (if broken) AppsReinstall Re-registers all built-in Store apps. I hope it might be helpful to some people. The tool has been tested, but it could still use some improvements, so I'd like to ask everyone who has looked at or used this tool for feedback. I would appreciate any constructive feedback or additional suggestions. Happy Excel-ing! *My tool are voluntary and without guarantee! NikolinoDE I know I don't know anything (Socrates)199Views2likes3Comments