Hi Ayush,
I can help on content development time to time.
Congrats!
Cecilia
On Feb 2, 10:39 am, Ayush wrote:
> Hello everyone,
>
> I am glad to share that I have decided to launch an excel knowledge website
> for this group.The website will be launched on 4th anniversary of this group
> i.e.
I'm just one of the 7.000 group members, so I represent less than
0.01%. But in my opinion, if we are 7.000 members, is because this
group day after day helps people to solve Excel / VBA questions and
learn more on this topic. The focus is Excel and VBA Macros, as the
group name says. If I was look
Hi, I have two files: FileOrigin and FileDest. I execute a Macro in
FileDest, and select the FileOrign with
Application.Dialogs(xlDialogOpen).Show.
1) FileDest as a unique ID in sheet “Track”, cell AQ7. This is text
and numeric (example IFS-gs21e3). Also has a list of Providers in
range C84:C133.
Hi Paul,
Ops, I’m sorry I posted the file as a different post; I didn’t know
how to do it following the original! I definitely agree with you,
a .vbs operated centrally after end user signs off on his
data entry. Then if I understand, user will sign off by exporting part
of the Tracking sheet to a
eparate e-mail
(same subject) with the Excel file. May be it looks too complex for me
but it is easier than what I see
THANKS!
Chechu
On Apr 8, 1:01 pm, paulwillekens
wrote:
> There are two sides:
> a) the user side: if a1:b20 is all the sheet contains, the user could
> save
t, I never worked with this kind of export/import out of
Excel
THANKS a lot,
Chechu
On Apr 8, 6:19 am, paulwillekens
wrote:
> Hi Chechu,
>
> Why not export that particular range in a .csv file, that would be
> stored in a dedicated folder on the network, and imported by Access on
&
Hi, I need some help in an export from Excel to Access macro. I have
an Excel tool which will be used by many users. In this Excel, I have
a range, let's say in Sheet 1, A1:B20, that I need to export to
Access. I mean, each user will have to click a button and export to an
Access database located i
Works in Excel 2003, not sure about 2007:
1) Insert in your worksheet the shape that you want later in the chart
2) Select the shape, and CTRL C (copy)
3) Select the chart, select the bubbles you want to change, and CTRL V
(paste)
Hope it works in Excel 2007.
On Jan 7, 8:05 pm, Keith25252 wrote:
Not sure if I am correctly understanding the request here, but I
use the following code in some of my tools to track users usage:
Sub Auto_Open()
Dim serverfile As String
serverfile = "\\org\public\Hittrk\history.txt"
On Error Resume Next
Dim str As String
str = Application.UserName
str = str
So no suggestions
On Oct 4, 1:37 pm, Chechu wrote:
> Easier!! Given a sheet with the format I sent, I need to create an
> output sheet opened by resource location.
>
> On Oct 3, 3:33 pm, jamesdavey wrote:
>
>
>
> > so you mean, for example, you want to
Easier!! Given a sheet with the format I sent, I need to create an
output sheet opened by resource location.
On Oct 3, 3:33 pm, jamesdavey wrote:
> so you mean, for example, you want to add a new resource manually,
> then press a button perhaps to update an output sheet?
>
> On 3 Oct, 12:42, Cec
Sounds good Paul!! Thanks!!
On Oct 3, 4:52 pm, Paul Schreiner wrote:
> Actually, I might be able to help here.
> I'll have to wait until I get back to work on Monday though!
>
> Paul
>
> ____
> From: Chechu
> To: MS EXCEL AND VBA MACROS
nd cause for termination.
> '=
>
> But if the reason is that the files reside on remote
> computers, but the VBA code isn't actually "locked",
> then I can send you some code that you can
> modify to remove th
Yes, that's the challenge!! I can't unlock the VBA Code, because the
file resides on each user's computer. I have to send a new file with a
Macro to update it
Thanks!
CC
On Oct 1, 3:49 pm, Paul Schreiner wrote:
> If you can unlock the VBA code, then it's fairly simple
> to remove an entire m
Hi Bunty,
Take a look to the following code, might help. It opens each .xls in
the same path where this file resides, and copy-paste predefined rows.
Regards,
Chechu
Sub Macro1()
Dim MyFile, MyPath, MyName, ThisFile, Location, PathFileTemp, Fila,
ThisSheet
'On Error GoTo ErrorHa
Forget it, solved! Just need to uncheck the option "Save data with
table layout" in the PivotTable options...
Thanks anyway!
Chechu
On Sep 11, 3:23 pm, Chechu wrote:
> Hi, I am looking for some help on this! I have an Excel file with a
> Pivot Table, using as sourc
ach a sample file, but I don't see any button to do
it :(
Thanks!
Chechu
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and T
Hi Mahesh,
I was not able to open your file since I'm with Excel 2003. Please,
could you save as 2003 and re send? If you can have sheet 1 sorted
ascending, I think that you could use Vlookup without "TRUE" argument
at the end.
Thanks,
Chechu
On Sep 5, 4:07 am, Mahesh wrote:
Hi,
If I understand, you might solve it by doing:
Your Data New Column
Column A Column B
-0.01 =IF(A2=0,0,B1+1)
0 =IF(A3=0,0,B2+1)
-0.002 =IF(A4=0,0,B3+1)
-0.005 =IF(A5=0,0,B4+1)
-0.01 =IF(A6=0,0,B5+1)
-0.004 =IF(A7=0,0,B6+1)
0 =IF(A8=0,0,B7+1)
-0.003 =IF(A9=0,
Hi,
If you will have a "." and space separating the supplier name, you can
try: =RIGHT(A1,(LEN(A1)-FIND(CHAR(46),A1,1)-1)) where A1 is the cell
with the supplier name.
Hope it helps!
CC
On Aug 11, 3:43 am, Suhas wrote:
> Hi,
>
> We have a file which is downloaded from HTML page.
>
> The data
20 matches
Mail list logo
