windows

Hi, I would like to have a code that copies a string to the windows clipboard using VBA. So i can paste the clipboard to other software then excel. My code is now the following: Dim strText As String strText = FilePath With New DataObject .SetText strText...

Hello - We are working on a CRM data migration project and I would like to insert a carriage return to create separate rows from a text string in excel. The export from the old CRM did not maintain the format of our notes, and instead can only export into a continuous text string. I would like...

From another thread, a MVP offered a solution which gives you UTC time in a cell. A user defined function similar but different than now() It works flawlessly on my windows workstation, but presents a value error on my Apple Mac Workbook. Microsoft learn has not revealed why or how to fix it...

Hi there, What could be causing the VBA code to malfunction on Mac? Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range, cell As Range Dim lastRow As Long, lastID As String Dim initialPrefix As String, newRowDetected As Boolean Dim existingIDs As Object...

I built a UserForm on Windows, and for Windows, but with the intention of it ultimately working for Mac. I can't find many resources on developing UserForms for Mac, so I'm hoping I could get some suggestions as to how I could build a working Mac version. Here is a link to my Worksheet...

I've written a macro that begins by asking the user a yes/no question (see below). I have no problem running it on my Windows machine, but my boss is on a Mac and receives a Run-time error 6: Overflow error message. When he debugs, it points him to the If AnswerYes = vbYes Then line. The error...

I am new to VBA and have found several solutions to creating a form control button that works on Windows OS. currently, it is able to work on my personal PC as well as co-workers using Windows OS. Where I have run into trouble is getting this to work for co-workers using a Mac device. Any help...

With help from Peltier.com I've put together a sub which shades under two excel scatter plots using freeform shapes and filling the shapes. The sub then copies the chart and the 2 associated shapes to be used in a word document. I would the sub to delete the shapes and leave the chart so that...

Hi Everyone, I know how to change the audio volume level setting using VBA by sending the VK_VOLUME_UP and VK_VOLUME_DOWN codes to the virtual keyboard, but my code also needs to know what the actual level is. I've been trying to persuade The Google to tell me but haven't even got as far as...

- OS : MacOS and Windows (tested on both) - Excel version : 16.64 - Issue When I do SHIFT + drag & drop a column within an Excel Table (it's NOT a Pivot Table, it's a normal Table), it will mess up with the column widths. It doesn't behave like this when it's not a Table. - Screenshots of...

Hello, For Excel files - what operating system is best to use between Windows and iOS?? Which system uses the best software/ application to detect viruses better? With all of the online tools available with downloads for excel templates / word templates etc. - how do I know what is actually...

Hello, I am using excel 2016 and trying to create ta formula that will return a certain value based on multiple criteria. I have set out the logic below but everything I try doesn’t work :mad: if(and(a1=“Green”,a2<>”-“),”Good”,”Bad” if(and(a1=“Amber”,a2<>”-“),”Good”,”Bad” if(and(a1=“Red”,a2...

Hi there, I'm working with a data sheet and am trying to get the Nth largest value in a specific column based on multiple criteria. My single criteria formula works fine, this is it: ={LARGE(IF('Sheet1'!C:C=3,ABS('Sheet1'!W:W),""),1)} However, I run into the #VALUE! error once I add another...

estamos a punto de migrar nuestro servidor de Windows 2012 a otro servidor de Windows 2016, luego necesitamos copiar solo los datos cambiados diariamente del servidor de 2012 al servidor de 2016 ... por lo que estamos buscando una herramienta confiable que haya sido probada por otros. mi colega...

I have a folder with many pictures named as number.jpg (ex: 100152.jpg, 100153.jpg). I don't want to copy everything in this folder— only the files with the exact name as the names in a txt file that I have created. I am using this in the prompt. However, all pictures from SourceFolder are...

I have lots of Excel VBA applications developed on PC for the Windows platform (over the past 20 years). I have lots of trouble recently after Windows update - system very very unstable. I am thinking of ditching the Windows completely, and move all my development to iMac. Question: 1. Can...

Dear all, I have made a vba macro code to get date from Excel cells in a special format to be used for follow up. ActiveCell.FormulaR1C1 = "=TEXT(RC[1],""ÅÅÅÅ-MM-DD"")" ActiveCell.FormulaR1C1 = "=TEXT(RC[1],""YYYY-MM-DD"")" In Sweden, Windows regional date format is ÅÅÅÅ-MM-DD. The letter Å...

In our SAP system, we have a mass attack tool. There is one point at which my VBA cannot control the SAPgui anymore, it's when the "Select Files:" window appears (see screenshot). Yesterday I got a solution on how to find this window from a good man here in the Forum. The macro gave me all the...

I'm on Windows 10. When I'm working in Excel occasionally my screen starts flashing for about 1 minute (no pattern to when or why it happens ... it just randomly starts). During this time I can't click into any Excel cells or do anything in Excel. The other applications on my computer work fine...

Hi All, I got to this forum after wondering the net for a solution to my problem, it's a little bit complex, I'll try to simplify it. I'd like to open specific ext. files (.SCF) on my windows system with specific excel file located in specific path on my pc (let's say C:\TEMP\SCFParser.xlsm)...