computer

We have a N/w of 3 computers. The Access prog is on one computer and is accessed by the other 2 computers. The Appl. runs well on the comp. on which it is installed. But it is slow on the computer accessing it. What can be done for this?

When creating a hyperlinks for other users, upon looking further, hovering over the link it shows the directories, the file path of MY computer. i'e. file///C:\Users\User\Documents\Excel\filename.xlsm. No wonder I can't share it. Thanks, ~Jim

Hi All When settings like, View Zero Values are customized, will they be preserved when a user on a different computer opens the file? Thank you!

Hi, I have a several file that have a lot of formulas and worked fine before on another computer (older) and probably with a slightly older version of excel. When opening on my new laptop all of a sudden I'm getting circular reference error notices that I've not seen before and now my formulas...

Is there a way to use VBA to change the LOCAL ip address of the computer from dynamic to a static IP as stated in a cell in the sheet (i.e. 10.0.0.1)? Thanks

Below is my code and works perfectly. Only problem I have is if I email this "Temp folder" where this spreadsheet is located, you can see it will be looking for my desktop specific location on my computer. What I would like to do, and not sure if it's possible, is to write a pdf copy to...

hello anyone? I have a macro enabled wb (ConfigureData) that depends on data from a non-macro wb (DrawingData). ConfigureData has a formula to get data from DrawingData, and place the data into sheet1 of ConfigureData. Both wbs are in a folder named "ExcalDataConfig". When I run the macro on...

Hi all: I have workbook data.xlsm now I want to share to another one the same company and I want only computer with doman can open file Domian is: company.com This picture belove say: Computer name "PC-001" with domian "company.com" can open file Thanks./.

greetings oh learned people (seriously). I have created a macro enabled excel sheet named "Data", within this file is a macro to read and copy data from another workbook named "Drw", and paste it to sheet1 of Data. Everything works well on my computer,(comp1), but when I try to run it on comp2...

Hello, i run a daily macro to generate some reports using the excel VBA and SAP macro as well. I made my macro to run early in the morning without me, but every time i get in my computer there is an error when the macro tries to connect to the SAP, "the enumerator of the collection cannot find...

Hi most learned people. I have a formula in a worksheet that references the user and the computer name (in bold below) ='C:\Users\andym\Documents\ExcaliburDataConfig\ConfigPLANITData\[DrawingData.xlsx]Page 1'!B1 This formula needs to run on a variety of computers, whose user name and computer...

Hi, For the last 6 months on a daily basis I've read a text file into a Worksheet using "Open strFileName For Input Access Read As #1" etc, with values similar to the following: AAA;BBB;CCC DDD;EEE;FFF GGG;HHH;III Today, Excel crashes when: 1: Line 2 is moved to the start 2: Line 2 is moved...

I manage a team spreadsheet and there's a hyperlink to open a subfolder. It works fine on my computer and others next to me. My supervisor's computer though will not open the hyperlinked folder and gets the error message Unable to open ... Cannot download the information you requested. Why does...

Hi all. Our company have domain email and using this email log in to computer like: email: jhonny@abc.com, Jim@abc.com ... user only log in computer with ID: jhonny, Jim... Now I have excel file and want only user log in ID with "@abc.com" can open this file. How can I do this by VBA code...

Hi everyone! I've been struggling on and off for the past couple of days trying to find a way to come up with a solution to my problem with a large export of data I have. I will include some pictures with some arbitrary data to help explain what I have and what I'd like to do with the data, in...

I am getting a list of computer names every 8 hours, I am trying to find a way to when computers are added or removed <colgroup><col><col><col><col><col></colgroup><tbody> Computer name timestamp computer1 1/18/19 6:10 1/18/19 6:10 3 computer2 1/18/19 6:10 1/18/19 14:10 3 computer3...

I have a small .xlsm file which contains two simple macros and a VB module designed to return a 10-character hash from a character string using "=BASE64SHA1(A1)". I'm not skilled in VB so I simply found the code from a web site. The only mod I made was to set the length of the hash to 10...

Hi 1. How to send an email from an Excel sheet on a Mac computer? 2. How to send a SMS from an Excel sheet on a Mac computer? 3. How to send a SMS from an Excel sheet on a Windows computer? Wish you all a great new year from Denmark

The below code used to export to PDF saves fast on one computer and very slow on another similar computer. On the slow computer I use Foxit and not Adobe. Does that matter? Do I have to have Foxit as an add-on in excel? If I save the file manually using the menu and save as it seems to work...

Hi My computer OS is 64-bit, windows 10. My excel is 365. When I tried =INFO("OSVERSION") I got <tbody> Windows (32-bit) NT 10.00 </tbody> Why is that? thank you very much.