delete all data from the sheets leaving just the VBA passsword
protected code, attach the file, once you have the password you can
paste back the data.
On Feb 20, 10:50 am, sunil sasidharan
wrote:
> Hi,
>
> I wont be able to send the file as it has some confidential data of our
> organisations.
>
To crack the password of an VBA Macro / coding first download an HEX
Editor
its available from the site
http://www.chmaas.handshake.de/delphi/freeware/xvi32/xvi32.htm
(its a very small file of 0.5 MB capacity)
Close the workbook and open the workbook file in the hex editor. Find
the string "DPB"
Dear All
I found vb code to login in website on below mention link. its
Amezing.!
http://vbadud.blogspot.com/2009/08/how-to-login-to-website-using-vba.html
Dim HTMLDoc As HTMLDocument
Dim oBrowser As InternetExplorer
Sub Login_2_Website()
Dim oHTML_Element As IHTMLE
Here's an example with one way to do it. Let me know if the formula is too
complex & I'll walk you thru it.
On Wed, Feb 17, 2010 at 10:49 AM, Maitre Bart wrote:
> Hi,
>
> I have some source data in one sheet (Calculations) and formatted data
> in a second sheet (Output).
>
> In the Calculations
A couple of points:
1. IFERROR doesn't work on versions older than Excel 2007.
2. Second, if your concern is speeding up VLOOKUPS, switch to a combination
of INDEX & MATCH. It's much faster.
On Sat, Feb 20, 2010 at 8:07 AM, Ayush Jain wrote:
> Ayush Jain has sent you a link to a blog:
>
> Dear
Hi,
I wont be able to send the file as it has some confidential data of our
organisations.
Please let me know how do i go about cracking the password.
Regards,
Sunil
On Sat, Feb 20, 2010 at 10:04 AM, ankur wrote:
> send ur file
> Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
Ayush Jain has sent you a link to a blog:
Dear Group, Here is a wonderful Tip about Vlookup. To get regular
updates on Excel Tips...Just follow us on Twitter @
http://twitter.com/exceldailytip Thank you. -Ayush Jain Group Owner
Blog: Excel Daily Tip
Post: Check VLOOKUP Formula for #NA Error witho
Hello Bro,
attach file
On Sat, Feb 20, 2010 at 3:06 PM, neo wrote:
> Hi all,
>
> Even i have a similar problem, i had saved the excel sheet with the
> VBA macro as the .xla (excel add-in), and have forget the password of
> the VBA code. Does anyone have any tool for breaking the code.
>
> Rega
Hi Paul,
Nice one. Good job done
Thanks,
On Sat, Feb 20, 2010 at 10:07 AM, ankur wrote:
> hi sastry
> i think ur query has been solved by paul , for any more clarification
> u can post ur msg
> Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Different)
>
> I'm not
Hi,
Another easier way of Cell Referencing is that Place "=" sign then click the
source cell in any sheet to set a reference of this source cell.
Thanks,
On Sat, Feb 20, 2010 at 1:56 PM, Christopher Luka <
christopher.l...@gmail.com> wrote:
> If I'm not mistaken, what you're looking for is a *f
Hi all,
Even i have a similar problem, i had saved the excel sheet with the
VBA macro as the .xla (excel add-in), and have forget the password of
the VBA code. Does anyone have any tool for breaking the code.
Regards,
Durgesh Kumar
On Feb 20, 9:38 am, ankur wrote:
> plz send ur file
> Have A Ni
If I'm not mistaken, what you're looking for is a *formula* that will
dynamically grab the value from Sheet1!A2 for Sheet2, Sheet1!A3 for Sheet3,
Sheet1!A4 for Sheet4, etc. If so, then the attached file should work for
you. Note that this formula VERY MUCH depends on the fact that the
worksheet n
12 matches
Mail list logo
