Dear Bé Trần Vă,
Thanks very muchfor solution
But if i want to Fixed cell in sheet then how to work code Bcos I fixed two
cell in my sheet if there click calender then date show that specific cell
only not anywere in sheet.
Appreciate Help sir
Regards
Amar
On Wed, Jan 15, 2014 at 3:26 PM, Bé
Hi All, I am trying to run a batch file from a VBA code. Both the excel file
and the batch files are placed in the same folder.However the batch file does
not extract names when I run it from VBA, if I do it manually then It works
fine. Mentioned below are the codes, what could be the issue ?
First of all, I think the problem is that you don't know what the Current
directory is for your Excel instance.
When you execute the .bat file manually,
You're probably using the keystrokes:
C:\
cd \Users\User\Desktop\mails\Rename\
Extract
The portion of the command myfiles.txt
redirects the
Dear group,
I have a only small question: Is it possible to make copy of a file via VBA
eg make a copy of a file with name:*D:\data\sample1.txt* and name the
new file *D:\data\sample2.txt *
Kind regards,
Peter
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
Hi,
This is Anup Kumar from Gatix E-solutions
Contact me by mail to ge...@gatixes.com
Please have a look at below mentioned requirement and reply with details
mentioned below.
Full Name:
Email:
Phone:
Skype ID:
Location:
FULL ADDRESS WHERE YOU LIVE NOW:
Please list the name of
I pull data for individual customers from a source system into an Excel
workbook. I have a separate Excel workbook template that contains macros,
which allow me to reformat the data in the source workbook. I am trying to
add another macro that will do additional formatting, but when trying to
HI !
Hi,
Congratulations on the great work on google groups
I am sure that you are well aware that MS Excel is a key job-skill today.
However, most students and working professionals have no idea where to
start. To enable all this we have launched the *World Excel Championships* with
US$ 500 in
Hi Excel Users!
Hey guys! dezyre.com is organizing a world excel championship with a cash
prize of Rs. 30,000 and no registration fee at all. Its time to hone our
talent and test our skills. Lets participate in this championship and test
our MS. Excel skills and abilities.
Regards,
Nikita
--
Hi Excel Users!
Thank you Ayushi for providing us a platform where people with common
interests can share their views,
My name in Nikita and I am currently pursuing an Online Course in Microsoft
Excel for Business Professional from dezyre.com an online teaching academy.
While doing this
Hi Group,
I have created few images using the camera tool in excel 2007 and windows
xp. now my system has been upgraded to MS2010 with windows 2007.
Since the time the system has been upgraded all the images in all files
are increasing automatically to a fix size .
When I try to reduce the
Dear JCraig,
Please could better elaborate your question including some lines manually
with the desired result
rgd,
Basole
Em quarta-feira, 15 de janeiro de 2014 18h35min23s UTC-2, JCraig escreveu:
Hello Forum.
I use this forum extensively for review and research yet I have never
SURE! Thanks for reading over my post. You are saving my life literally!
A sample of the desired result has been attached as requested.
If you see the grouped values in column H (course#):1, 602 and 0006_82
for instance, and look at the corresponding rows in Column G (description),
the
Hello All:
To created a class module for the execution of a macro by any userform
command button the declaration is:
Public WithEvents ButtonGroup As MsForms.CommandButton
Do you know how to declare the same thing for a group of checkboxes
embedded on a worksheet?
Thank you,
-
Hi MLT,
Try using below formula which need to be confirmed using key combination:
ctrl shift enter
=IF(ISNUMBER(MATCH(A5,MID($A$1:$A$3,MIN(IFERROR(SEARCH($A$4,$A$1:$A$3),))+2,1)*1,0)),Matching,NotMatching)
Regards,
DILIPandey
On Tue, Jan 14, 2014 at 6:10 PM, MLT mlthorn...@gmail.com wrote:
Hi.
I have macro code below. In layman's terms, can someone tell me what
exactly it means. Am trying to learn macro
'Enter Op. Bce
AccName = Cells(5 + I, 2)
Cells(5 + I, 3) = Sheets(AccName).Cells(8, 7)
Regards,
Boreh
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
Hallo to you all.
I converted an excel 2003 with macro to a 2010 excel enabled macro by using
save as option. I now get an warning every time i save. The message goes
like this *Privacy warning: This document contains macros, ActiveX
controls, XML expansion pack information, or web components .
Hi Boreh,
Assuming I = 1,
That code is assigning available value in cell B6 to a variable name
AccName and then on the next cell i.e., Cell C6, it is populating the
value of G8 picked up from sheet whose name is there in Cell B6.
Cells(5 + I, 2) is B6
Cells(5 + I, 3) is C6
Cells(8, 7) is G8 of
Can you upload that file (after removing sensitive data) ?
Regards,
DILIPandey
On Thu, Jan 16, 2014 at 10:32 AM, Robinson Boreh rbo...@gmail.com wrote:
Hallo to you all.
I converted an excel 2003 with macro to a 2010 excel enabled macro by
using save as option. I now get an warning every
You can follow the following steps to avoid the privacy warning.
1 Menu Button on the top left of the excel window
2 Excel Option
3 Trust Center
4 Trust Center setting
5 Privacy Options
6 un-check the Remove personal information from file properties on save
On Thu, Jan 16, 2014 at 12:50 PM,
19 matches
Mail list logo
