query - how to know which is the difference between a code for 64 bytes or 32 bytes

[IonutC]

Hi guys,

I started to do VBA programming and it seems that I have to learn about how to fix different issues due to the different Windows platforms eg. 64 bytes or 32 bytes.

Is there a manual where I can learn how to fix the issues?

I did a code that works fine for me, but not for others.

Also the hardware might impact a VBA code?

if you can help, I would really appreciate it.

Thanks in advance,
Ionut

[Winon]

Moderation removed.

[IonutC]

Hi Winon,

Sorry! That was not my intention here.

I changed the title.

10x,
Ionut

[xlnitwit]

Hi Ionut,

The majority of code should run on either 32 or 64 bit Office with no problems. You will need to change any API code you use: https://msdn.microsoft.com/en-us/lib...ffice.14).aspx

Also any controls that are not from the MSForms library are unlikely to be compatible with 64 bit Office.

[IonutC]

Hi man,

Thank you. Then why a macro runs perfectly on my machine and on my colleagues not?
All the notebooks are on 64 bytes.

[xlnitwit]

That's a fairly vague question! What is the macro, and what happens on the other machine?

And just so there is no confusion: the differences apply only when Office is 64 bit, not if you are using 32 bit Excel on 64 bit Windows.

[IonutC]

Hi xlnitwit,

the post I had was: http://www.excelforum.com/excel-prog...acro-code.html

I taught that by having a different version of windows there are issues in the logic of macro.

Thank you,
Ionut

[xlnitwit]

I do not see any parts of that code that would be affected by Windows being 64 bit. If you have access to one of your colleague's laptops, it would be worthwhile stepping through the code to see what is happening.

[IonutC]

I did. Nothing happened. The code ran and the docx files were not saved....And all were docx files.

[xlnitwit]

You need to step the code rather than running it. I would also suggest you should specify a path for the save (using file.path instead of file.name would be a good start) rather than relying on whatever the current directory may be.

I take it that code is in Word?

[IonutC]

yes please! if you can show me how can I improve it, I would owe you a lot!

[xlnitwit]

I did that in my previous post - use file.path instead of file.name. That way the pdf will be in the same folder as the original. If you want to specify a folder instead you can do that too. You already have code that allows the user to choose a folder so that would be a third option.

[IonutC]

Hi,

I did this code, but is not working.

Please Login or Register  to view this content.

[xlnitwit]

The path needs to be in the SaveAs2 line:

Please Login or Register  to view this content.

[IonutC]

Ok! got it! I will give it a try!

Thank you!

[IonutC]

Hi there,

is not working tough and they have a 32 bytes notebooks. I tend to think that the issue is due to this Office for 32 bytes.