Solved Web Browser Control Save Image

[arnelgp]

i forgot...
Font Code128.ttf should be installed in your system in order
for the Excel to create the 128 barcode.

the font is in tbl_Font (as attachment).
when you open Form1, it will check if the Font is already installed.
if it is not, it will be installed automatically (silent install).

 

[oxicottin]

UPDATE: from below post... After running I got the error below, so I went into my %userprofile%\AppData\Local\Temp folder and deleted the .tff file that was there and ran again and it worked? I seems it allowed me to put the .tff file there but wont allow me to delete it?



@arnelgp I'm testing it at work and I think I'm blocked from adding the .tff, I'm getting the error and debug line attached.

 

[Gasman]

That is trying to delete the file?

 

[oxicottin]

That is trying to delete the file?

I thought kill file was deleting it, or is it close it?

 

[Gasman]

I thought kill file was deleting it, or is it close it?

Pretty sure Delete?

kill file vba - Google Search

 

[theDBguy]

I'm testing it at work and I think I'm blocked from adding the .tff, I'm getting the error and debug line attached.

So, it looks like you don't have permission to delete files from that folder. But, are you allowed to create files in it? Try simply commenting out that "Kill" line and see if the error moves elsewhere or if it goes away.

 

[oxicottin]

@theDBguy I can delete and add to the temp folder, for some reason when I tried to manually delete the file I got a message it was being used so I stopped Excel process and was able to manually delete. Even though I had Excel closed, there were a few Excel processes running...

Anyways, its working now.... Thanks!

 

[theDBguy]

Anyways, its working now.... Thanks!

Glad to hear you got it sorted out. Cheers!

 

[ahmedjamalaboelez]

an alternative to QRCode and does not need internet connection:
(1) QR Code generator (image) using Zxing (Zebra Crossing) library | Access World Forums (access-programmers.co.uk)

i use it thanks 100% very helpful

 

[oxicottin]

@arnelgp Hay can you give me another hand with this? I been playing with the examples you have given and I am getting an error 1004 Range Class failed and I cant figure out why? The username get username works but I get the error when trying to run the get password I get the error and debug takes me to

sht.CreatePasswordImage

Which thats in the Excel public function for that barcode. I went over this 1,000 times and cant figure out why.

 

[arnelgp]

you use 1 sheet for all generation of your 128 code.
to test first, delete 128_CodeWorkbook.xlsm from Temp folder.
on Immediate window in VBA:

Kill Environ$("temp") & "\128_CodeWorkbook.xlsm"

run frm_Main.

 

[oxicottin]

@arnelgp Thank you again!