Issue So I have a spreadsheet with a bunch of sheets that list names in the first column. On one sheet, the Input sheet, I have a command button that opens a Sub that prompts the user to perform a
Continue readingTag: excel
[SOLVED] Excel DateTime is a string how can I convert to real datetime C#?
Issue The way my excel is formatted when programming in C# and I pull the cell with the supposed date I get a string "44165". On Excel it shows as a date. I need to convert this to DateTime to
Continue reading[SOLVED] Simplify vba code with lots of repetitive operations
Issue I’ve created a userform with a large number of textboxes and tick boxes. When the userform is initialised, data is loaded into the textboxes and the tick box values are defined by values specified in one of the workbook
Continue reading[SOLVED] How can I populate data once it is within a window of time?
Issue I would like cell J25 to display certain data when it is the next task in the schedule (please see below data). The next task on the sheet ROUTINE should populate into J25 in relation to the time in
Continue reading[SOLVED] How to include more than one column within CurrentRegion?
Issue Range("A1").CurrentRegion.Columns(2) I understand that this selects column B. How would I set it to column A and B? I’ve tried 1, 2 and 1:2 and neither work. Thanks. Solution If you want to get columns A:B applied to CurrentRegion,
Continue reading[SOLVED] VBA how to find a folder name which is include Today's date
Issue I need to check if there is a folder which name is include Today’s date. This is the path looks like; B:\NOS\EIhracat\Credit\2022\34- 17.09.2022\Nakit List.xlsx But I have a problem about folder names. There are a lot of subfolder looks
Continue reading[SOLVED] Export DataGridVeiw to excel in C# with cell background colors
Issue I have made a Shift Roster in DataGridView in winform C#. This is the excel sheet screenshot which I have exported from DataGridView. I need to export DataGridView as it is to Excel Sheet maintaining the font color and
Continue reading[SOLVED] How do I format my export to excel workbook in microsoft.office.interop.excel?
Issue I have this export function that allows me to export 2 grid views into 2 separated worksheets in one excel. But my problems are: How can I have a usual popup window like usual download when I click on
Continue reading[SOLVED] Multiple Worksheet_Change events in VBA code
Issue I want to merge two Worksheet_Change events. The aim of the code is to convert any uppercase text in the cell ranges given to lowercase. I tried copying both into the same Worksheet_Change, but Excel crashed. Range 1: Private
Continue reading[SOLVED] How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
Issue How can I use regular expressions in Excel and take advantage of Excel’s powerful grid-like setup for data manipulation? In-cell function to return a matched pattern or replaced value in a string. Sub to loop through a column of
Continue reading