VBA Compiler

1 Star2 Stars3 Stars4 Stars5 Stars (4 votes, average: 4.75 out of 5)
Loading...
Go back to All Questions Login or Register
996 views
0

Hello AnalystCave,

I’ve recently installed the 32bit VBA compiler and I am unable to see the compiler ribbon ? I understand in a previous post you have indicated to re-download the 32 bits version because it was broken ? Was it fixed ?

Can you help ? I am using a 32bits excel 2010 version

Thanks,

Luc.

0

I have a question regarding the VBA codes.
I want to copy data “specific columns” from open excel file (excel file is attachment in outlook – Name of the file in outlook attachment looks like: 20171011__GAMA_Programi i aprovuar.xlsx and changes everyday ) and to paste transpose them into another workbook on my PC.
How can I do this automatically with VBA macro (codes) by one Button taking into account changes of the file name everyday( (without changing manually the name of the attached file).
I appreciate your help.
Best regards

0

Hi Luc,

unfortunately seems like some versions of Excel don’t support the VBA Compiler for unknown reasons. At this time I don’t have the capacity to do a deep dive into the issue resolution.

I might however be posting the source code soon enough.

0

I tried both Win7 64/32 and Office 2013/2016 32/64. Its not working(

0

Hello AnalystCave,

which version supports?

Simply the best place to learn VBA!

Error: Please enter a valid email address

Error: Invalid email

Error: Please enter your first name

Error: Please enter your last name

Error: Please enter a username

Error: Please enter a password

Error: Please confirm your password

Error: Password and password confirmation do not match