Search:

OK thank you very much for that code. It just seems convoluted to me I guess. It would be far preferable if the operation that created the copy (i.e., wsPaste.Paste) returned a reference to the...

Thanks for that post, vbfbryce. This is currently copying the pic from one sheet to another:


Dim srcSht As Worksheet
Set srcSht = ThisWorkbook.Sheets("MyFirstSheet")
Dim destSht As...

By the way, I do have one instance of the image I'd like to copy in my Workbook on the first sheet. I can get a reference to it this way:


Sub Macro1()
Dim sht As Worksheet
Set sht =...

Forgive me, but I'm more of a FOSS web dev than a MS guy. I just don't have all that much recent experience with Office dev.


I'm not really sure what this would entail. In particular a...

I'm working on an elaborate macro which will automatically create and format a bunch of worksheets. I want to add an image logo to all of these sheets. I may be able to copy a shape object from the...

Thanks for the help. This is all working satisfactorily now.

UGH. Hate this kind of thing. Seems like it'd be so easy for them to fix it themselves.

I read a "Microsoft Excel Support Team" blog post here (why is this blog not hosted by microsoft.com??) and...

Ugh! Sorry for random postings here....I didn't see this.


I have the sheets named (menu, model, data, etc). I want to add this particular button to the menu sheet. So far something like this:
...

Thanks for this clarification! Still having trouble finding the right syntax/path/reference to refer to an existing button on a particular sheet. It's been forever since I created it but I think it's...

I have repeatedly tried to insert an ActiveX button, but get an error dialog that says Cannot insert object.

I am unable to give my existing button any kind of identifier -- there simply is no...

You can't just refer to btn1 though can you? I've defined a worksheet var and see nothing attached to it that might let me grab a reference to the existing button. My workbook has numerous sheets and...

So you are getting all of the new button's parameters from the old button, correct?

Any thoughts on how to locate my existing button? It is not created via macro so I have no reference to it.

I've got an elaborate macro that adds a button to one of my worksheets next to another button I have added manually to that sheet.

When I manually add a button in Excel, I do not have any option...

OK duh that sounds helpful. How might one exit nested for loops? e.g.:


For row = FirstRow To LastRow
For col = CustomAttrColStart To LastCol
If Not...

Thanks for your detailed response. It totally jibes with my additional conversations about the issue. I'd give you more rep but cannot until I spread some around.

As it turns out, I have convinced...

I have a subroutine that performs some operations and then starts iterating through an Excel spreadsheet's rows and columns. Obviously, this requires a nested loop to iterate rows and columns,...

Thank you so much for your response. A couple of questions.


This is precisely the question I was asking. Doesn't the screenshot above clearly indicate Release=378758 which, according to this...

Thanks for the links. Those seem to jibe well with a couple of setups I found that permit access via SSH protocol -- which would be ideal in my case because it would not interfere with the web server...

I've got a virtual windows server set up with a cloud provider. A dev on my team tells me that we are developing our web application for .NET version 4.0 because "that's what is installed on the...

I was not really sure where to post this so I thought I'd put it here.

On one of my projects, I have been tasked with setting up a git server on a windows machine. I've googled around a bit and...

It does not.


I neglected to indicate this in my post, but the lines of code worked fine for weeks and appear to have no inherent condition or runtime possibilities which would force a debug halt...

I've got an Excel macro I've been working on for some time. I keep having this problem when testing it where VBA pauses the macro and shows a dialog that says "Code Execution Has Been Interrupted"...

Oh my. So when I use set like this:

set myVar = ServerResponse.Data // a Collection or Dictionary object
Does that mean that I am cloning the object or that I am assigning something by reference?...

Excellent. Why does one need the 'Set' keyword in there? Seems gratuitous and yet the code won't run without it.

(sorry, not from VBA background).

I've got a workbook with macros in it. I want this macro to add a worksheet to the workbook in which it exists. I see it's pretty easy to add a worksheet to the Activeworkbook but I'm concerned that...

I suppose I should clarify. I realize that Microsoft provides all kinds of DLLs and components full of functionality that you can can use rather than reinventing the wheel. I guess the puzzling part...

Thanks for this informative post.


I found this and have it working pretty handily.

Thanks for the very informative post. I find it puzzling that one must wrangle with the absence/presence of different components like this and write contingency code should one prove missing. Is...

I'd like to have my Excel spreadsheet access a RESTful service running on an apache web server. I found this post on stack overflow but it still leaves a lot of questions:
1) If I add these...

Please be warned: I am not well acquainted with .NET programming as I only have occasional need for it.

I'm working with a smallish app/solution written in VS 2003 (VB) and I want to make it run...

Now THAT is a concise explanation and I truly appreciate it. I have solved the situation by defining a function which accepts a string value as parameter and which performs the necessary parsing and...

Thank you for your response!

If the user were to enter something like "flibber" in the text box, an exception would be fine. The issue is that the exception occurs when a) there is valid input in...

For some reason, this line of code is throwing an exception:
Gallons.Text = IIf(Gallons.Text.Trim().Length > 0, Format(Convert.ToDecimal(Gallons.Text), "#0.0000"), "")

Gallons is a Textbox...

I'm still pretty new to VB.NET but have been working on a project for a few weeks now. My fellow devs and I maintain this project in a repository using SVN. Today, we encouraged the client to...

I appreciate the help and hope I don't sound too obtuse here. Perhaps I need to rephrase this question. I think part of my confusion here is that my programming background is in weakly-typed...

The form control initialization is accomplished using a convenience function and having looked at it, I believe this function is written smartly enough to initialize the control properly. The data...

Your code:

If DateTimePicker1.Value < Date.Today Then
MessageBox.Show("Date cannot be before today.")
e.Cancel = True
End If

looks more elegant than...

Thanks for your response, jmcilhinney!

Unfortunately, there are two reasons why I cannot rely on the DateTimePicker's ability to prevent entry of dates before today:
1) The DateTimePicker is...

I am working on a dialogue that uses a DateTimePicker. I have to a) make sure a valid date is entered and b) make sure the data is >= today's date. I'm wondering if there's a good quick-and-clean...

I've been using VS2010 Express to edit forms in a VB.NET solution. I have been using TortoiseSVN to connect to an SVN repository and manage the update/commit of my files.

Today, I am trying to...