Hello,
I'm Joe M, freelance consultant and VBA app developer. I do a lot of work
developing VBA apps in Excel and PowerPoint. It seems that there are very
few limitations over what you do other than the scarcity of VBA
documentation for PowerPoint. Anyone have any sources?
Thanks
I apologize for not following forum rules, I just read them :( Any thread
in the future I will make sure is formatted correctly.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.c
Hi everone, I've been trying to figure out how to do this for a few days
now, and decided to ask for help.
I want to make a button macro that, when you click it, it displays a value
of a cell in a diferent cell, and each time you click it it displays the
cell below.
*In other words:*
I want t
How do I convert a subtotaled spreadsheet with 1000 lines into a short list
of only the totaled lines?
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RUL
I am hoping some one can help me.
Here is what I need.
We are using one excel spreadsheet at work. This one excel spreadsheet has
7 different worksheets for 7 different users. All users have their own
password to protect and un protect their work. All their work is linked to
an 8th worksheet
first suggestion, create two instances of excel. have one do your
macros, the other you can use freely.
maybe your concern is not with excel, but the weight of your SQL
queries.
if you're aggregating a large amount of data, the time it takes your
DB server to process the query will freeze your
Hello all,
I have some hyperlinks in Excel 2007 that point to an external
webpage. Rather than clicking the hyperlink, copying the data, etc.
I'd like to have a function/macro that would grab the contents of the
webpage based on the Hyperlink and populate another cell in the
spreadsheet with the
Hi everyone. How can I find out the password of a protected sheet?
I can't actually break it, but I just need to unlock it to fix something and
then re-protect it.
Any ideas?
--~--~-~--~~~---~--~~
--
quot; & I).EntireRow.Hidden = True
> End If
> Next I
> End If
> End Sub
> '==
>
>
> --
> *From:* Joe Wilson
> *To:* excel-macros@googlegroups.com
> *Sent:* Wednesday, April 29, 2009 1:57:04 PM
> *Subject:* $$Excel-Macros$$ Re:
ntireRow.Hidden = False
> For I = 3 To 1000
> If (Cells(I, 1) >= 3) Then
> Rows(I & ":" & I).EntireRow.Hidden = True
> cnt = cnt + 1
> If cnt >= LastRow Then Exit For
> End If
> Next I
> ElseIf (LastRow =
Hi group. Could someone help me with shortening the below Macro. Basically
I want to hide rows that start with the number 3 and goes to 18 or higher,
and you can see below how I did it the long way.
Is there a way I could have an input box popup that would ask me the # of
rows that I want hidden
Hi chaps,
Can anyone please tell me how I disable the flood of emails I get from Excel
Googlegroups other than those pertinent to any questions I post myself ??
Thank you
Joe
.Path) = "xls") Then
> If File.datelastmodified > LastFileDate Then
> LastFileDate = File.datelastmodified
> LastFileName = File.Name
> End If
> End If
> Next File
> MsgBox "Last file: " &a
appreciated.
Thanks,
Joe
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group
ct
> file to be attached. Click Open. That's all there is to it. The selected
> file will be attached to your message.
>
>
>
> On Thu, Jan 8, 2009 at 4:14 AM, Joe wrote:
>
> > I have Tom, but how can I attach the spreadsheet for you to view ?
>
> > On Jan 5,
I have Tom, but how can I attach the spreadsheet for you to view ?
On Jan 5, 9:53 pm, "Tom Jeffries" wrote:
> Do you have an example of the Calendar? Describe its format in more detail.
>
>
>
> On Mon, Jan 5, 2009 at 5:18 AM, Joe wrote:
>
> > > I wonder i
> I wonder if you can help out an absolute novice when it comes to excel
> macros.
> My girlfriend has sent me some homework as she has to work today and I am
> at home trying to read up on Excel Macros 2003...
> She needs to be able to look through each of the day cells in her excel
> calen
17 matches
Mail list logo
