Installing fonts on a Vista Pc - C# Discussion Boards

16-Jun-09 3:07

hello,

I use Microsoft.Office.Interop.Excel to creat excell file-I create it and in the end of the work with it i close it using
Microsoft.Office.Interop.Excel.Application ExcelApp
But the problem is that even after i close the application the excell still appears in the task manager(in processes).
How can i kill it in the program (when i finish working with excell)?

stancrm16-Jun-09 3:28

stancrm

16-Jun-09 3:28

I did it this way :

ApplicationClass app = new ApplicationClass();
Workbook workBook = app.Workbooks.Open(filename, 0, true, 5, "", "", true, XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);

...

app.Workbooks.Close();
app.Quit();
Marshal.FinalReleaseComObject(app);

michaelgr116-Jun-09 4:36

16-Jun-09 4:36

It doesn't help.
I still have the process of EXCELL running (in task manager)

michaelgr116-Jun-09 6:58

16-Jun-09 6:58

Does anyone know what the problem may be?

MumbleB16-Jun-09 7:55

MumbleB

16-Jun-09 7:55

Have you tried to release the Workbook, Worksheets, Ranges etc? The below works for me. I finally force the Garbadge collector to collect.

System.Runtime.InteropServices.Marshal.ReleaseComObject(objRange);
System.Runtime.InteropServices.Marshal.ReleaseComObject(objSheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject(objBook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(objExcel);
GC.Collect();

These work fine for me.

Excellence is doing ordinary things extraordinarily well.

michaelgr117-Jun-09 6:45

Installing fonts on a Vista Pc

17-Jun-09 6:45

I don't have excell range object
i only do objsheet.getrange.... or something like that
so i did the ReleaseComObject only to the application (objexcel), the sheet and the book.

Anyway,
The program still doesn't release the Excell process and i have it in task manager. What can be the problem?

Okultist16-Jun-09 1:55

16-Jun-09 1:55

I want to copy a font file to the fonts directory on windows vista, but currently i fail to get the right permissions.
Everytime I try to copy the font from its current folder to the font-directory (c:\windows\fonts) I get an "UnauthorisedAccessException"

My code looks like this at the moment:

            if (System.IO.File.Exists(fontPath))
            {
                FileIOPermission f2 = new FileIOPermission(FileIOPermissionAccess.Read | FileIOPermissionAccess.Write, "C:\\Windows\\Fonts\\");
                f2.AddPathList(FileIOPermissionAccess.Read | FileIOPermissionAccess.Write, fontPath);

                if (SecurityManager.IsGranted(f2) == true)
                    MessageBox.Show("Its fine!!");
                else
                    MessageBox.Show("No Permissions");

                try
                {
                    f2.Demand();
                    MessageBox.Show(fontPath);
                    System.IO.File.Copy(fontPath, destination);
                    //AddFontResource(fontPath);
                    //SendMessage(HWND_BROADCAST, WM_FONTCHANGE, (IntPtr)0, (IntPtr)0);

                }
                catch (SecurityException se)
                {
                    MessageBox.Show(se.ToString());
                }
                catch (UnauthorizedAccessException ex)
                {
                    MessageBox.Show(ex.ToString());
                }

            }
<pre>

Thanks for your help

dan!sh 16-Jun-09 2:24

dan!sh

16-Jun-09 2:24

Do you have rights to access the Fonts folder?
Which line throws the exception? That would help knowing where the problem is.

जय हिंद

Luc Pattyn16-Jun-09 2:54

Luc Pattyn

16-Jun-09 2:54

Hi,

when I run code like that on Vista I am getting a DirectoryNotFoundException on C:\Windows\Fonts\ in the File.Copy() statement, although the folder is visible both in Windows Explorer and in Command Prompt, and I am running with admin privileges.

Confused | :confused:

Luc Pattyn [Forum Guidelines] [My Articles]

DISCLAIMER: this message may have been modified by others; it may no longer reflect what I intended, and may contain bad advice; use at your own risk and with extreme care.

dan!sh 16-Jun-09 3:35

dan!sh

16-Jun-09 3:35

Same code works for me in XP. I have the variables set as:

string fontPath = @"c:\test.txt";
string destination = @"C:\Windows\Fonts\test.txt";

जय हिंद

Okultist16-Jun-09 3:43

16-Jun-09 3:43

Yeah, the problem is that i am using vista and a few things changed there. There are new security rules and i tried to do it the "good" way by asking the system for permissions.

dan!sh 16-Jun-09 5:25

dan!sh

16-Jun-09 5:25

Well, in my case the code works perfect in Vista as well (running as Admin). In your case, I see that you are checking the permissions for the file and not the destination folder. You can check the rights for that directory using DirectorySecurity class (I have never used it, hence not sure).

जय हिंद

Okultist16-Jun-09 3:40

16-Jun-09 3:40

Is there a fast way to have a look on the privileges an user has for a folder? the windows explorer should have a way look them up.

Okultist17-Jun-09 2:46

17-Jun-09 2:46

I think its not possible to copy the Font file to the font-folder with out adminstrator status. so i decided to use an application manifest to run my program as a adminstrator on startup.

State Maintenance

ashajahanmca16-Jun-09 1:44

ashajahanmca

16-Jun-09 1:44

I'm developing a windows application in C# usin .NET framework 3.5. Suppose a user opens one form to work. and after working he need to move next page without saving data
if user click the next page i need to give one message like "You May lose unsaved data"
if ok then contine else cancel to stay on the page i don't know where to write code

Michael Bookatz16-Jun-09 1:50

Michael Bookatz

16-Jun-09 1:50

Put it either in the button he uses to click to the next page as a message box or on the form close and if you choose not to close handle there. Google is your friend.

Henry Minute16-Jun-09 1:54

Henry Minute

16-Jun-09 1:54

ashajahanmca wrote:
if user click the next page

It depends on what 'next page' is. If it is a Control descendant, write your code in the Click event handler.
Give them options for OK and Cancel, if they choose Cancel, just return from the handler before executing the code for next page.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

himanshu256116-Jun-09 2:01

himanshu2561

16-Jun-09 2:01

<asp:Button ID="Button1" runat="server" Text="Add" OnClientClick=" return Test()" onclick="Button1_Click" />

Place it in head section

 <script language="javascript" type="text/javascript">
 function Test()
 {
return confirm("Are u sure");

 }
 </script>

himanshu