computer

Hi there. I have a "live" online spreadsheet on our company intranet (shared with clients) I have a parent workbook (with dashboards) that needs a second workbook (with calculations) to open in order to update all graphs. My code is: [VBA] Private Sub Workbook_Open() MsgBox ("For up to date...

Hi everybody, I have an Add-in that needs to be loaded on a single computer on our network for all users who log in to that computer. Is this possible? Or are the settings to load an add-in only on a per user basis? Thanks!

Hello, I'm sure this question has been asked and answered, but apparently my thought processes don't come up with the right search words. So, I apologize in advance. The problem is I have a new computer (actually, a new one that crashed and burned and they had to replace everything). I did...

Hi Friends, Well i appreciate your contribution and what you are giving to people, but im stuck in something about Excel. My problem run like this: After I have finished my work, i save it to my computer. And here is where my struggle begins! I want this doc excel file be accessed only from...

Hi, Is there a way to change the owner and computer name of a pdf, It sounds a bit dodgy but what I am trying to achieve is a set the properties so every pdf that is created so it uses a generic owner name and computer name of which will not be any users. I looked at chip pearson's .bas files...

I know this isn't an Excel question but something happened over the weekend where my computer won't restart. I get a message that there is something wrong with my C drive and it tries to fix it on the fly. However, I can a message that it can' be fixed and gives me some option. I do have the...

Good day, I am a bit of a neophyte but can follow most times. Right now the issue...I have a home budget program that works on every computer I own also those at work, but it does not work on my laptop. The error message I keep getting is "Could not load an object because it is not available on...

Hello - am stumped trying to determine what could be happening. I have created some code in ThisWorkBook, capturing a double click event in a particular cell. When double clicking, this code executes exactly as designed, no issues. I want to also be able to call this double click via a menu...

I have a simple macro that saves a sheet in the workbook as a PDF. It works perfectly on my computer but when I share with co-workers it doesn't work. It appears as though the ChDir is pointing to a path specific to my computer. Is there a way for that to be dynamic to the computer it's...

Hi all; I am working with a power pivot report with a table showing the sales of specific products, if the product was already delivered to the customer and the estimated delivery date. This is the table: <tbody> Product Customer name Delivered Estimated delivery date TV Susan Yes 03/15/18...

Can anyone show me a routine that will search an entire computer drive, (including sub-folders), and list all the files that match a criteria? The criteria will be 'Toolbox.xlsm' and I will need the results populated into a userform listbox so I can then move on to allow the user to select...

HI, I have a dataset that looks as follows: Computer Name | Number of Cores | Group Computer 1 | 2 | Group 1 Computer 2 | 4 | Group 2 Computer 3 | 6 | Group 3 Computer 1 | 2...

I've tried all the usual solutions. Checking if automation is on. cells are not set to text. Check for Circular References not an issue The strange thing is if I restart the computer it will sometimes work. Corrupt excel or something else?

Hi, My worksheet contains data about duration in [h]:mm format. But when the worksheet is opened from another computer the format does not hold. It changes as per the setting of that computer. But at the user's end those cells are locked and they are not able to edit the format. How do I make...

Hi, I need my Master Data Table to transfer Hyperlinks to Pivot table. I have seen lots of VBA coding, however not much for hyperlinking to computer files and not web links. Can anyone help me?

Entry <tbody> Admission Fee Security Deposit Tution Fee Computer Fee Total Amount Paid Date 25000 25000 20000 2000 72000 2/25/18 0 25000 11000 1000 37000 3/1/18 25000 25000 22000 2000 74000 2/15/18 </tbody> Report <tbody> Head Feb Mar Admission Fee 50000 formula required Security...

Hi I have one computer. I want to learn how to Share/Track changes in excel. I want to see how 2 or more users can share a workbook and make changes and then track changes. Any idea how to simulate that? I am thinking to save a file in Google drive but how can I create 2 different dummy users...

Hi Everyone, I have 2 worksheets first sheet has list of computers. second sheet has list of computers (same computers as first sheet) but also has their errors , this sheet consists of 2 columns: computer name, error message. I have multiple error messages per computer, some repeating per...

Hi I have created a VBA for someone else, and on his computer it seem to not be able to start the "Outlook.Application" and therefore no emails are created. When I test it on my computer it Works just as intended. We both run Office 2016, and seem to have the same Librarys activated under...

Hi All, I'm not sure this is possible... I have my private and work computer, and I would like to share the same contacts list. I use my work account as the "master", and from time to time, export the contacts as a .csv file. The file is synchronized to my personal computer via a private cloud...