Create object 64 bit

[Tonyhansson]

Hi

I have and Old script using create object.

It create a txt dokument and use it for printning on a zebra printer.

It Can’t run on 64 bit Excel.

Is there a substitut for create object in Excel 64 bit ?

Regards
Tony

[BMV]

There must be no differences for x32 and x64 system if you create object by standard method. Could you show the sсript.

[Tonyhansson]

Hi Thank you


Module1

It makes failure in create object, when runned in excel 64 bit.

Please Login or Register  to view this content.

[BMV]

Please check
MyFile = "C:/testfil.txt"
it must be MyFile = "C:\testfil.txt"
On my x64 system the script is ok after change the path.

[Tonyhansson]

Hi Thank you

It still makes failure (The path mistakes is made by me), but is not the issue.

The posted link, I dont understand what I have to change, can you help me.

If I google Create object, it should not be possible in 64 bit, to use Xactive.

So how can I change the script ?

[BMV]

I would alwayy advice 32-bit Excel but it's a choice

this is very old Microsoft recommendation but now the system must be x64 only.

@Tonyhansson the script is good by something wrong in the application environment. I agree about References and you can check the script as VBS also.
Any ActiveCell.Offset must be change to values and call print_label .

Please Login or Register  to view this content.

Save the scrip as .vbs and start it from explorer.

[Tonyhansson]

Thank for your time.

I dont have the knowlegde to see the issue.

Could I ask you to look on the complete file, and if nothing is wrong, it must be the enviroment?

[AliGW]

I think you might need to attach a workbook for this to happen.

[Tonyhansson]

Yes thank you

[BMV]

There is no problem in the file except
MyFile = "testfil.txt" again. There must be full path.

[Tonyhansson]

Thank you so much for your time.

It is running without the path in 32 bit, I will chance it, and then I know it must be enviroment and references.
This help me a lot, now I Can go on to next step

Merry Christmas

[Keebellah]

Marry Christmas to you too