Search results for query: *

Hiya, can anyone tell me if it is possible to have a master excel workbook that can be updated via vba with ado/sql? I know I can read from the master workbook using another workbook and the ado connection but I can’t remember if the updating records was still available. Basically I will have a...

Hiya, Wonder if someone could offer a little help. I have the code below that i am running from a userform in Word 2019. it kinda does what i want in the fact that it puts all the documents in to a final document....however it is putting them in to the document that has the userform, however i...

Hi guys, I am building a document generator of sorts that uses MS Word as the front end with a userform and Excel as the backend for some of the data. Due to the way the data is laid out I am able to query the data using ADO. What I am wondering is if it is possible to have images stored in...

Hiya, Just wondering if anyone can help with the following....I am adding a custom tab to my excel document, this is done by using the customUI editor. What i am wanting is to generate a copy of my workbook without Macro's. This works fine until i added the custom ribbon in. The ribbon xml...

Hiya, I am adding a userform to an excel document and on said userform I have a list view control set as lvwReport. I have set FlatScrollBar = true. I loop through my excel range and add items to the listview, it all works except that I don’t get a scrollbar to move down the listview. I can’t...

Hi Guys, I am working on a project where the user fills in some data on an excel document, clicks a button and it should generate a report which is practically a copy of the ActiveWorkbook. The issue I am facing is when I use ActiveWorkbook.SaveAs filename.xlsx,51 it’s not actually creating a...

Hiya, I am doing some data manipulation in Excel, reading files from a folder and updating a masterfile with the data. I have this working as it's quite a straightforward piece of work. in my source document I have data listed vertically as an example it might be Title | Value Name | Jason...

Hi Guys, I’m looking for a little help with hiding rows of data in excel. My user wants a VBA userform that has X number of buttons on and when clicked it filters the worksheet so that only certain data is shown. I have this working at the moment. Due to the nature of the data certain sections...

Hi Guys, I am building a form in Excel that has 2 textboxes that hold values separated by ";". What I am wanting is to read each of the textbox values and store them as arrays, then to combine them in to a 3rd array whilst removing duplicates. What I have so far doesn't seem to work for...

Hi Guys, I am building a userform to deal with creating a rota. What I am wanting to do is let the user select a start and end time from a dropdown list then when they click a button it will populate the worksheet as follows Person 1 start time = 08:00 end time = 09:00 Person 2 start time =...

Hi Guys, I have a table in Excel 2013, that has 2 columns (Team Lead, Team Name) I am using the values from Team Lead to populate a combobox teamLeads.List = Worksheets("Sheet1").ListObjects(1).ListColumns(1).DataBodyRange.Value what I am wanting is that once a value is chosen from the...

Hi Guys, I am trying to write some code to UnitTest some of my procedures in VBA and was looking for some suggestions on how best to improve my concept. Currently I have a UnitTest class that takes in a TestName,ExpectedResults,ActualResults and TestDescription, I am then adding these to a...

Hi Guys, I have created a worksheet and attached several controls on to it, I am then locking the worksheet so that you can only click the labels or textboxes I have added(all activeX). I have set this up so that if you click on a label or in a textbox another label on the screen shows helpful...

Hi Guys, I am creating a worksheet based for to help alleviate some issues with a current process and have hit a slight snag and thought someone might be able to spot my error. I have a button on my custom ribbon in excel which allows the user to Approve the form, this then opens a new...

Hi Guys, I am trying to create a dropdown list in asp.net using an enum as the data for the list. what I am wanting is to have the description set as the dropdownlist text and the value of the enum set as the value for the dropdown list. So far I have found two snippets of code the first gets...

Hi Guys, I am writing some login scripts to use at work and seem to be hitting a problem. I get the "There is a problem with this website's security certificate." What i am trying to do is find the link on the page and click to continue. Obviously this in place for a reason, however i want to...

Hi Guys, I am currently building an SQL generator that will spit out .Sql files based upon selections made in an excel document. I am using Excel as it is a great storage container for the changing values. In my first prototype i had multiple worksheets setup where my vba would call a...

Hi Guys, I am trying to create an Excel document to store a list of URL's that i can then run a macro on to populate them in to my Favourites Bar in Internet Explorer. I have managed to get this to work for placing the the urls on my Desktop and for placing them in my Favourites Folder, however...

Hi Guys, I'm looking for inspiration/help on a 'quick' project i have been asked to look at and was hoping to get some advice/help. The Task: Each month a report is downloaded from our PeopleSoft Database in to an Excel report. The report holds information about student fees. Each report has...

Hi Guys, I am using Excel VBA with ADO to build an SQL query to pull data from another Workbook...everything is working great except when I am getting data from multiple dates showing up and not just the date I am trying to query. The query is built from values that are captured from a userform...