I made a macro that checks a cell with the current date with a cell containing the last date it was opened. If the date it was last opened is less then the current date, it takes everything from the ';current'; row and puts it in the ';previous'; row, then changes the last date it was opened to the current date. It works fine, but to run it I have to use a keyboard shortcut. How can I get it to run the macro automatically every time I open the spreadsheet without having to use the shortcut?Macro automatically run when opening Excel 2003?
Press ALT + F11 to open the VBE
Double click 'This Workbook' in the Microsoft Excel Objects in the upper left quadrant.
In the 'General' drop down menu select 'Workbook'
Enter 'Update' (no quotes) between Private Sub Workbook_Open and End Sub as below:
Private Sub Workbook_Open()
Update
End Sub
Close back to Excel and save the workbook.
Tuesday, November 16, 2010
Linux Help- Volume Control Malfunctioning?
I just installed Mandriva- and it was fine until the installation was complete.
There is the Volume box that pop-ups when you are changing volume- stuck in the middle of my screen. I think this is because it is constantly decreasing.
How do I fix this? Mostly I want the big Volume box out of my view- but I would also like to have volume. - Any suggestions?
I'm a totally new- so I've played with some things. I tried to kill Kmix- but it would re-start immediately after. (and the volume box never went way) I tried to have no sound programs on the auto-start, but it didn't change anything (I wasn't familiar with most of those programs, so I might have missed one) I tried checking for jammed keys. (The shortcut on my keyboard is Fn-Page down and neither, let alone both, were jammed) I tried to erase all the short-cuts, and that also didn't help. (actually- my shortcuts still worked, so perhaps I did that wrong)
I'm out of ideas that are obvious to me.Linux Help- Volume Control Malfunctioning?
Hi, I think its a bug with kmix or something, try the Mandriva forums cause I have never heard of the behavior on any distro I ever used.
Why not use a better distro like openSUSE, its way easier, polished and its just AWESOME!
http://en.opensuse.org/
I have my own suse blog here and here r screenshots as well
http://snake1990.wordpress.com/
http://en.opensuse.org/Screenshots/openS
Its the best distro of 2008:
http://www.bitburners.com/articles/the-b
Here r the suse forums:
http://forums.opensuse.org
The problem with Mandriva is that after every cool release one release is buggy.
openSUSE is the best :)Linux Help- Volume Control Malfunctioning?
Well, one volume control never fails. Open a terminal session and type alsamixer as a regular user. It should provide an ncurses control for your audio hardware. Esc closes the program, and your arrow keys move between and adjust sliders. M mutes sliders. you may need to get a seperate alsa tools package to use this applet on your distribution.
Also, if you want to kill a program ,you often have to use ';kill -9'; instead of just ';kill.'; Yes, lower-case kill, followed by a space, a dash, and a nine. Then, of course, the offending PID or process identification number. Xkill will get the darned thing off the screen, by the way, but won't kill the underlying stalled process.
Sorry, but Linux has a way of being obtuse. I weouldn't doubt there's easier ways to do these things on Mandriva, but I don't use Mandriva so I can only teach you distribution-agnostic methods,
Oh, and while I hate distro evangelists, I do concur with another poster that Mandriva is buggy and bloated, Sorry.
There is the Volume box that pop-ups when you are changing volume- stuck in the middle of my screen. I think this is because it is constantly decreasing.
How do I fix this? Mostly I want the big Volume box out of my view- but I would also like to have volume. - Any suggestions?
I'm a totally new- so I've played with some things. I tried to kill Kmix- but it would re-start immediately after. (and the volume box never went way) I tried to have no sound programs on the auto-start, but it didn't change anything (I wasn't familiar with most of those programs, so I might have missed one) I tried checking for jammed keys. (The shortcut on my keyboard is Fn-Page down and neither, let alone both, were jammed) I tried to erase all the short-cuts, and that also didn't help. (actually- my shortcuts still worked, so perhaps I did that wrong)
I'm out of ideas that are obvious to me.Linux Help- Volume Control Malfunctioning?
Hi, I think its a bug with kmix or something, try the Mandriva forums cause I have never heard of the behavior on any distro I ever used.
Why not use a better distro like openSUSE, its way easier, polished and its just AWESOME!
http://en.opensuse.org/
I have my own suse blog here and here r screenshots as well
http://snake1990.wordpress.com/
http://en.opensuse.org/Screenshots/openS
Its the best distro of 2008:
http://www.bitburners.com/articles/the-b
Here r the suse forums:
http://forums.opensuse.org
The problem with Mandriva is that after every cool release one release is buggy.
openSUSE is the best :)Linux Help- Volume Control Malfunctioning?
Well, one volume control never fails. Open a terminal session and type alsamixer as a regular user. It should provide an ncurses control for your audio hardware. Esc closes the program, and your arrow keys move between and adjust sliders. M mutes sliders. you may need to get a seperate alsa tools package to use this applet on your distribution.
Also, if you want to kill a program ,you often have to use ';kill -9'; instead of just ';kill.'; Yes, lower-case kill, followed by a space, a dash, and a nine. Then, of course, the offending PID or process identification number. Xkill will get the darned thing off the screen, by the way, but won't kill the underlying stalled process.
Sorry, but Linux has a way of being obtuse. I weouldn't doubt there's easier ways to do these things on Mandriva, but I don't use Mandriva so I can only teach you distribution-agnostic methods,
Oh, and while I hate distro evangelists, I do concur with another poster that Mandriva is buggy and bloated, Sorry.
Bought new Compaq Presario V3000 need help in setting up my laptop?
I have a compaq presario v3616au, i have set up my internet, but i cannot set up my quicklaunch, the buttons above my keyboard. Everytime I press mute the colour remains blue when its suppose to turn red. I also cannot change the brightness of my laptop screen, but i can change songs with the shortcut, just the brightness is a problem. my screen looks a little bit blurry, any help in that? I have a Geforce Nvidia 7150m but i dont know how to set it up help me as much as you canBought new Compaq Presario V3000 need help in setting up my laptop?
i think you should check if you have installed all the necessary drivers for your laptop... including your video card...
i think you should check if you have installed all the necessary drivers for your laptop... including your video card...
Adobe Acrobat 8.1.2 has unsizeable dialog boxes taller than my screen. How to make them fit?
Two such dialog boxes are:
1) File %26gt; Create PDF %26gt; From Scanner... %26gt;
';Acrobat Scan';
When this window appears I can just see the top edge of buttons at the bottom of this window. If I drag the blue title-bar up as far as possible I can see parts of the names on the buttons. If I move task-Bar to the side of the screen I can then click on the bottom row of buttons, one of which is ';Scan';.
2) Document %26gt; Header %26amp; Footer %26gt; Update... %26gt;
';Update Header %26amp; Footer';
No buttons are visible at the bottom of this window. If I drag the title-bar up as far as possible I can almost see at the bottom of the screen faint hints of horizontal lines which might be the tops of buttons, but I cannot see their names and clicking over them does not close the window. Pressing %26lt;esc%26gt; acts as a Cancel and closes the window, but I have not found a keyboard shortcut to click Update or Done. If I repeatedly click the %26lt;tab%26gt; key I can see the focus move to the last visible button, then it goes below the bottom edge of the screen. Once I pressed Enter with the focus below the screen, and the window closed, accepting my Header info. I have not managed to get this to work again to make a further change to the Header.
Help! ___VanyaAdobe Acrobat 8.1.2 has unsizeable dialog boxes taller than my screen. How to make them fit?
Sometimes if you hold down Control and use the scrolling tab on your mouse, the font will get smaller/bigger. Try rolling the scroller away from you and it should decrease the size of the font only on the computer screen so that it may fit all the text.
1) File %26gt; Create PDF %26gt; From Scanner... %26gt;
';Acrobat Scan';
When this window appears I can just see the top edge of buttons at the bottom of this window. If I drag the blue title-bar up as far as possible I can see parts of the names on the buttons. If I move task-Bar to the side of the screen I can then click on the bottom row of buttons, one of which is ';Scan';.
2) Document %26gt; Header %26amp; Footer %26gt; Update... %26gt;
';Update Header %26amp; Footer';
No buttons are visible at the bottom of this window. If I drag the title-bar up as far as possible I can almost see at the bottom of the screen faint hints of horizontal lines which might be the tops of buttons, but I cannot see their names and clicking over them does not close the window. Pressing %26lt;esc%26gt; acts as a Cancel and closes the window, but I have not found a keyboard shortcut to click Update or Done. If I repeatedly click the %26lt;tab%26gt; key I can see the focus move to the last visible button, then it goes below the bottom edge of the screen. Once I pressed Enter with the focus below the screen, and the window closed, accepting my Header info. I have not managed to get this to work again to make a further change to the Header.
Help! ___VanyaAdobe Acrobat 8.1.2 has unsizeable dialog boxes taller than my screen. How to make them fit?
Sometimes if you hold down Control and use the scrolling tab on your mouse, the font will get smaller/bigger. Try rolling the scroller away from you and it should decrease the size of the font only on the computer screen so that it may fit all the text.
Your assistance please?
In detail...
I have one batch file. This batch file is designed to print the file name in a folder. The command I have used is dir d:\FolderNameWhereFilesAreLocatedToPrint %26gt; d:\foldernameWhretheTxtFileBeCreated\txt鈥?/b . And then I import these data into an excel file and I saved this file on my computer, and it was working well. But when I try to open this excel file from other computer on the same network I was able to open the file but the data can't be refreshed. Whenever I open the file a dialog box is opened saying that 鈥淓xcel can't find the text file to refresh this external data range. Then I try to change the command in batchfile in to \\mycomputername\d:\FolderNameWhereFiles鈥?%26gt; d:\foldernameWhretheTxtFileBeCreated\txt鈥?/b. but it is not worked out. Can anybody help me out in this issue. I hope you all understand my problem. This excel file is to be shared to all on my network as all have to check the file.
in this excel file i have created one macro to run the batch file. This also working in my system
While when i try to open it from other computer it is showing a dialog box Error 5. What is it and how can i solve this issue.
Macro command is
Sub vchr_gvn()
'
' vchr_gvn Macro
' To run VchrGvn Batch file
'
' Keyboard Shortcut: Ctrl+r
'
Call Shell(';\\sa\batchfiles\shtg givn.bat';, vbNormalFocus)
End Sub
FYI.
I have shared this file, shared the folder and given permission.
Otherwise can you tell me other alternative to do all this things?
What I need is, I want to know the file names which contain in a folder and I want this names in a excel file and when I click on this file name in excel I need this file be opened. by using macro or any way. Remember I want to share this file with others on the same network.Your assistance please?
A few things to check
1. the path you provide is incorrect from network pov, it shouldn't has the d:\ in the middle, cause if that drive is shared, it should become something like a folder, may be is just ';d';
2. this line
Call Shell(';\\sa\batchfiles\shtg givn.bat';, vbNormalFocus)
may be needed to change to
Call Shell(';\\sa\batchfiles\shtg\ givn.bat';, vbNormalFocus) (note:added 1 space)
3. may be use excel to call the text file instead of using bat, Dos also has problem in networking especially with xp
Hope this helps.
I have one batch file. This batch file is designed to print the file name in a folder. The command I have used is dir d:\FolderNameWhereFilesAreLocatedToPrint %26gt; d:\foldernameWhretheTxtFileBeCreated\txt鈥?/b . And then I import these data into an excel file and I saved this file on my computer, and it was working well. But when I try to open this excel file from other computer on the same network I was able to open the file but the data can't be refreshed. Whenever I open the file a dialog box is opened saying that 鈥淓xcel can't find the text file to refresh this external data range. Then I try to change the command in batchfile in to \\mycomputername\d:\FolderNameWhereFiles鈥?%26gt; d:\foldernameWhretheTxtFileBeCreated\txt鈥?/b. but it is not worked out. Can anybody help me out in this issue. I hope you all understand my problem. This excel file is to be shared to all on my network as all have to check the file.
in this excel file i have created one macro to run the batch file. This also working in my system
While when i try to open it from other computer it is showing a dialog box Error 5. What is it and how can i solve this issue.
Macro command is
Sub vchr_gvn()
'
' vchr_gvn Macro
' To run VchrGvn Batch file
'
' Keyboard Shortcut: Ctrl+r
'
Call Shell(';\\sa\batchfiles\shtg givn.bat';, vbNormalFocus)
End Sub
FYI.
I have shared this file, shared the folder and given permission.
Otherwise can you tell me other alternative to do all this things?
What I need is, I want to know the file names which contain in a folder and I want this names in a excel file and when I click on this file name in excel I need this file be opened. by using macro or any way. Remember I want to share this file with others on the same network.Your assistance please?
A few things to check
1. the path you provide is incorrect from network pov, it shouldn't has the d:\ in the middle, cause if that drive is shared, it should become something like a folder, may be is just ';d';
2. this line
Call Shell(';\\sa\batchfiles\shtg givn.bat';, vbNormalFocus)
may be needed to change to
Call Shell(';\\sa\batchfiles\shtg\ givn.bat';, vbNormalFocus) (note:added 1 space)
3. may be use excel to call the text file instead of using bat, Dos also has problem in networking especially with xp
Hope this helps.
Problem with my taskbar on Windows Vista PLEASE HELP!?
I have Windows Vista Home Premium on my laptop and recently a problem has developed on the taskbar.
The middle section (between the quick launch icons and Windows start menu %26amp; the icon tray on the right) has stopped displaying the current windows that i have open.
(for example, when i am running Firefox and Windows Live Messenger, it does not display the current windows like it should do on the taskbar).
The quickstart icons, tray icons and the menu button still all function correctly.
I have tried several different things to sort this problem out:
I have checked all of the settings (which i didn't change in the first place) to see whether anything is different and it isn't
I have restarted my laptop several times
I have tried to do system restore
I have restarted the 'explorer.exe' on the Windows Task Manager
I have ran the msconfig to check for any problems
I have change the style, colour and transparancy of my taskbar
I have tried minimising the taskbar and restarting it and still i do not know how to fix it.
The only way i can switch through programs is by using the alt %26amp; tab keyboard shortcut.
I would really like to solve this problem and so i would be very greatful for any suggestions.
Thanks :]Problem with my taskbar on Windows Vista PLEASE HELP!?
OK i have found a program that just might work for you.
Type into google taskbar repair tool download that but you to register it before you can use it i got mine cracked it fixed my taskbar no problems there. In fact ill give you the website to save you hassle hehe.
The middle section (between the quick launch icons and Windows start menu %26amp; the icon tray on the right) has stopped displaying the current windows that i have open.
(for example, when i am running Firefox and Windows Live Messenger, it does not display the current windows like it should do on the taskbar).
The quickstart icons, tray icons and the menu button still all function correctly.
I have tried several different things to sort this problem out:
I have checked all of the settings (which i didn't change in the first place) to see whether anything is different and it isn't
I have restarted my laptop several times
I have tried to do system restore
I have restarted the 'explorer.exe' on the Windows Task Manager
I have ran the msconfig to check for any problems
I have change the style, colour and transparancy of my taskbar
I have tried minimising the taskbar and restarting it and still i do not know how to fix it.
The only way i can switch through programs is by using the alt %26amp; tab keyboard shortcut.
I would really like to solve this problem and so i would be very greatful for any suggestions.
Thanks :]Problem with my taskbar on Windows Vista PLEASE HELP!?
OK i have found a program that just might work for you.
Type into google taskbar repair tool download that but you to register it before you can use it i got mine cracked it fixed my taskbar no problems there. In fact ill give you the website to save you hassle hehe.
Need help with my Macintosh?
Is there a shortcut key that will change the input language between japanese and english keyboard input setting.
I know how to change manually but, it get's really annoying when you have to stop what your typing go and change it just to put english in and then go back to writing japanese.
my friend tells me that on japanese computers, they press the tab key or something and it automatically changes it instantly, if anyone can tell me how to do this on a mac i'd appreciate it.
CheersNeed help with my Macintosh?
System Preferences -%26gt; International Control Panel -%26gt; Input Menu Tab -%26gt; ';Input Menu Shortcuts'; at bottom
Make sure the ';Show input menu in menu bar'; option is enabled.
You can also go to System Preferences -%26gt; Keyboard/Mouse -%26gt; Keyboard Shortcuts... to edit any shortcut.Need help with my Macintosh?
Yes...
Apple key + Space
Check under...
System Preferences %26gt; Keyboard and Mouse Settings %26gt; Keyboard Shortcuts %26gt; Input Menu
...if it's active.
I know how to change manually but, it get's really annoying when you have to stop what your typing go and change it just to put english in and then go back to writing japanese.
my friend tells me that on japanese computers, they press the tab key or something and it automatically changes it instantly, if anyone can tell me how to do this on a mac i'd appreciate it.
CheersNeed help with my Macintosh?
System Preferences -%26gt; International Control Panel -%26gt; Input Menu Tab -%26gt; ';Input Menu Shortcuts'; at bottom
Make sure the ';Show input menu in menu bar'; option is enabled.
You can also go to System Preferences -%26gt; Keyboard/Mouse -%26gt; Keyboard Shortcuts... to edit any shortcut.Need help with my Macintosh?
Yes...
Apple key + Space
Check under...
System Preferences %26gt; Keyboard and Mouse Settings %26gt; Keyboard Shortcuts %26gt; Input Menu
...if it's active.
Subscribe to:
Posts (Atom)