How do i execute a VBA function by clicking on an excel cell?I am trying to open a file in a program (Microsoft) by clicking on an excel
file.
Initially I tried a regular hyperlink, but excel seems to ignore the
[filename] part of: c:\directory\ustation.exe [filename] where
[filename] is the actual name of the file. Excel only opens the program, not
the file as well. Where as this DOES work as a command prompt from a command
window.
So I have written a function in VBA which does work. But I can't get excel
to execute the function when I click on the cell, like a hyperlink.
How about just putting a little button from the Forms toolb...
VBA codingHi everyone
I am very new to vba coding. Though time to time I record macros. Some I
want to edit my macro but I don't the vba codes. It there a place where all
the codes/coomanda are stored.
thanks
Nadeem
Hi
the easiest way to access your macros to edit them is to choose tools /
macro / macros, click on the macro you want to edit and press the EDIT
button - you'll be taken directly to the appropriate code.
(to get back to the workbook you can either close the code window, using the
top X or use ALT & F11 to switch back and forth between the VBE Window & the
workbo...
only display active HR benefitsThere is no option to mark a master HR life, retirement or health benefit as
inactive. In addition to being able to mark a master HR benefit record as
inactive and roll-down changes thru HR and Payroll, it would be significantly
helpul to clients with a lot of plan and therefore code changes each year if
there was a setup option to 'only display active HR benefits' in the lookup
windows when creating/editing employee records.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, clic...
VBA for Excel 2000 file is corrupt
Hello,
I have a strange thing.
There are different functions which are creating some excel sheets, in
these excel sheets is temporarily data created and after the create the
sheets are deleted.
With Workbooks(Substn_WB)
Worksheets("temp_KV").Delete
Worksheets("temp_CBTYP").Delete
Worksheets("temp_XFMR").Delete
Worksheets("temp_LINE").Delete
Worksheets("temp_DCLN").Delete
End With
The temporarily data is used for three existing sheets which where
before the create and after the create still there. If the excel file
is closed by:
Workbo...
Populating a ComboBox from VBA with 2 columnsHi I need to populate an excel combo box with recordset
fields i already retrieve from an SQL Database. I need to
columnes code and description. For example: Employee ID
and Employee Lastname. Y need to show the Lastname in the
combo and retrive the selected Employee ID from it.
I tried
ComboBox.AddItem()
But I could only add an item with one field. How can I add
the couple Employee ID - LastName? (I discard the
concatenation method).
Regards
Daniel
If those values are on a worksheet in adjacent columns, you could pick up that
range and dump it into an array. Then use the array to f...
CDN Payroll and HRAre there any companies out there...actually running
this ..successfully???
We have just upgraded to 8.0
Thanks
MLF
We have just started the HR side however we are using 7.5 still working out
the bugs. We won't be upgrading to 8.0 not until those bugs are worked out.
Good Luck!
"anonymous@discussions.microsoft.com" wrote:
> Are there any companies out there...actually running
> this ..successfully???
>
> We have just upgraded to 8.0
>
> Thanks
>
> MLF
>
Be very carefull updating as it caused one of our
companies not to upgrade properly.....
Calling GP existing report from vba codeDear All,
Can anyone show me that how to call the GP reports from VBA code.
Best Regards,
--
Habeeb.
...
Life Insurance table in HR moduleIs there any way to increase the decimal places allowed for Insurance Rates?
For example our payroll is processed weekly, but the life insurance rate is
monthly. So when it is $0.25 / 1000 per month that is $0.577 /1000 per week
and the system ONLY allows 2 decimal places.
Anyone worked around this?
--
Mark
VA
Yes, allow three decimal places for deductions.
--
Charles Allen, MVP
"Mark" wrote:
> Is there any way to increase the decimal places allowed for Insurance Rates?
> For example our payroll is processed weekly, but the life insurance rate is
> monthly. So ...
HRMy company frequently has to override the Worked Hours Per Year, under the
Additional Information button on the Employee Maintenance Screen. When the
number is changed without changing the Employee Class (The employee class
doesn't need to change), we are not given the option to save with a reason
for change or an effective date. Is there any way to save changes to the
Worked Hours per year so we can have this option without changing the
Employee Class?
--
Becca McElroy
I'm not aware of a way to force the system to provide you with a prompt for
reasons for change for fie...
How do you reconcile Vac/Sick time between HR and payroll in GP 10How can vacation and sick time be reconciled in GP 10.0? If you go to
Utilities>>Human Resources >> Reconcile. There is not an option to reconcile
just "reset Payroll vacation and Sick Time Information". I would like to
reconcile the times between both modules.
--
Thanks for your help
In V10, you can have more than two buckets of PTO tracked and accrued,
so it is no longer stored in the PR vac and sick time buckets like it
was in prior versions (this is why there are new instructions on how
to add the PTO buckets to the payroll check, as it uses a new array
fiel...
Reasons to use OUTLOOK over ACT! 6.0?Is there an advantage to using OUTLOOK over ACT for contacts and
followup on contacts? Is ACT and OUTLOOK basically the same product,
different vendors?
I have never used ACT but I am sure these two are probably close to being
the same. Outlook is a more commonly used product then ACT, so if you have
problems you would probably be able to to find a fix faster then ACT. There
are lots of features with contacts / tasks and allowing users to share
specific things with other users. I hope this helps you out a little!
Thanks
"BoDEAN" <jbo@not_a_valid_email_addy.com> wrote in ...
IncludeText Field CodeI am experimenting with creating a master document from several subdocuments
using the IncludeText code. So far, as long as I don't mess up the path, it
works well. My question is this: When I list each IncludeText field on a
separate line in the "master" document, the resulting imported text includes
the paragraph return at the end of the line with the field code and this
means that I end up with a double return between subdocuments. The only way I
have found to work around this is to, essentially, place all of the field
codes in the same paragraph. It works, but f...
Passing a range from worksheet to VBA functionHi all -
I have the following function:
Function regression(x, power())
For i = Lbound(power) to Ubound(power)
regression = regression + x^i + power(i)
Next
End Function
and wish to use the following in Excel
=regression(A1, B1:B3)
But I can't seem to get it to work. What am I missing?
Thanks!
Ryan
On Nov 19, 12:46=A0pm, R Beck <R B...@discussions.microsoft.com> wrote:
> Hi all -
>
> I have the following function:
>
> Function regression(x, power())
> =A0 For i =3D Lbound(power) to Ubound(power)
> =A0 =A0 =A0regression ...
Modify CodeI am trying to access the Itemlookup code for an item when an item is
added to my screen (using hook 4).. The code I currently have loops
through all the items I have on the screen. All I want is the
ItemLookupCode for the item added to the screen
Currently this works but loops through all my items on the screen.
Dim E As Object ' QSRules.TransactionEntry
For Each E In Session.Transaction.Entries
LookupCode = E.Item.ItemLookupCode
Next E
Could someone help modify this.
TIA
Chuck,
Try using the property below:
TransactionEntry.Key Property
The Key property gets the key fo...
HR Filters should be applied to HR ApplicantsHR Filters should be applied to Applicants in the same manner as they are to
Employees.
For example, if I have five applicants that are setup with Management as
their department and have applied filters – selecting other departments to
view but not management – my five Management applicants should not be able to
be viewed by the user that the filters were applied to .
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do no...
Changing case in codeI've added a line of code to the event below that will uppercase the data in
the last-edited cell but the update takes a few seconds on my PC (probably
longer on the production pc it will eventually run on). Is there a way i can
better place the Ucase code? I've tried, unsuccessfully, to move it outside
the For/Next loop. I won't pretend to understand the Set statement.
Any help would be gratefully appreciated
Terry
Private Sub Worksheet_Change(ByVal Target As Range)
'David McRitchie, 2000-08-08 rev. 2000-08-14
'http://www.mvps.org/dmcritchie/excel/event.htm
...
hr:0x80040005Messenger couldn't install because we had trouble installing this requirement:
*Microsoft Visual Studio Runtime
Check to be sure you are connected with the Internet. You cannot download
Windows Live programs unless you are connected to the Internet. hr:0x80040005"
i use xp sp3, help me plz, blessing
Greetings,
More than likely you have the necessary runtime already installed with another application.
Finding out exactly why this is erroring out will require a lot more work. As such, if you
just want to bypass this and install Messenger right now, you can do so manua...
HR Vacancies ReportHow do we get a report showing all HR Vacancies?
You create one using your favorite report writer.
--
Charles Allen, MVP
"Elaine" wrote:
> How do we get a report showing all HR Vacancies?
...
Advanced HRDoes anybody have any idea why we keep finding the latest version of the
Advanced HR and Payroll suite continuing to act like it has to convert the
tables and grant permissions ever time you go into a company.
Then after running through all of that, it gives a series of Error 5
messages you have to click through before allowing a user to get into GP. We
also had the same crapping issue of having to break open the download version
of the latest HR/PR msi to get it to install. Is Microsoft ever going stop
causing us so many hours working around the latest set of code production
issues. ...
Print codeHello,
I have a marco recorded to print a selection of sheets. The printer being
used is on a network and not my default printer. When I create the code on
my PC, it works fine, but as soon as another user tries to use the code from
their PC it won't work. Code is attached below, when I tried to create the
code on another PC, the section Ne04 in both lines is the only thing that
changed. Is there a common statement that could make this work regardless of
the PC from which I'm opening the file?
Application.ActivePrinter = "\\mrafp1\MRA-ADMINCP1 on Ne04:"
...
Code of searchforrecord 2007I am having trouble with the code for the following task
Table: Master List
Form: Home
Form: Details
I am trying to get a button on 'Home' that will search a field in 'Master
List' called ID for a value that I input in a text box on 'Home' and return
that record in the form 'Details' for editting.
Please HELP
Is Details a subform of Home?
If not, is Details already open or does it open from the button?
Is Master List the row source for the Details form?
If you can answer these questions, I can show you how it is done.
--
Dave Hargis, Microsoft Access MVP
...
Wherre best to place code
I have an excel workbook that uses active -x controls. It allows the
user to model the performance of a micro-scale wind turbine (small
device that fits onto a rooftop). I have VBA code that is located for
each worksheet, some that is contained in Forms and other code that is
located in modules.
My question is: in terms of keeping the workbook small and running
quickly is it Ok to have code for each worksheet or place it in
modules?
thanks, luke
--
luke
------------------------------------------------------------------------
luke's Profile: http://www.excelforum.com/member.php?...
Where do I get codes from?Hi, I'm a new user of MS Access and I need to find out where to find the
codes for formulate reports in the system. Most of my report are very basic,
but I'm not able to find where to go to enter any fuctions or sums for
fields....Can someone advise me on this...also, does anyone know how to tell
the system to calculate a blank field. For example, if I want to run a report
that shows no completion dates or the fields are blank, how would I do that?
I know this is very basic, but I haven't used MS Access in years and I'm not
sure where to go to retrieve info....
A common...
Entering 401(k) vs. Roth 401(k) Contributions-reason to differentiI have a 401(k) account that I've been tracking in Money for about 8 years.
My employer recently offered the Roth 401(k), and I have recently switched
all of me new contribuitions to the Roth 401(k). Is there any way, or maybe
the more important question is any "reason", to indicate which contributions
are to the regular 401(k) and which are to the Roth 401(k)? On my
statements, all contribuitions appear to go into the same account, i.e., are
not separated out by type.
In microsoft.public.money, northwoods24 wrote:
>I have a 401(k) account that I've been trackin...
HR DeductionI increased a deduction in HR from 5% to 10% and it updated Payroll
automatically.
I also reduced a deduction in HR from 5% to 2% and it updated Payroll
automatically.
But when I changed a 401K deduction to 0%, it did not change payroll from
the 3% it was to the 0% I wanted. Why did this not work?
I have the user preference "Payroll view for Human Resources" checked.
I also have the Benefit Preference "Automatically Update Payroll Benefits &
Deductions" checked.
Thank You
--
Mary Beth
...