computer

I have installed Excel 2016 on a new computer and when I run the following macro, the variable symBol does not accept the value GDX. It just shows "" as the value. The macro works fine on another computer running Excel 2013. <tbody> Sub RunBTSlong() Dim symBol As String symBol = GDX...

Hi each sheet in excel 2010 has 1M rows and 16K rows. If I open a sheet, are all columns and rows are open (saved in computer memory)? or excel opens few only and it will open more as we screw down. What i mean by open, is to create or reserve line in the memory of the computer. because 16B...

Hi I'm using code that allows me to update cell A1 with the current time every x seconds. However, is there any code that will take the computer time and update the clock when the minute changes over. Basically, I don't want the workbook saving every 1 second in order to make the time be...

Hi, I'm experiencing some problems with excel run times but only after the macro is run once after a computer is turned on (or restarted). The macro mainly involves opening multiple workbooks, exporting csv files, reading and writing data across workbooks. Every time I run the macro for the...

Has this happened to anyone else? I am using the same computer and version of Excel as I have when it worked previously. It didn't work yesterday either. My computer was updated over Christmas, but my colleagues are not having the same problem.

I just recently have been having Excel crashing a lot. And some times when I create new Workbook it gives the unsaved workbook the name: "Book1 Non Commercial Use Unlicened Product. But then other times this does not happen. I can find no consistency in this happening. Anyone have a answer...

Is it possible using an Excel add-in to force all new spreadsheets to only be visible or functional if opened on a company computer containing the company add-in? I am looking for a security method that would prevent company documents from being able to be run or used on a computer outside the...

Im tryng to use sumifs formula but its not working because both the files are on Dropbox on computer and when enter the formula from my computer its using the full path "C:\User\username\dropbox\foldername" and when someone else opens the file the links dont work because their path is different...

Hi All, I have some code running on my computer that is operating fine, but on another guy's computer, it gets hung up. on the Worksheet Change, I have this code (partial): Private Sub Worksheet_Change(ByVal Target As Range) Application.ScreenUpdating = False Application.EnableEvents = False...

Hi, I need to count a range of cells that are non blank and does not contain the text "COMPUTER". I can get it to do one thing but not both using =COUNTIF(D11:D43,"<>*COMPUTER*") Thanks,

Hi All.. When I use = TODAY or = NOW, excel shows the date based on the computer system. And as we know that function (Today and Now), will change and produce value according to the date on the computer I was wondering, is there a way to store actual date data even though the computer's date...

I searched the forum and saw several posts to this effect, but nothing quite had the detail or scenario I am faced with. I have a data dump that I get daily in excel. There are several columns I need to create a new report out of but I also am finding myself needing to do the same manual...

Hello all :) I have a problem with creating macro. I'm not familiar with VBA (unfortunately), but I think formulas cannot do the trick. The problem is that i have two workbooks, e.g. "Reference" and "Data". In "Reference" I have a list of interested computers and in "Data" I have a list of all...

I'm running into a strange problem, for many years I have used these excel macros and all of a sudden I started to receive errors that only appear on one computer. This macro and pivot issue doesn't exist on any other computer I have tried. So excel was uninstalled and a fresh clean updated...

Hey, I'm trying to figure out how to upload an image from my computer to a forum. Any help. Thanks

Hi Team I hope someone can assist me. I'm trying to get a vba or function going to search through 20k+ lines (only column A) for results like "Event" or "Event Management" and would like to know how many times it occurs (typically a Work note) the line of column A looks something like this...

Hello, I am getting a strange message when opening an excel file I am using MS office 360 and Windows 10, after a recent update to windows I upon opening an Excel file get the msg: Do you want to allow this program to make changes to this computer Does anyone know how to give Excel this...

Hi. I’m looking to replace our computer at the office. It is currently a Xeon processor with 32 gigs of RAM. We connect to a sql server that is located on site and the current Excel file size is 100 MB. I’m looking to get a very powerful system as we live inside excel numbercrunching. What would...

I'm trying to study a true/false test i'll be having. is there anyway i can input that into the computer so i can practice it.... and what is the code or where can i get it??? I am completly clueless on where to start