import

Hello! I use a basic order form clients fill out and send me. Then I have a VBA macro that reads every cell of the submitted form, and pastes the value into the corresponding "In House" form. Trouble lately, a few people are sending everything in lower case. Can I modify my copy or paste...

Hello, Can this be possible to add the filename and date when importing excel file. I have a table of import file and i need to add the filename and date to the table for the records purposes. Is also possible to select the file. Any help is much appreciated. Thanks

Good Morning, I've got the code below -- I was hoping just adding CVS to the filter would allow me to import it but it doesn't so I need to help. How can I get this code to import CVS files? Sub ActiveRateCategory() Sheets("ActvRateCat SumRpt").Range("A:M").Clear Dim wkbCrntWorkBook As...

Hi there, I am using this macro to import my outlook Calendar into excel but it is ignoring recurrent meetings and only shows the first instance. Is there a way I can add this into the code? All my attempts have failed so far. Sub Listappointments() Dim olApp As Object Dim...

Hi Everyone, I am creating an import code for Access from Excel that takes every excel file in a folder, imports the designated Sheet (i.e only Sheet1) and within a designated area of space in the sheet(i.e Sheet1!A32:T1881) and import it to an access called Table called "Test1". This I have...

Hey all, I'm trying to move a module to a new Workbook and assign it to a shape I can Export/Import it but when I assign it I'm assigning the macro from the Original, not the New Workbook. The New Workbook's name will change each time it's run. I don't know how to code a variable into the...

I am trying to import a QBB file into Excel 2016. In older versions, you could use the import from other source feature but I don't see that option in 2016.

Hi. Is there a nicer way to use a button on a userform to remove it, and then import it again ? Lets say i make some changes to the userform, then i export it. Then if i click a button, it shall remove it from the program, and import it again (to get the newest version) The code i try when...

I am working on an inventory database in Access. I have a build of materials list in Excel. The part numbers have prefixes, bases and suffixes. Some of the part numbers are on the build of materials multiple times. Some of the part numbers change occasionally (suffix only; prefix and base...

Hi all, So basically I am trying to create a standardized tool that I can give to customers, and it will return graphs and values for a number of metrics. I want the sheet to have a button that says something along the lines of "Add data here" and they can add their data from another workbook...

I can import data from SS Management Studio into Excel using VBA and ADO. Is the process the same if the data is in SS Reporting Services instead of SSMS? If not, how would I go about it? Thanks

Hi all Really hoping a genius can help me with a little task... I am using the code below to import data from a separate workbook into my existing workbook. What I'm trying to achieve is for one vba macro button to present the user with 3 separate spreadsheet imports. I.e: The user clicks...

Hi all, Had a bit of a google but not sure if this is possible or not... I have a sheet that imports data that is copied to the clipboard from another sheet... the other sheet data will open in protected view - so if people don't click enable editing then it copies the selection as an image...

Good day, I have an issue where I need to import data into a single column of an excel sheet. Column "B". I have formulas set up to extract to the right of the column. We have had instances of clerical staff typing into and ruining those formulas in the past. I protected only the columns with...

Hi, I am having trouble converting an excel formula into a power query statement. The formula is =VALUE(IF(ISNUMBER(VALUE(MID([DocNum],6,1))),[DocNum],LEFT([DocNum],5))) I have it in a custom column, but would like it to ideally be used as a formula in the [DocNum] column in power query if...

We have a very complex spreadsheet at work which includes a lot of macros that hide/unhide various rows/columns/tabs depending on the options selected. The spreadsheet is a "calculator" type template/spreadsheet so we update it quite often and instead of entering our client's info into the...

This is going to be long and tedious, or I am just simple minded. I would like to have a database of information (Control) on one sheet, and import data on another sheet, and have a formula compare that to the control and if it finds a similarity I need it to tell me how much money is invovled...

I know you can have a Template and upload/import the data into Access. My question is, can you do that from the Excel Sheet or do you have to import it from Access (have access Open and tell it to import from there vs Button on the Excel Form that automatically uploads it) Thanks

Hello I am new to excel and VBA coding and have not been able to figure out how to complete what I would like to do. I have been able to make simple macros but this is more in depth I believe. The goal: Create a macro that when the excel file is opened the user will be brought to a specific file...

Good morning - I have 115 text, tab delimited, files I want to import into a single sheet of Excel. I found this upon searching: https://www.mrexcel.com/forum/excel-questions/8822-importing-multiple-text-files-once.html, but I want to also import the text files last modified date into a...