Search results for query: *

I have this working in Excel, but would like to make it work in SQL Server Reporting Services. The idea is to have a grid. You know the old saying, a picture is worth a thousand words? Well, here is what the working version looks like in Excel right now: Each of these blocks is a value from...

I must be forgetting something, but I figured I'd post online to see if any of you hear can clear the mud off my eyes. For a process used by various Excel files, I want to say something like: When they update a cell within Range1, a query runs, populating various cells. A new item I'm adding...

I've seen this since I began working with my current employer. We have a large set of Excel workbooks which mostly use code stored in one shared .XLA file on a file server. In 99% of the workbooks, this NEVER happens, even though they all use the same or similar functions stored in the .xla...

I've already used this for other formulas/functions with no issue, but the INDEX and MATCH issue is bugging me. Either it's just not possible or I need to do it somehow differently. The setup is for an Excel workbook where the data range is split over two sections. The reason for split is due...

I'm trying to replicate some formatted text for an old letterhead for which no one has the original source. I found some instructions for what sounds like may work for one piece of my puzzle here: https://word.tips.net/T006763_Adding_Horizontal_Lines_at_the_Sides_of_a_Word.html Only problem is...

I probably just am just going a little batty at the moment. Surely there's something real simple I'm missing. If anyone has an idea how to rearrange my logic or hit me up side the head with a brick, I'll take any "help". [smile] We have a CSV output file that I need to keep a portion of the...

This is more a general question for anyone who has gone through this process. I'm the IT Manager now for a small business, and I'm now working through moving our email and a couple other items to the mailbox plans for Office 365 with plans to move everything Office-wise there around mid 2020...

I've only barely dabbled in C# off and on a couple of times over the past say 10-15 years. In my current role, we have an ASP Intranet site built by a previous employee that is really just a C# app for internal usage. This tool has just done its job for the past 8-10 years I suppose...

I like the idea of one called SpiceWorks. I somewhat like their network scanner and the helpdesk seems like a pretty good tool... in theory. In practice, I have found so far that it doesn't really feel stable, and it runs super sluggish, and I've not created any real tickets. Does anyone have...

For my church, I'm in process of putting in a "new" PC - not new, but new to us. I want to talk about the 2 options of RAID, and consider whether it's worth bothering with at all vs just backing up from Drive1 to Drive2. (Yes, RAID is NOT Backup - go ahead and get that out of the way). [smile]...

First, I imagine if SkipVought sees this, he'll probably remember some time 10 years ago that he told me about one of them, and say, "I told you so!" [wink] So I got to thinking about how the other day, Skip mentioned to someone about the Watch window, and pointed to an FAQ he had put together...

We have a centralized XLA file that is referenced by VBA in several different Excel workbooks. For some reason, though, the formulas end up forcing a link to the same file where we already have a VBA reference. This doesn't happen all the time, but just so far in a couple of cases that I can...

Outlook has the manual and auto archive options. Auto archive lets you pick one specific file location to archive to. Manually, you can archive whatever you want to whatever folder you want. Right now, we have a mailbox which I have to check on occasion, and I need to manually archive the...

Does anyone have any experience with the "new" NUC (Next Unit of Computing) devices in a business environment? https://www.intel.com/content/www/us/en/products/boards-kits/nuc.html I found them when looking for other future computer options at work, trying to bridge the gap between small out of...

Where I work, we have an "application" which is a series of Excel workbooks and a couple (different groups) shared .xla files where much of the VBA code is centralized. Is there a way to tell any workbooks which link in the .xla file to automatically open the .xla file in read-only mode? I'm...

About the time I began considering playing with Raspberry Pi boxes, I begin seeing various articles come out about all sorts of security threats for Raspberry Pi. Are there any generally fool-proof methods of securing these devices when connected to the Internet? Some ideas I'd like to...

I built the below as a tool to automate some data entry for multiple workbooks at work that references the same centralized .xla file for some custom functions, etc. The code worked perfectly when I initially build the range checking and initial value checks into the worksheet object, but once...

Does anyone have experience creating a log file to centrally capture all error messages that users may see in a shared/network environment? We have a somewhat complex, somewhat convoluted (I'd say) "system" here that is basically a series of MS Excel workbooks that mostly use the same central...

So we have a special need at work: new laptop to replace failing laptop running Windows 7 32 bit (runs older 16 bit flaky software, connected to sensitive hardware). If I purchase a new Dell with Windows 64 bit Pro installed, can I just install Windows 7 32 bit, like I would going going from...

I've been using VBA to get things done and automate tasks for myself and others for many years now. I started a new job at a different employer last Summer, and there was little to no documentation on many of the tasks I do here. One of the things that has the least amount of documentation for...