deve8ore
Last Activity: May 15 '09, 02:51 PM
Joined: Apr 4 '08
Location:
-
Good comments by all, and certainly appreciated. Thank you!! -
* Allow Mousewheel to Scroll Down *
Hello,
I've developed a form for users to enter in new info into an Access db.
The form is very long, and everyone is used to scrolling down the page via the flywheel on the mouse, however when doing this it does NOT scroll down the form, it actually goes to the next record.
Does anyone know how to turn this function off and just allow the Flywheel to scroll down the page rather than going to the next record?... -
Changing Series in Graphs via Excel VB
Hello... I have a number of graphs I receive from a 3rd party vendor, and within the graphs are charts indicating specific membership information.
I.e. - "Red Membership", "Blue Membership", "Green Membership", ect.... and the membership line could be anywhere in the chart (not just on the 2nd or 3rd line).
I'd like to run code to go through each datachart and if it includes the word "membership "... -
Thanks for the reply... I'll try it out today.Leave a comment:
-
Sharing a Linked File in Access
Hello,
I work in a department of 15 individuals and we all use an Access db to enter data and query, ect...
One of the tables in the Access db is linked directly to an Excel file which updates periodically. Only ONE user can query at a time because if the linked file is in use it will not allow another user to gain access and query. An error occurs stating "The Microsot Jet database engine cannot open the file... -
Dynamic Print Ranges
Hello, I have a workbook with ~ 20 sheets, all which upload with different data every week. We have some "old school" managers that are still requesting hard copies of each sheet.... problem for me is that the ranges per sheet can change dramatically (I.e. - from (A1:D20) to (C1:Z490).
So far I've tried to create print ranges based on the number of cell functions, and try to print, however the font in some pages can be very... -
Dynamic Print Ranges
Hello, I have a workbook with ~ 20 sheets, all which upload with different data every week. We have some "old school" managers that are still requesting hard copies of each sheet.... problem for me is that the ranges per sheet can change dramatically (I.e. - from (A1:D20) to (C1:Z490).
So far I've tried to create print ranges based on the number of cell functions, and try to print, however the font in some pages can be very... -
Thanks again.... your help is appreciated!Leave a comment:
-
Quick follow-up question....
It appears that when the file is not in any folder (main or sub folders) the macro will go right through the code without generating an error.
I tried removing the "On error resume next", however still not generating an error.
How can I implement the code to give an error such as "File does not exist" if there is no folder with the respective name?
...Leave a comment:
-
Thanks SO much!!!
I cannot even say I was even close... so thanks, it saved me time!Leave a comment:
-
Searching Main Folder and ALL Sub-Folders for File
Hello,
We have a vendor that will supply us many files, and unfortunately will place them in different folders with no uniformity (within Windows Explorer).
I'd like to have the capability to find and open the file based on name, whether it's in a main folder, or one of the subfolders. I could use a wildcard based on the file I'm trying to open.
I.e. - File named "*Net Rebate*" will be in and... -
Actually it won't matter what's in the sheets... chart, no chart, just data, embedded picture... I just want anything greater than sheet #15 deleted.
I'd also like to know how to delete named sheets from sheet named "Total" to a sheet named "Data", and everything in between. This may sound odd, but we get data from an outside vendor that can have many sheets, but their first sheet is always named "Total",...Leave a comment:
-
Hello,
Thanks for the feedback.
I've made the Excel tool so the additional sheets will always be starting at "Sheet16", and then go towards the end of the workbook.
The names of the sheets are always changing, therefore I'd prefer to have the code to delete "Sheet16" through the end of the workbook, whether it be "Sheet20", or "Sheet57".
Not all of the Sheets...Leave a comment:
-
Deleting Specific Sheets in Workbook
Hello,
I have an Excel workbook that has a number of sheets, where "Graphs" begin at Sheet16 and can either be a couple sheets, or many (i.e. 20).
Could someone assist on how I can code to select sheet16 through the end of the workbook, and then simply delete the sheets?
So far I've tried the following with no success (it eliminates some sheets, not all). Thanks in advance for your help!!!... -
Wildcard to locate file in Folder and in Subfolders
Hi.... I'm getting closer to understanding the wildcard function in VBA, however we have a vendor that will supply us many files, and unfortunately will place them in different folders with no uniformity.
I'd like to have the capability to find the file based on name, whether it's in a main folder, or one of the subfolders.
I.e. - File named "*Net Rebate*" will be in and of the following folders:
... -
Thanks.... I appreciate your help!!Leave a comment:
-
Select & Delete Sheets in Workbook using Wildcard
Hello,
I have an Excel workbook with ~ 21 sheets in it.
Let's say 7 are named "Red1", "Red2", "Red3", ect....
Another 7 are named for "Green1, 2, 3", ect...
and the last 7 are named "Blue1, 2, 3", ect...
I'm trying to write a very basic code to go though the entire Workbook, select and then delete all sheets with the name containing "Red*"... -
Populating on cell based on another cell's criteria.
Hello,
I don't know if this can be done via Excel formula, or VBA, but I have an if statement in one column that will return the number "1" if the condition is true.
I.e. J10 = 1 as C10 is true to the condition.
I'm importing the cell C10 so it's always changing, so a formula would be wiped out, however if J10 is true (and equal to "1"), I'd like C10 to read "TOTAL".... -
That is a good start... thanks!
Only thing is that when I click on "Yes", it will bold, however when i click on another cell it will unbold.
I'd like the users to select "Yes" (or "No, ect..) and have it remain bold, then move on to the next question and select Y,N, and have it bold and stay bold, unless they click on it again and it will unbold.
Since we're this far, how would...Leave a comment:
-
deve8ore started a topic Macro to Bold Font & Place Border around selected cell.....in Visual BasicMacro to Bold Font & Place Border around selected cell.....
Hello, I have a basic Excel worksheet that allows users to select:
Yes No Maybe
.... and checkboxes to the right. They unfortunately are complaining that the checkboxes are too small, and I cannot make the boxes larger, so...........
Can someone assist in the macro where they can just click on the cell where "Yes"...
No activity results to display
Leave a comment: