desktop

Good day, I am trying to figure out how to create a desktop link that activates a macro. I have a macro that runs everyday but I have to open an excel first to run it. Is it possible to just have a shortcut that activates it? Thank you

Hi all, I created a macro enabled workbook for one of the directors. Works fine in Excel 2007 which we use. he on the other hand uses Office 365. Placing the workbook on his desktop, the macro will not run from the button I created. We have set macro to run without warning and added the...

Hi folks, I have bee puzzling this one for a little bit now and can make excel do a few things. Unfortunately cant get it quite right. I want it to simply save my excel worksheet as a pdf to my desktop with cell E4 on the active sheet as the filename. The code below saves to desktop...

G'day Guys, Simple one. I'm running a large automation factory with vBA on 3 desktop machines - works perfectly. However I've been asked why not 1 (server or high powered desktop) with 1 keyboard/mouse. How would a virtual machine handle this? Any thoughts? What would you do if you were...

I am able to reach the remote desktop, but unable to find path to the file on remote desktop to copy the file from remote to my local desktop. Please help. This is what i have so far: Sub Connect() Dim retval As Variant Dim myid, mypw As String myid = InputBox("Enter Mednet ID", "MEDNET...

I can view an Excel workbook in full screen mode but when i exit full screen the workbook travels to a different desktop that is out of reach of my desktop. Because this problem is so strange I made a video to show what I mean...

Hi, I want to delete a file on the desktop but want to do it without specifying the \user\ directory. I'm using CreateObject("WScript.Shell").SpecialFolders("Desktop") & "\Docs.pdf" How do I designate the desktop as the directory to delete Docs.pdf from? Any help would be appreciated as...

Hi, I use an excel add in to import multiple .sas7bdat files into a workbook every week, sometimes more than once per week. I receive the files by email and if I could just dump them on my desktop and run a macro to import them to exactly where I need it would save me so much time. I decided to...

In my office there is an application that count my active hours and idle hours on my desktop. I want a code that send different key strokes, open files, mouse clicks so that my desktop remain busy all day long. Could someone please help me.

Can anyone help me understand why I am getting an error? I am trying to get my data from Excel to store in Access and my connection is not working. I am running office 365 and I want to have the files on my OneDrive. I started this on my desktop that is why my transit file I pointing to the...

I'll start by saying, I'm not good at all with VBA - but if you have easy to follow instructions that would be great A user of mine, has a spreadsheet with around 300 linked documents in a spreadsheet. The problem being, the documents are either on their own desktop, or a couple of other...

I have a Excel file saved on my desktop which has a macro to import csv from another file saved on my desktop. I would like to distribute my excel file to other colleagues which will have both files saved on their desktop. My Macro refers to my user and user name Users\123456\, therefore I...

Hi people, I have an excel spreadsheet. It gets all data from external source, and refreshs itself in every 1-2 min. I need to get desktop notifications when a specific column updated and changed in my spreadsheet while it is running and minimized in desktop. Excel version is 2010. I have...

I split my database and so far, it is working well, i.e., no more conflict messages, however, I do have one issue I need assistance with. There are some MSWord templates that I insert text into using bookmarks and the code finds the files by getting the CurrentProject.Path. This was fine when...

For a split database, do each of the users have to have a copy of the front end on their desktop or can they all just use the one in the shared folder? I'm concerned about each user having a copy on their desktop as each time I make a change to the forms, queries, reports, and code, they have...

I created a macro that opens 4 workbooks (named Qtr 1, Qtr 2, Qtr 3, Qtr 4) from a larger workbook with 8 sheets. I run code in each book and then I would like to close and save each one but I can't get that part to work. for the people who share the file with me. I can only figure out how to...

Hi- I am trying to auto update data inputs from OneDrive excel online to my desktop. Essentially- I operate a model on my desktop that has historically used manually inputed data on a per project basis. I am now in need of a way to pull the data from an online source automatically as the...

Hello everyone, I am faced with challenge of finding a way of making dynamic table for our companies reporting. And not sure if the capability I would describe below is possible in power pivot. Any help is very much appreciated !!! I have a data like this Device Metric All_pages Empty...

Hello Can somebody please help me with a vba code to perform the below function in excel. I have 7 excel workbooks/files on my desktop and I need to copy 10 specific cells each from all those files and collate it on a master file. Cell numbers are : J11, k14,h78,d34,g56,t67,r56,w23,t45,c45 Now...

Hello. I am trying to create code that copy and pastes information from sheet 1 (the whole sheet) of an xlsx file, we'll call it "Workbook 1", located on a users desktop (could be any user, but will always be on their desktop), into sheet 2 of a different xlsx file, called "Workbook 2". The...