Search results for query: *

I have a program which allows the user to save data to a location. My save-as-dialog shows 'real' folders but also shortcuts (.lnk). I use the file scripting object to check if the selected folder exists. When i select a shortcut (.lnk), fso.folderExists returns False. Is there a way to save a...

I want to email from Excel with Lotus Notes. When Notes is not running I get the following error: the notes.ini file cannot be found in the search path: notes.ini Is there a sollution to this error? When notes is allready running, it works fine. Best regards, John

I have a workbook and i'm hiding al commandbars at startup. When i close the workbook all the commandbars are set to the normal value. This works except for my formulabar. this is my code: Dim Bar As Object For Each Bar In Application.CommandBars Bar.Enabled = True Next Bar...

Hi! I want to search in the registry in W2K for a program that is associated with &quot;.out&quot;. I can do it in W98 but in W2K it is located under the (current) user: HKEY_USERS\<encrypted uservalue>\software\...\FileExts I know how to get my computername and username, but how do i get the...

Hi, I would like to modify the footer of my page before printing it with the name of my company-unitname. But the code interprets everything as string. Is there another sollution to this problem? Unitname=Worksheets(n).Cells(r,k) With ActiveSheet.PageSetup .LeftFooter =...

I have created a button so I can save and quit my active workbook. When I do this, Excel hangs up. In Explorer I can see that a new file is created with a strange name. When I run the macro step by step, this problem doesn't occur. I tried different things s.a. closing with application.quit...

I'm reading data from a comma-separated-file into a worksheet. The worksheet is protected. The cells have a format with left allignment of the Euro-sign and right allignment of the value. After import the Left allignment of the Euro-sign is changed to right. How can I prevent this from...

How can I access each File with Application.GetOpenFilename in Excel? I know the option Multiselect must by set to True. My old VBA code was: objA = Application.GetOpenFilename A contains the path and filename I call another macro and pass through the value of A Now I want to do the same for a...