network

Guys We have a CMMS that its database is SQL Server. My intention is to retrieve some information that is already there and use it in my MS Access database for Issues management. I already setup a DSN to connect to SQL Server and works very well. I would like your tips and hints with the best...

I have a database and associated excel files which connect to each other through the office network when I am there, but I need to have available on the C drive of my laptop when I'm away and can't connect to the network. Could someone help me with VBA for macros that I have to open certain...

I am trying to open a document with vba. below is the code I have. while no getting a error message, the document no opening. I tried "o:" and \\dfs.com\root\ Dim Open_Aspect_Sheet_Check_Open As String Dim xWb As Workbook On Error Resume Next Set xWb =...

Hi I have had a constant size of my database for almost a year. Now suddenly my database have become very slow. First i thought it was my network since i got the files on a server. But running some test i get 50-70 Mbps. So it should not be a slow network. However, if i put my database on my...

I am new to VBA and have to complete a task for my manager about saving sheet as a pdf into sharepoint (if firstly can be done) which creates a folder at the location with the same name as the saved PDF and saves the pdf there.Now where it gets harder for me is at the location in sharepoint...

Hello, First I must say: I am somewhat new to creating macros and new to creating Excel Add-Ins. Question: I wish to deploy my Excel Add-Ins to certain other corporate users by placing the .xlam file on the network, and giving all users the directions on how to customize their own Excel...

Came across an interesting situation. when i have a network drive mapped by name (I.e. \\servername\share) i can open a spreadsheet with no problems. however, if the network drive is mapped by IP address (I.e. \\10.1.1.1.\share) it tells me the file is corrupt. Very odd i must say. This is...

Hey All I'm struggling with this one, I'm not even sure if this is an Excel / Access or a Network Problem. I've an Excel Workbook that I use to query an Access Database on a network drive. It's as simple as it comes and something I set up years ago. The Database has two tables, the Workbook...

Hi, I am creating an absence reporting dashboard. If an employee has an absence start date and end date that are more than 1 month apart then I am stuck. what I would like is to show how many network days by month they have missed. for example Start Date 28/01/2018 End Date 12/08/2018 I...

This is an unusual observation, so my apologies if it has been covered elsewhere. Previously when I opened any workbook that contained macros, I got a popup message requiring me to enable or cancel. This is still the case if I open a file on my C drive, but not a file I open from a network...

Hi All, Could someone help me with the below please. I've googled as much as I can but everything I try gives me error messages. I need my code to check if its connected to a certain network drive, if it is it will then save, it is isn't it will do something else I am testing it on an...

Is there a way that I can connect powerquery to one main network folder, then pull in any excel file that is in that network folders sub folders? I am trying to come up with a budgeting tool for my company, I want to give each cost center their own network folder that they can access to enter...

I currently have a workbook where all I need to do is have worksheet3 copied and that copy saved to a variable shared network location based on cell value. R3 = NY Example: :C/MyDocs/Book/NY - - -- file saved here with file name R3= GA C/MyDocs/Book/GA - - -- file saved here with file name...

I wanted to start and dabble with Neural Networks for Excel but at first glance I'm a little intimidated. Would anyone know if these is a site/Link for a Neural Network template in Excel? Thank you MM

Hi. I am having trouble with some VBA code that asks for an order number and then uses the order number reply to file a copy of a worksheet into a workbook on a network (rather than my hard drive). The code I have currently is this: Dim CurrentOrder As String CurrentOrder = Inputbox("what is...

I currently have a work book that the cells are tied to links from a PLC , and I have set the save function to every 60 min added in the work network location in the correct spot and also mapped the network drive and added the location into the trusted locations. I does not save automatically...

I want to open a file on a network ... so for example: \\networkname\c$\ This networklocation is username and password protected. Then run a vb script Delete the file or replace it with a emtpy csv file. How can I open the file with a VB Script (with vb code for the username and password)?

Hi, I looked around and could not find. Is there a way for excel to automatically email the file after it has been updated and saved while on a network drive?

Hi all Hoping someone may be able to help something I'm stumped on. We have a hierarchy file where the core data comes in a pipe delimited cell like below. network_CAR|subnetwork_GARAGE|subnetwork_DEALER|KMBINDIA|KMBINDIA_1|KMBINDIA_2|KMBINDIA_3 I need something that takes this and outputs...

Hi all, I've searched around and am mostly coming up with code to check for actual URLs that point to http sites. I'm looking for one that can run through my sheet of links that direct to other files and folders within my network, ensure they point to a link that can be opened, and return the...