Barcodes in Excel

[Mighty]

I downloaded a free barcode font from the Internet and want to use it in an Excel file. I have tested this out manually in a test Excel file and it prints and scans fine.

However, I plan to use it in a template file. This template file is used in conjunction with an Intranet site. User goes to an ASP page on our Intranet site and makes a number of selections and submits form. Server opens Excel template file in the background and populates that template file with data based on user selections. The field that contains the barcode is also updated. The Excel file is then printed and the file is closed without saving.

The problem is that while the barcode prints fine when I open the file manually, when it gets updated automatically by the server, the barcode does not display on the printout. The value under the barcode is correct but the barcode doesn't display.


Any suggestions.

Mighty

 

[jontout]

I'm guessing having had a similar problem a few years back, that you need the font installed on the server?

 

[Mighty]

Unfortunately it's not that simple. The font is installed on the server. I can open the Excel template file on the server and view and print the barcode.

It is only when the file is opened by the Intranet page that the barcode is not printed.

I even got my asp program to save the excel file after it printed. I then opened the template file on the server and the barcode was there but it didn't print from ASP???

Mighty

 

[remeng]

this is a shot in the dark, does the ASP need the font installed so to speak to allow it to read properly? Is ASP trying to find the font on the computer trying to read the barcode?

 

[Mighty]

The ASP program only writes a string into a certain cell in the Excel file which has been formatted to use the barcode font

Mighty

 

[Mighty]

Just letting you know that this worked fine following a server reboot. Thanks for the suggestions.

Mighty