Search results

Yes column A will always hold the name. Then columns B - ? will hold the counts that I need to concatenate (it varies form workbook to workbook)

All rows with data. (sans the first row since it will always be the header row)

I want to concatenate the values of B- F in column G with a period between them. But I don't want to hardcode B:F because those columns can be dynamic What is the proper way to close Excel?

This is my current code Function Test() Dim wb As Excel.Workbook Dim xlApp As Excel.Application Dim lColumn, x As Long Dim strValue As String Dim rng As Object Set xlApp = CreateObject("Excel.Application") xlApp.Visible = False Set wb = xlApp.Workbooks.Open("C:\Test\Test.xlsx", False, False)...

Err, that was actually a typo on my part. Still same error. Amazing you can do this from memory!

Okay, I've got For x = 1 to lColumn strValue = strValue & "." & wb.Sheets(1).Cells(2,x) Next x strValue = Right(strtValue, Len(strValue) - 1) Now the code will hit the last line in the above code block and give me the error Run-time error '5': Invalid procedure call or argument

Yes, my struggle comes in when trying to actually write the concatenation code. I know Excel has a built in Concat() function, but it doesn't have the ability to add a . in between each value.

It's updating an existing workbook. The worksheet comes in like what my sample workbook shows. And columns are concatenated on the same worksheet. This process will be run twice daily on two different workbooks. Just trying to automate a process that is currently manual.

Okay - seems changing the extension changed it to pure garbage. Here is a google drive link https://drive.google.com/file/d/1B5sgbjaMgw92TmqYGXR-_9nA41XIopux/view?usp=sharing

I am manipulating Excel with Access. Let me attach a sample workbook that should better illustrate what I'm after. There will never be a blank column, but it could hold a 0. I'm wanting to after the last column with data, add the concatenated values. This is a .xlsx but for some reason I...

I need to concatenate the rows in my workbook. I want to ignore column A, and only do column B - the value of lColumn I am capturing lColumn like this Dim lColumn As Long lColumn = wb.Sheets(1).Cells(1, Columns.Count).End(xlToLeft).Column Which means I want to take column B - lColumn and...

I didn't even know that was an option. Thanks for the option

Yes! We have an on mouse move event.

How do I get to the Mouse Over Event? When I go to design view, and look at the property sheet and look at events I do not see a mouse over event.

I didn't think about a mouse-over event...hmmmm....I wonder if I can set that to show the file name only and leave the value of the text box equal to full path :D.

I have a text box on a form, with a button. When the button is pressed it opens a File Dialog Browser, and allows the user to select a file to input. I can not make the text box any longer, so as a work around I was wanting to show the furthest right of the text (file name and extension) I am...

I am setting the source of a form as a query that holds roughly 30 lines How can I set the form to display one horizontal row, per row in the query just like the query does? I tried setting it to continuous, but that stacked all the query fields vertical on top of each other and spanned...

When I ran my second VBA syntax it worked, but not sure if I am not thinking of, or not aware of, any use cases that could cause this to fail?

an add-in that can be run through vba? I was hoping to run this solely through vba code... I feel it will be something along the lines of this, altho this does not allow me to specify a table name with wild cards... For Each tdf In CurrentDb.TableDefs If Left(tdf.Name, 10) <> "MSys" Then...

How can I search all tables in my database for a table named *DavidsData and rename it to _DavidsDataLocal through VBA?