Search results for query: *

Hiya, Like most bits I work on the user has an excel document that they want to keep working with. Essentially there will be a manager’s excel workbook where they populate data, then there will be user workbooks that will pull data from the manager workbook, amend column data then push the...

Turns out it is possible Regards J.

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

Yeah that is what error handling is for, however as I am building it for a client, who has a client who is trying to sell to many clients I am trying to prevent as many issues as possible as there is a big chain for issues to be passed back along. Ideally my error handling on this would involve...

If I had full control over the users system I wouldn’t be coding this using word, excel and VBA. I’d have made it a fully contained .net app however like most systems I end up working on or building I am at the mercy of the user. The file system with permissions would have been ideal if I could...

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

And solved the problem....I had to set the FlatScrollBar = false after populating my list Regards J.

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

So to add some more clarity when i click my generate button using SaveCopyAs i get a new file generated with .xlsx extension. I try to open it and it tells me Excel cannot open the file because the format or file extension is not valid. that uses: ActiveWorkbook.SaveCopyAs baseFilePath &...

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

Cheers for the advice combo, definitely food for thought. Although I’ve been doing bits of VBA for quite a few years it still feels like I am just scratching the surface. Regards J.

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, The reason for the ";" is that I use a listview with checkboxes for the user to select a choice of codes, this then populates the textbox. The ";" separation means I can display them to the user in a format they are familiar with and can display a vast number of codes in the single...

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

Cheers Skip, Once again you have saved the day. Many Thanks J. Regards J.

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 Skip, This the combobox is on a userform. There is no data validation setup for the drop downs Regards J.