stored

Hi, The goal is to Check multiple html checkbox options in a webform.Nothing works for me, probably due to a wrong approach & syntax. The vraiables that should to be checked are stored in 1 cell per line, and seperated with delimiter "|". For example - Cell J(i) contains: "roleA|RoleB|RoleC"...

Hello everybody. At the beginning of a macro, I've stored a range in variable rng and then I've deleted it from sheet1. At the end, I've to "paste" it in another position, starting from row z of column A. How can I manage this job? ps. my unsuccessful attempt: rng.Insert (sheet1.Cells(z, 1))

Having two workbooks WB1 stored under: C:\WBA.xlsx Sheet 1 WB2 stored under: C:\WB2.xlsx Sheet 1 Now I want to create a macro which first activates cell A1 in sheet 1 in WB1 and then by tabbing F8 in VBE selects cell A1 in sheet 1 in WB2

Hello: I have a list of numbers in column C stored as text and left indent. Some of the numbers have preceding zeros. e.g. 000111, 01212, 001451, 12151, 0000001245 When I convert column C to numbers, Excel loses the preceding zeros and right indents. How can I convert numbers stored as text...

Hi, I am new in VBA so I having problem with a a particular problem statement. I have multiple workbooks in one folder which are reports in a specific format. I need to extract specific cells and one whole column from each workbook and store it in a masterworkbook. The information which I need...

Hello, Please can anyone help. And please forgive any errors in terminology. I have stored two formulas as variables which I can see are correct on the Locals window. I now want to combine these two formulas together in another cell. So far I have following but I cant seem to work out how to...

Hello I need to import a data table from SQL to Excel. I have the 2 queries in stored procedures (one that provides one part of the data table, and another provides the other half of the data in the table). What I want to do is for users to key in the start and end dates in Excel and the...

Hi Any help please I am trying to record values every set time period eg 5 minutes, from COLUMN G and every second cell. Cells G9, G11, G13 etc to AG9,AG11,AG13 etc. For example if it is 10.00am and value in G9 is 10 I want that value stored in AG9. Then at 10.05 if value in G9 is 11, I want...

I am having an issue where my dates are stored as text but still look like they are in date format. I have tried everything to fix this including text to columns. Are there any other ways to convert these to a date format? Example: 1/1/1900 (looks like its a date, but is actually in text...

I know you can get cell information and have it as the header and footer via vba But what I am after is the opposite, I have a worksheet that is generated via a program and most of the information is stored in the header and footer (date, time, report name etc etc) and I need to work with the...

Friends, How can I call a stored procedure from Vba Excell for Mac? Thanks

Hi all, I am looking for a way to be able to use a variable name that is stored in a spreadsheet. Basically, I store column numbers as variable integers. Column header names are looked up and the column number is stored. the columns appear on 3 sheets in different location so will have 3...

Having trouble getting vba code to work that will look in column "d" of worksheet to see if <>"NI" and loop thru to create a excel file for each row this true a with template excel file and rename to value stored in column "b". Code needs to allow for user to select location the template file is...

Hello everybody. I have a huge amount of records in which a lot of number are stored as text. In order to simplify, I have created the above image: https://imgur.com/a/H5IXsEm The task is the following: for each value in colomn E, put in column F the related value as reported in column B...

I tried to send a pm to a member here. ut when I submit send I get this wweird message: "You have reached your stored private message quota and cannot send any further messages until space has been created." I'm new here. How can I have "stored" pms if I never sent any?

I have a list if ID's in column A where some ID's are repeated and column B I have a list of dates. I want to be able to find the latest date for a specific ID and wondered if the best way to do this is to use VBA code to use the 'Find & Replace' option to find each instance of the ID and...

Is there a way I can get the BuiltinDocumentProperties of a closed file? The path to the file itself is stored in a Textbox...

I have a column of dates stored as text in this format: When I try to sort them in newest date order it doesn't work and the dates are all over the place - is there a way around it?

I want to hide or show "Button 27" depending on the text displayed in a Cell D25. The Button is called "Button 27" I want "Button 27" to be "Visible - True" if the text in "Cell D25" has this entry "To be stored in Teamcenter" I want "Button 27" to be "Visible - False" if the text in "Cell...

I have a column of data which comprises of dates stored as text - I need to be able to count the number of unique dates in that range and have tried this; but it doesn't work, presumably because they're stored as text. Any workaround?