computer

A few years ago at a job I created a macro that would refresh a table and save the results to a network folder so it was ready to review when everyone got into the office. I was able to do this using Windows Scheduled Tasks. The one negative to this was that the computer had to be on and...

I frequently am working with workbooks with over 100k rows in Excel. I will filter for certain criteria and then delete the remaining visible rows which may be over 75k rows. When I use my desktop computer this take 3 or 4 seconds. When I use my laptop it can take 10-15 minutes of Excel...

Hi Team, I'm trying to search list of words in sentence, If that word is found in sentence return the corresponded search value. Eg : <colgroup><col><col><col span="4"><col><col></colgroup><tbody> Col A ColB ColC Col G Col H password is not working 1 D1 Searching Words Display...

Hello, The following line of code Area.CopyPicture Appearance:=xlScreen, Format:=xlPicture Doesn't work when the computer enters in standby mode. Can anyone help me? Thanks!!

I have a userform where I need to have the entire form visible on screen of any computer excel runs on. The size of both the form and the various controls/text in the userform need to be resized. This is something that I of course never considered as an issue, thinking excel would do this...

Hello everyone, I built an excel sheet where some formulas don't seem to be working on my new computer. Description of the workbook and its formulas: The workbook contains daily timesheets where the data is then compiled by job number on the sheets between "start" and "end" In the excel sheets...

I just received a new computer at work and in switching from Excel 2010 to 2016 some of my workbooks haven't fared as well as others. In one workbook that I use daily, I have several stacked area charts. All of the areas are gray with white borders. Even after I change the fill color, it...

HI so recently I have this code below which ends my macro. The vba I use below on my computer works fine and closes the active workbook and doesn't save it like its suppose. On another computer it started to break in red below. I can not figure out why I tried everything. I even removed that...

I was using many to one mail merge religiously until my work re-imaged my computer to Windows 10 and now i can't seem to get it to download on my computer. Can anyone help me and tell me what i am doing wrong? i go to extract the file into my App-data but the files i need are not there. Is there...

Hi everyone, I have this Workbook with several UserForms. The Workbooks is shared between 2 or 3 Computers simultaneously. It is shared using the old way not the cloud. One of the UserForms will work just like a Pop-up message in one especific computer. But, since it is just one workbook, I...

I have a .CSV that I pull from SCCM. I convert it to .XLSX and then begin modifying it. I try to create my own macros when I can, but I seem to be stuck on something that I hope should be relatively simple. The report has a random number of columns and rows based on the required output. I need...

Greetings, I consider myself a novice at VBA and am looking for some comments and suggestions. I am creating a workbook that I want to restrict to using on only two computers. I want to register the two computers on first use and when opening the workbook to check to see if the computer has...

Hey guys, I'm new to this sub. I tried to look for related posts first but to no avail. I created a userform with tons of (working) controls, uploaded to cloud and downloaded it on other computers. The file's main usage will be on the userform. The issue is, on most computers, the userform...

I've spent forever searching for a solution to this, I only found one other person with the same problem (here: https://www.mrexcel.com/forum/excel-questions/983275-xlam-not-available-excel-2016-a.html) but a solution was never reached. Any idea what would cause the option to save as an add-in...

Hi, I've encountered something, i have a userform with a text box and on every computer on my network it allows for Currency variable to take on the value placed into a text box. Public recSaleCheck As Currency Public machineCheck As Currency 'Puts the value of where the row and column...

Power Query From Table Range button greyed out after Aug update Dear Team, On both my home computer and now my work computer, after I updated my computer, if I have a cell selected in an Excel Table and try to use the Power Query From Table Range button, the button is grayed out and I can not...

I have an Apple Mac Computer with Excel installed on it. When I scroll down while in a spreadsheet, I am unable to easily stop the scrolling by using the mouse and/or touch pad. My question is: Is there a fix or a process that I can implement in order to better control the continual scrolling?

Hello All, Can someone please help me how to count specific words in a single cell using formula? Example cell A1 "My computer works fine. I need formula that would count the words computer and works. ​Thanks

I have written a macro to allow for embedding a PDF file into an Excel sheet. I want the icon for the file to show up in a certain cell. So far, so good, but I do have some questions. But first, my code: Range("AN5").Select ActiveSheet.OLEObjects.Add(ClassType:="AcroExch.Document.DC"...

On my home computer, I'm running Windows 7 and Office 2010 and at work we have Windows 10 and Office 2013. I wrote a user form on my home computer that opens as soon as the workbook is opened. Here's the problem, while the userform is opened I'm still able to open other workbooks on my home...