drive

I have no idea if this is even within the realm of the possible, but if it is, I have no doubt you folks would know. I drive for Lyft, the rideshare company, and I drive between a couple and 20 rides per night. Lyft publishes (after several clicks to drill down) data for each ride that I'd like...

Hello, Is the below example possible? I've been able to determine how many people live within a certain distance (in miles), thanks to this board (thank you!), but now I'm looking to determine how many people live "within a 30 minute drive", using lat. long. coordinates as the reference points...

Hi folks tried this: Workbooks.Open Filename:="\\FS01\1300Shared\Marketing Folder\scorecard.xls" Error: Sorry we couldn't find \\FS01\1300Shared\Marketing Folder\scorecard.xls. It is possible it was moved, renamed or deleted. Also doesn't work using the Drive letter Workbooks.Open...

I am writing VBA code that has to interact with a .dll file named master.dll which will be located on a USB memory stick (for example possibly drive E: F: or G:. In each case the subdirectory where master.dll is located will be in a subdirectory called Tickets So the .dll file can be any...

Hi everyone hope you can help. I have a master spread sheet that is copied into different files that gets stored in say in G drive. So this master spread sheet over time can be copied and stored up to 200 times. Thus 200 copies with different names stored in 200 files under G drive. Eg master1...

OK, so I am trying to perform an action on Hours:Minutes in which climb higher every day. What I am trying to accomplish is better shown than to use words, but I will try both. Ok, so in words, I drove a total of 110 hrs and 30 minutes (110:30) thus far. On Monday, if I drive 5 hrs and 30...

Hi all, im new to macros and was hoping someone can helpme. I need the macro to archive a sheet and store it in my H drive, can anyone help me?

I want to put my data.xlsx to my website Now my PowerBI can get the data by web. However it does not have security. What is the protection I can implement ? It is not sensitive data but still I want some kind of elementary protection What can we do ? By the way, any chance for PowerBI to get...

Hi all, I've done a fair amount of searching and trying different methods myself; however, I am unable to map a drive letter to a local folder on my machine. This thread shows how to map to a network drive, and it works well for actual network locations...

I'm wondering if having a more current version of Excel uploaded onto Google Drive will affect the functionality of what can be done? For example, if I have a file created in Excel 2016 and upload it to Google Drive, will I have more Excel features/functions than if the document was created in...

Our network has become very slow so I need to work with local files and I cannot trust the user to copy the files. The server is a SharePoint server and the url starts with "\\sps.global." FileCopy doesn't work so has anyone got a solution that will work? I have looked for hours and tried...

Hi all I have excel file that a little computer can open it, according to HDD serialnumber (C:\) Code belove can't run, please fix it. I'm not good at VBA code Thanks./. Private Sub Workbook_Open()Dim oFSO As Object, drive As Variant, driveC As Variant Set oFSO =...

Hello, I created a macro enabled template and saved it on our company's share drive so everyone can access it from any desktop without having to send the VBA code to everyone, not all of whom would know what to do with it. The template works fine on my desktop, but no one else can get it to...

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...

I have a file that saves everyday at 1am. It is locates on a network drive in a specific folder. I cant figure out why it saves to the drive and saves to the local PCs documents. Sub sveWrkBk() Application.DisplayAlerts = False ActiveWorkbook.Save Application.OnTime...

Hi all, I am trying to create invoices for some freelance work I am doing. Here is my plan: I plan to create a document in Excel that will have a starting Invoice number. I will have a button to generate an invoice, auto incrementing the invoice number each time, and then saving the file as...

Hi Guys, Need a code which list the full file path of all folders, sub folders and files held on a shared drive and writes the results within excel. So basically everything stored on the drive. example: Column A C:\new folder\test.doc C:\new folder\test2.xls etc. There are a lot of files on...

I have an Excel file that is saved in a shared drive location and is accessed by my team members who have access the shared drive. The shared drive is always up. I want to have a VBA code in the said file which could take backup of the said file every day at 8 PM in the evening at a specific...

There is MS access database placed on Citrix environment and i'm trying to Map the network drive but getting error message. Path = \\abcd365.sharepoint.com@SSL\DavWWWRoot\sites\CommunicationDev\test_tree\test\test1 I'm using the below code to map it....but getting error message. Set objNet =...