Search results

Yes, the code is VBA, I'd adapt it to access vba to execute. My question, you are correct is how could I trigger it w/o access being open? Altho, that makes the mind wonder, if I could adapt that to a vbscript. hmmmm...amazing what the mind can think of with just a few simple bits of assistance

the code is vba, I would adapt it to run via access vba - but I know from previous experience you can't have an access macro run if the access db is not open which lead to my ?

I found this awesome post http://rondebruin.nl/win/s1/outlook/saveatt.htm - but my question about this is, must the access database be open in order for this code to execute? I'm needing a solution where the access database does not have to be open

hmmm...any links or sample code?

Using Access VBA can I download ShareFile attachments?

Yes, I did a Debug -> Compile and no errors are showing @cheekybuddha

Yes, sorry. It was CreateKitNames() when I was testing, but for this prod code it's CreateNames() I've removed the Testing code, so it's only one name now

It's in it's own function :) Function CreateNames(ws As Object) Dim dataColumn As Long, outputColumn As Long, tempCol1 As Long, tempCol2 As Long Dim i As Long Dim dataVal As String, letterVal As String, decodedVal As String dataColumn = ws.Cells(1...

won't even reach the method :D I added a breakpoint on the above line, but it still hits the same line and throws the error

I added option explicit, and declared all variables as this Dim dataColumn As Long, outputColumn As Long, tempCol1 As Long, tempCol2 As Long Dim i As Long Dim dataVal As String, letterVal As String, decodedVal As String And a debug - compile shows no issues, but running the code...

It won't step into the function. If I add a breakpoint to that line, the second I press F8 the error is thrown.

This is the line highlighted Call CreateKitNames(ws)

@cheekybuddha - when my code hits this line CreateKitNames (wb) I also tried it as ws since that is what we are passing in - I get the error: Run-time error '438': Object doesn't support this property or method And just for clarification this is how the method is setup Function...

how would I pass the instance of excel from the Function Test to Number2Letter() and CreateNames() so I do not get left with the hanging Excel reference?

Ah - I'll investigate this further. This explains why I would always have a "ghost" instance of Excel running in Task Manager even when the process had completely finished! I do not have option explicit declared, I know that is best practice, I should have remembered that. I have the...

Through some assistance here and through google, I have copy/pasted a frankenstien of some code together that does exactly what I need. My question tho, is if there is any ways of cleaning this up, or am I using any bad practices/principles that could/should be changed? Thanks in advance to...

I finally figured it out. This is the syntax I have in case anyone coming back here later on needs the same assistance as I Dim wb As Excel.Workbook Dim xlApp As Excel.Application Dim LastColumn As Long Dim pivotWS As Excel.Worksheet, dataWS As Excel.Worksheet Dim PCache As Excel.PivotCache...

@bastanu - thanks for posting this. If I am understanding tho, this will allow creation of a pivot table in access. I need to use access vba to create a pivot table in excel

even when I try your code, this line still gives me an error MyBook.PivotCaches.Add(.....

Automate a power query? Can this be run thro Access VBA?