Microsoft Excel Forum

Hi All, I have the below macro that I've been using to select data from a sheet, copy the data, open a new workbook, paste special values and format columns C & D to date format. This works perfectly as is, however, instead of the filename for the new workbook being based off of cell H1 in worksheet "Upload to NBI" I would like it to be based...

I have a macro button that will allow the user to open PDF's by inserting the PDF name. If the PDF does not exist, Excel crashes. I want to be able to handle the error, and give the user an output indicating the file doesn't exist. Private Sub pdflink_Click() 'this button allows you to follow the text box with the location of the pdf. On...

Hi everyone. I have created a pivot chart speedometer type that indicates key performance within a classroom situation. The pivot chart was created in Excel 2013. I was hoping to display the charts within a platform, such as Microsoft Office 365, Google Docs or on a VLE such as Canvas or Blackboard. However, it would seem that none of these...

Hey all, First, thanks for taking the time to look at this thread. I have a written a loop that utilizes Excel Solver to calculated the best option for multiple columns. Here is my code so far: Sub Solver2() Dim x As Integer Dim A, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q As Range

i make a userform it help me to exporting records from ms access db records will be between 2 date and 2 criteria for like : i want to export records from 1 of march to 15 of march with criteria1: category and criteria 2: employee so i make an adodb connection between 2 date and it successful working but it cannot use my criteria in...

The control array is not implemented in vba. Class modules are used to achieve this artificially. The example below shows a form with three text boxes that allow you to enter numbers only, three text boxes that allow you to enter only uppercase letters, and three text boxes that allow you to enter numbers and uppercase letters. 1. Place 9...

I want to create a microsoft query which would pull data from an access database. I need my users to be able to filter the data however they wish, which I know is possible using a query. However, I don't want them to be able to make edits from a query. Is there a way I can disable a query from making edits to my table?

In Excel, I am trying to convert the date yyyy-mm-dd to yyyy-mm (in my database), so that my pivot table doesn't included every day of the month. Is there a simple way to do this?

I am an Excel newbie, but have a good amount of MS Access experience, including VBA coding. I need to create a worksheet with a multi-select Listbox column, which stores the multiple values selected by the user from the Listbox to another column on the form in the same row, separated by commas. Each time I create the Active-x control on the sheet,...

I want to append "0" along with cell value if there is no "0" in beaning of cell value. Range of cells are S3:S100 I tried the following logic but it does not work. For Each cell In If cell.value is not null then if left((cell.Value), 1) <> 0 Then cell.Value = "0" & cell.value

Does anyone know how to create an “AllDateinperiod” filter with dynamic dates. Autofilter only allows filtering by month and quarters, I want specific date range. I am new at VBA and need some help. I have 5 years of data (41K rows) and want to filter for specific date ranges and show all years. Currently I created a filter using VBA and a...

This macro is written in Excel 2010 which works perfectly on Microsoft XP but it fails on Windows 7 and 8. What macro does --- It gives 3 drop down options to user Select Month ----This is the excel file for e.g. July 2013.xlsx it contains sheet from the date 1st July to 25 July Select From Date --- Dates from 1st July to 25th July Select To...

I am having issues with the data being placed in the master workbook which contains multiple worksheets that have data tables In one case if SHNames = "Proj Sum" then it is placed outside of the table and not recognized by Pivot table, the other if the shName = "ResPlan_Data", there are multiple rows of blank lines in the Table and no data is...

I have a sheet that I want to filter on a month. I have the month in Sheet Master Cell C4. If I use the filter as: ActiveSheet.Range("$A$1:$X$4831").AutoFilter Field:=5, Criteria1:=xlFilterAllDatesInPeriodApril, Operator:=xlFilterDynamic It works. When I use a variable in the AutoFiler if fails. Full Macro is: Dim vMonth As Variant Dim...

Hi, I am creating a macro in Excel to extract some information from Master excel. In Master sheet, have some data with the column- 'Target dates' (list of Dates) in it. I want to compare Target dates with the current date and if the Target dates already breached the current date, then should be highlighted in red. If Target date has...

I created a VBA code to automatically sort(ascending order) a column containing Traditional Chinese characters on Excel 2003. It works well but when I tried running the code on a Excel 2013 version the sorted values differs versus on the sorted values on the Office 2003. I tried using Range("A2:A30").SortSpecial SortMethod:=xlPinYin and...

One of my customers has an Excel 2003 document that appears to be corrupt. When I open the excel document I get the following error: "The file you are trying to open, 'database.xls' is in a different format than specified by the file extension. Verify that the file is not corrupt and is from a trusted source before opening the file. Do you...

Currently I have a list of items in coulnm A in column H I have the quantity used and in coulmn E I have comma seperated values (could be 1 could be 30). I have created a Text-To-Columns action to move the info from column E to individual columns for example, if E2 had 3 comma seperated values the code takes these values splits them and moves them...

I've been working on an idea on how to create a job schedule from a list of names and a list of numbers (numbers are positions) I'd like it to generate 4 columns of predefined numbers so that each person has a unique number for each column. Ex. 1 2 3 4 Jim 21 22 11 10 Dave 10 11 21 22 Will 11 10 ...

Hi, I am seeking a help from all excel VBA expert. I have attached the excel file for reference. In the "Input" sheet there is production schedule that will be generated on submit button click. And the same schedule will also have to COPIED in "Output" sheet. But I am not able to paste it in desired location (blue highlighted area). ...

The following works well in local share network drive. However, when the file is transfer over to the open network (view from internet), the following excel file will show error: Run-time error: 52. Bad file name or number. I have change the fpath to the following instead of fpath = ThisWorkbook.path & "\" but still having the same error. ...

Hi, Sorry if I'm asking a super easy question. From sheet Details I need to copy next rows each time I click like for example - A5,B5,C5 to the next empty row in destination sheet. From Invoice I want to copy fixed rows in next avilable rows in the destination sheet. Below is the code that I have however it copies the fixed rows from Details...

OK first off hello! I am new to these forums and - though I dabbled a bit in Basic when I was younger - new to programming in general. I have searched using Google rather extensively but cannot figure out how to do what I'm attempting...perhaps because I am having a hard time applying programming principles because I am new to macros and VBA. ...

Hello there, I am trying to plot 3 variables on one graph (specifically flow rate, pressure and flow path diameter) with the x-axis being measured in units of time. Since these all have different units of measurement and there is only a primary and secondary axis I don't know how to fit them all on one graph or if it is even possible to do...

Hello! Is there anyone who can tell me if I can extract and automate the data in excel using crystal report data? Thank you in advance!!