> In our application, we generate excel which is more than 150MB of
> size.
> But is there a way to provide the user with a hyper link, upon
> clicking; that will open the file that is there in temp location in
> the unix server.
I use the following code to serve an excel file to the browser:
#! /usr/bin/perl
use strict;
use warnings;
use CGI qw(:standard);
my $rname = '/tmp/afile.xls';
my $bname = 'afile.xls';
my $mimetype = 'application/vnd.ms-excel';
print header(-Content_disposition => "attachment; filename=$bname",
-type => $mimetype);
open FD, "<$rname";
binmode FD;
binmode STDOUT;
while (read(FD, my $data, 4096)) {
print $data;
}
close FD;
Re: Running Excel Addin from VBA in Access....HELP!! ... You initially build a macro in Excel to do what you want, ... imbeds it in an Excel file of your choosing, then runs it as a macro.... code that creates an Excel file,...Dim objUniqueTeams As Object ... (microsoft.public.access.modulesdaovba)
Re: Real Workaround for Excel Link Bug in 2007? ... you'd need the Excel file in the local directory.... Or did you mean local HDD vs "the same directory as the PPT itself"? ... (microsoft.public.powerpoint)
RE: Issue with UNC Path (I think). Trying to build Dynamic Report ... Table and then suck in all the data from my Excel sheet on the network drive. ... easy to find the UNC path for a drive litter. ... Function UNCDrive(strUNCName As String) As String ... I am trying to Link to an Excel file on a network drive and build a Report ... (microsoft.public.access.formscoding)
Opening Excel from Access 2000 ... command button that opens the excel file.... one on each worksheet scatter charts on the maps showing ... If the database is closed the Excel file opens perfectly every time. ... (comp.databases.ms-access)
RE: Issue with UNC Path (I think). Trying to build Dynamic Report ... Table and then suck in all the data from my Excel sheet on the network drive. ... easy to find the UNC path for a drive litter. ... Function UNCDrive(strUNCName As String) As String ... I am trying to Link to an Excel file on a network drive and build a Report ... (microsoft.public.access.formscoding)
