I have a sheet named "Data" with data imported from Access, then a pivot
table and pivot chart sheets from the source "Data" sheet. What do I put in
the code to first refresh the "Data" sheet first, then update all the pivot
table sheets and charts?

Can I insert an image and pass the file name of the image to a varaible?
Using macro recorder doesn't show anything involved with inserting an image.

I use a spreadsheet to calculate cost of a project which includes commission
percentage.
The commission is a percentage of the sell price (COST+TAX+MARK-UP). But the
sell price

Is there a way to view the VB code and step through the procedure while the
Workbook is Shared?
What's happening is:
When the workbook is not shared, the code runs fine.  But when it is shared,

Based on previous postings, I'm attempting to expand an existing macro that
worked great--- until I added the following as a precursor. It get's hung up
on this one, and stops.
Dim MyRng1 As Range

Is there any way to list all the variables used in a VBA project? I would
prefer this to also list the subroutines they occur in, but that's not
essential.
ian

I seem to have found a bug for which there seems not to be a workaround. The
following code will throw an exception, but if you change and use xls (even
using the new driver), it works.
Is there a workaround?

Hi fellow Guru's... I am curious as to why the following is causing my
macro to slow down after it loops like 50 times...
I have written some code to do the following...
1. Delete a sheet called "DataPull" and create a new spreadsheet

I need to import approx. 25  text files into an Excel workbook from a
directory. Import each text file into a different worksheet of the
workbook. Starting in row 2.
The name of the worksheet should correspond to the name of the text

Please help, I’ve searched for the answer, but my problem seems to be unique.
Here is the background: I have a spreadsheet with many, many columns of data
(“E” through “EO” as of today, and it keeps growing).  I have 9 rows of data
(rows 3 -12), so the area I’m concerned with as ...

Was hoping someone could help with this.  Not really familiar with VBA
or sure if this is possible.  Within VBA I wanted to open Notebook the
application, and then open a text file in Notebook.  I will eventually
want to loop through all .txt files within the specified folder and

I have a macro that reads in some large text files (to exceed Excel's 65k
line limit).
The macro has a couple of arrays dim'd at 300,000 rows x 57 columns.
Most of the elements are strings so that adds to the size.

I have a user's file that I would like to use the sheet tab name in formulas
that pull data from another file.  For example, "Chicago" is a string (no
formula) in cell A1, and is used in various Vlookup and Sumif formulas to
populate the schedule.  The formulas reference the ...

When trying to go from one open file/workbook to another within a VB module,
WITHOUT SPECIFICALLY PROVIDING THE FILENAME, I'm getting an almost random
selection of choices.  Specifically, my macro resides in 'Window 3' of the 3
open workbooks.  If I try "Windows(1).Activate" from ...

I started a post but it became too complicated. So here is my problem
I have 3 or more open worksheets
One is named Tempdata.xls and is not active.
In the active workbook I have the following macro by Alex-