Visual Basic :: Lotus Macro To Excel Macro Please Help!!

Access Create Lotus Object, Lotus Runs Macro??
Hi all,
I have this problem, I want to export data to Lotus123. Questions:

1. Lotus is not in Tools-Reference object library. Where can I get and how to add it.

2. From Access I want Lotus123 to run a macro. This macro will open the file I created by the Access..transferspreadsheet method (saved as WK1). Then the macro will reformat and make the sheet look nice, etc..

I did something similar in VB6 but it is for a Word application. I hope to do something like this with Lotus123. But is it possible???

dim myWord as Word.Application
set myWord = createObject("Word.Application")
set myDoc = myWord.Documents.Add(App.Path& "myMacro.Dot")
myWord.application.run "NPGC"
' where NPGC is the name of a macro in myMacro.dot file
myWord.visible = true

3. I want my Lotus object to rename the file. How?

Thanks for help

Openning Excel And Running Macro From Word - Macro
Ok - I have a DB which I export to Excel, I then run a macro to "Groom The Data". I then run word and run a Macro (MailMerge to print labels) which retrieves data from the excel spreadsheet groomed above. Everything is working fine, despite my novice knowledge of VB, but I would like to do this in a single click.

I use a command line shortcut to Launch word and automatically have it run the macro, but I still have to Launch Excel and manually run its macro first.

I did not find a command line switch to make excel launch and run a macro. Is there any way I can Lauch Word have its Macro link to excel, then launch and run the excel macros before performing the macro I have set up in word (mailmerge)

In Other Words I have working macros in Word and Excel, I want the Word Macro to force the Excel macro to run before completing the rest of its duties.

Thanks
WW

Lotus Macro Ruined The Day
Hi All, I've just started VB and have been already caught out with an old lotus macro sitting in my main excel report!
The only option I have is rewrite the macro, so if anyone could help I can offer a few pints in Dublin and my gratitude.

The worksheet has 13 panels of data the first 12 are Jan to Dec the 13th panel is where the report is derived. The user enters the current month number (C6) and runs the macro. It uses the value of C6 to search the first 12 panels to find the month, then copies right 5 and down 91 cells of data. Once copied it pastes the data into the 13th panel starting at cell CJ17. this completes the macro.

The lotus code is below;

TITLE
copymonth - Copies data to current month
TURN OFF SCREEN AND PANEL
{paneloff}{windowsoff}
WORKSHEET GLOBAL PROTECTION DISABLE
/wgpd
RANGE UNPROTECT CJ17 TO CO108

/rucj17..co108
MOVE CELLPOINTER TO D17

{goto}D17
MOVE CELLPOINTER BASED ON THE CONTENTS OF CELL C6

{for counter,1,((C6-1)*7),1,right}
FROM WHERE THE CELLPOINTER ENDS UP COPIES THE RANGE FROM THERE RIGHT 5 CELLS AND DOWN 91 ROWS THE PASTES THIS COPY STARTING AT CELL CJ17

/c{r 5}{d 91}~cj17
WORKSHEET GLOBAL PROTECTION ENABLED

/wgpe
TURN ON SCREEN AND PANEL

{Home}{windowson}{panelon}

The basics I know get me about four lines into the code and thats probably wrong! I've spent the weekend studying manuals looking for inspiration, so if someone could show me the light as stated earlier the Guiness will be on me.
Regards Lawdie

Converting An Excel 2002 Macro To An Excel 95 Macro
Hi there, I’ve finally got my macro program to work (thanks everyone). Now I have to load the macro on a much older machine. I wrote the Macro on Excel 2002 and now I’m trying to run it on Excel for Windows 95 Version 7.0. I’ve loaded it up, but there are all sorts of errors. Does anyone know of a simple way to convert the macro code so it will run smoothly on Excel 7.0?

Run Access Macro From Excel Macro
Hi

I am using Microsoft Office 2000 and trying to run an Access macro from an Excel macro, but my Excel macro does not seem to be working. When I run the Excel macro, nothing happens - I do not get an error and the code does not do what it is suppossed to. Below is my code:

Code:
Sub DisplayForm()
' Initialize string to database path.
Const strConPathToSamples = "C:Miscell est.mdb"

strDB = strConPathToSamples & "test.mdb"
' Create new instance of Microsoft Access.
Set appAccess = _
CreateObject("Access.Application")
' Open database in Microsoft Access window.
appAccess.OpenCurrentDatabase strConPathToSamples
' Run Access macro.
appAccess.DoCmd.RunMacro "Macro1", 1
End Sub
I have included the references to "Microsoft DAO 3.6 Object Library" and "Microsoft Access 9.0 Object Library."
Any help on this subject would be much appreciated.
Thanks

Help Needed To Convert A Lotus Macro To Excell
I have got a work rota done in lotus with macro's, i need to be able to convert it to excell

Word Macro Insert File/ Append Table Macro Issue.
Hello,

I was wondering if someone could help me with this problem...

When I use the following code to insert a table (from an external file), the table that is inserted does not append to the table in first document (which is what I want it to do)...

Sub Macro1()

Selection.Collapse Direction:=wdCollapseEnd
Selection.InsertFile FileName:="m:cat.DOC", Link:=True

End Sub

Would anyone know how I can make the contents of this file append to the table in the first document?

Thanks so much in advance,

Anne

Macro Opens A Document In Vba, Saves, Then Continue With Macro
Maybe the title isn't correct, but i've got the following problem.
I build a document that open a form. On this form there is a checkbox. When the checkbox is active and I press 'OK' a document has to be opened. On this document some changes can be made, then by pressing 'continue' this document is saved on 'c: emp' and closed. Then I want to go back to the first document and continue with it.
Is there some sort of halt or wait funtion to establish this?

The code I use is the following:

<code document1>
If chbFinPar = True Then
Documents.Open FileName:="f:Nieuwe format macroHuisstijlTestversiefinpar.doc"
Selection.EndKey , ActiveDocument.Bookmarks("bmkfinpar").Range
Selection.InsertFile FileName:="c: empfinpar.doc"
End If
<end code>

<code document2>
Private Sub cmdVrdr_Click()
ActiveDocument.SaveAs ("c: empfinpar.doc")
ActiveDocument.Close
End Sub
<end code>

Word Macro Editor Opens When I Misspell A Macro Name
I'm using Word 2000, and pressing Alt+F8 to access macros - just text strings - and here's the trouble:

I'm trying to make it possible for everyone here to use Word macros from the server. I've put a file out there called Macros.dot and it works great. Every machine in the building can see it and use it. Trouble is, if a user misspells a macro name the macro editor opens by default. It doesn't realize the user has misspelled something and thinks the user wants to write a new macro under the "new" name. User can click the X to close the editor, of course, but has now created a blank macro with a name very similar to a real macro. This will drive people (especially the less tech savvy) nuts, and clog up the file Macros.dot with garbage.

Is there a way to disable the macro editor from opening if an incorrect (nonexistent) macro name is typed? A check box somewhere, perhaps? I've tried but can't seem to find it, if it's there.

Thanks

How To Hide Macro Option From Tools Macro, Macros
Hi,
Well, this is the situation. I created some macros (6) for a workbook. One this macros is adding a new Menu in the main Excel Menu. The idea is that the user does not need to go to options: Tools, Macros, Macro...and run the macro because I want them to do it from the menu specially created.
Also I prevented any user to edit the macros putting password if they want to see the codes.
Now How I can prevent a user to run all my macros from the option:
Tools, Macros, Macro...Can I hide a Macro from that menu?

Any way to remove this option in just this workbook not affecting the user if they want to work with a new one...?
Or may be a message saying that macro can be run from the menu if the user is trying too.
Any suggestion?
Thanks!
Gonza

Can You Get An Access Macro To Include Running An XL Macro
Is it possible to have an MS access run its own "thing" and in the middle of it all call on excel to run it owns macro?

Word 200 Vba Macro Help - Enable Track Changes In A Macro. Thanks
I was able to find a macro which takes an already mail merged document, and saves each each document as a separate file. The document's filename is taken from the already merged document. The script works. It's in red. See below.

The problem is I need to enable the track changes option.I recorded the following macro. It's in blue.
With ActiveDocument
.TrackRevisions = True
.PrintRevisions = True
.ShowRevisions = True
End With
End Sub

I tried to incorporate this code(blue) into the code (red) below. I added it between ActiveDocument.Sections.First.Range.Cut and Documents.Add but it didn't work.

ActiveDocument.Sections.First.Range.Cut
ActiveDocument.TrackRevisions = True
ActiveDocument.PrintRevisions = True
ActiveDocument.ShowRevisions = True
Documents.Add

It turned on track changes but it didn't create each new document. What am I doing wrong?

Desperately Seeking help!!

Script works perfectly.
Sub SplitMergeLetter()
' splitter Macro
' Macro created 16-08-98 by Doug Robbins to save each letter created by a
' mailmerge as a separate file.
'
Selection.EndKey Unit:=wdStory
Letters = Selection.Information(wdActiveEndSectionNumber)
Selection.HomeKey Unit:=wdStory
Counter = 1
While Counter < Letters
Application.ScreenUpdating = False
Selection.HomeKey Unit:=wdStory
Selection.MoveRight Unit:=wdWord, Count:=1, Extend:=wdExtend
sName = Selection
'set path below
sPath = "C:MERGELETTERS"
Docname = sPath & sName
ActiveDocument.Sections.First.Range.Cut

Documents.Add
With Selection
.Paste
.EndKey Unit:=wdStory
.MoveLeft Unit:=wdCharacter, Count:=1
.Delete Unit:=wdCharacter, Count:=1
End With
ActiveDocument.SaveAs FileName:=Docname, _
FileFormat:=wdFormatDocument
ActiveWindow.Close
Counter = Counter + 1
Application.ScreenUpdating = True
Wend
End Sub

Call Macro ~change Macro
I want to create a print preview from a access rapport

I'm using this code:

Code:
Private Sub Command1_Click()
Dim A As Object

Set A = CreateObject("Access.Application")
A.Visible = true
A.OpenCurrentDatabase (App.Path & "
ewP2.mdb")
A.docmd.RunMacro "macroprinten"
ENd SUb
the first macrocommand is openreport + report name
at this instruction there is a posibility to specify a WHERE instruction.

Is it posible to chance this where instruction in visual basic
?

Many thx
grz
EBS

Modifying Macro Or Form With Macro
Is it possible to modify a userform or macro in a module with another macro?

I've got a database of clients that will probably have new clients from time to time. Currently using userforms to give check lists and of course that stuff is referenced in macros. Would be cool to write a macro that would allow a user to modify that stuff to add in choices as needed.

Can this be done?

Attatch A Macro To A Button With A Macro?
I am creating a new sheet using VBA, I would like to be able to add a button to this sheet (which I can do), and attach a macro to the button (which I cannot).

Can anyone tell me how to attatch a macro to a button using another macro? Or any other way of making the newly created button actually do anything?

Thanks!
-Shiv

Excel VB Macro Invoked By Customized Button Not Moved When Excel File Is Copied && Pasted
hello....the thing is I wrote a macro in an excel file which get's invoked when a customized button is clicked......now when I copy and past this excel file, the button in the new excel file still keeps pointing to the macro in the old file and only the macro in the old file is invoked again.....can anybody tell me how to resolve this problem?

Possible To Launch A UserForm In Excel From Startup Macro Without Showing Excel?
Greetings to all VBA/Excel Excperts!

I have a project at work that is requiring me to utilize Excel/VBA (something I'm not super-conversant in) and I am wondering if it is possible to have a UserForm be the first thing that pops up when you launch (i.e. double click on) a spreadsheet (likely an .xlt but not necessarily)? I know I can have an Autostart Macro (or something of that ilk) that could launch the form, but I am hoping there is a way to do this so that it just looks like I launched the UserForm and am not firing up the entire Excel program.

As soon as the functionality encapsulated in the UserForm is completed it will shut down Excel, which is why I'd rather just have the form and nothing else.

My reason for doing this is to make deployment of this "application" simple - just drop the spreadsheet onto the target system (which of course must have Excel 2003 installed, which all of our company systems do) and double click. Saves having to create an install package for a plain ole VB app.

Thanks for any suggestions and/or taunts you may have!

How To Create Report In Word Format Through Excel Or Excel Macro
Hi...
I want to create one Report in Word document Format through Excel.
I have some Data in excel.Now How can I create report in word format using Macro or any other feature, if yes then How ??
Can anyone help me in solving this.
Thanks a ton !!!

Want To Write An Excel Macro That Automaticaly Closes Excel When Finished.
HELP!!! I am trying to get excel to close itself down after a macro has run but have no idea how to do it. I can get it to save&close the current spreadsheet but thats it. Can anybody please help?

Excel Macro Help
I'm trying to write a macro so that when you start a new row a 'N' automatically goes into column E. A friend of mine asked me for help and for the life of me I can't figure it out.

Any help is appreciated, Thanks!

Amy

Is This Possible? Excel Macro
If I wanted a user to open a particular file (name known to user) located in a particular folder could I just have them type the filename in an excel cell eg - they would type "thisfile" and then have a macro button which will open the file.

would it perhaps look something like this?

Sub OpenCellValue()

Workbooks.Open Filename:="C:MyFolderSubFolder[Range("A1").Value].xls"

End Sub

Obviously the code above doesn't work at all. Am new and stuck - hope someone can help

GH

Help With Excel Macro
Hello,

I need to create a macro to peform the following tasks:
1) Open a file dialog pop up to ask user to select the
Excel file(s). Files will have different names, but same
format.
2) Copy certain cells in all files selected and paste into
an Excel master file called "Master".

Here are the example of the 2 Excel files data and format:
1) Opened files format, could be called Data1, Data06, etc.
A B C D
1 Date: 5/2/03
2 Requester: John
3 Buyer: Mary
4 Issue: Defective parts
5 Ship: 5/8/03

2) Master file:
A B C D E
1 Date Requester Buyer Issue Ship
2 B1 D2 C3 B4 C5
3 B1 D2 C3 B4 C5
4
5
NOTE: Row 2 is from file Data1, row 3 from Data06, etc.

SUMMARY: Dialog to open selected files, copy certain cells
and paste/transpose over to the Master file, where it will
put the data in the first file into row 2, 2nd file data
into row3, etc.. THANKS

VBA For Excel... Or A Macro
I have to do a spreadsheet at work, well its using Quattro Pro 10, which does use VBA, but also in Excel XP.

See, its going to be like a large... Index for files on the hard drive, as well as a spreadsheet to sort "done", "in progress", Creator, division, etc.

Its going to be a huge listing of files. Right now I'm seeing about 600+ and more in the future. We want to do html links to a relative path on the disk to them, and that works just fine. Except for having to open a dialog box, travel down the path and type in the 'shown text'.

I tried to just use html in the cell, and thats a no go.

Right now all of the files are <groan> in directories by dept and then by 'done', 'in progress', 'not started'. My first idea is to get rid of that crap. Just throw it all into dept directories. If its 'not started' and theres a html link to it and someone moves it, the link is broken.

I suppose the question is, does VBA have a way to just run through the path relative to the spreadsheet and grab all of the files throwing them into html links with the path+ file also as their visible name?

A quick way to begin this would be helpful, and a quick way to update things down the road would help too. It just nagged me as something that shouldn't be so hard, but was just made needlessly annoying, and there HAD to be a more simple solution.

Thank you for you help/advice

Need Help With Excel Macro
Hi, I'm new to this forum. Here's my problem:

I have an Excel macro that deletes the entire row if the cell in the selected column is empty. I need to modify it so that it deletes the entire row if the cell in the first column contains certain text or does not contain certain other text. It seems like this shouldn't be too difficult, but I'm having a hard time with it. Here's the macro as I currently have it - any help much appreciated:

Public Sub DeleteBlankRows()

Dim R As Long
Dim C As Range
Dim N As Long
Dim Rng As Range

On Error GoTo EndMacro
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

If Selection.Rows.Count > 1 Then
Set Rng = Selection
Else
Set Rng = ActiveSheet.UsedRange.Rows
End If
N = 0
For R = Rng.Rows.Count To 1 Step -1
If Application.WorksheetFunction.CountA(Rng.Rows(R).EntireRow) = 0 Then
Rng.Rows(R).EntireRow.Delete
N = N + 1
End If
Next R

EndMacro:

Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic

End Sub

Excel Macro
I would like to create a VB macro in Excel that will store the modification date of the worksheet in a Cell. This will allow someone who is only viewing to see how current the data is.
I tried using DateLastModified command but could not get it to work.

Any help would be appreciated
Thanks

Excel Macro
I am using an Excel macro to automate a query from Access but have a bit of a problem... everything works fine when I am using the hardcoded values as selected in the query wizard e.g.

`Milestones Stuff`.`Project Ref`=3

However, what I really want to do is change these values depending upon other conditions something like this:

Dim myvariable As Integer
myvariable = 6

`Milestones Stuff`.`Project Ref`= myvariable

This doesn't seem to work at all since the query does not return any data. Can you do this kind of thing in VBA? If not what other way can you change macros dynamically?

Thanks

Help With Excel Macro Please....!!
I am trying to return the file path of a specified file without the file name attached to the end of the path.
I am really struggling with interpreting the useless help documentation in VB.
I want the macro to prompt the user for a directory using this code..

pname = Application.GetOpenFilename(, , "Please Select A File In The Prefered Working Directory", , False)

This allows the user to browse the directories for the files they want but I really only want the directory, not the file itself. Unfortunately, you must select a file that gets attached to the variable, pname in this case.

This is one of the examples the help documentation shows for using the path property, one of the things that I tried...

Sub ShowFileAccessInfo(filespec)
Dim fs, d, f, s
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFile(filespec)
s = UCase(f.Path) & vbCrLf
s = s & "Created: " & f.DateCreated & vbCrLf
s = s & "Last Accessed: " & f.DateLastAccessed & vbCrLf
s = s & "Last Modified: " & f.DateLastModified
MsgBox s, 0, "File Access Info"
End Sub

Can someone tell me what filespec stands for?
I don't care about the extra info, like date modified and such.
I am only concerned with getting the path to the directory that the user has chosen, without the filename.

I have tied countless different methods to extract the directory only without the file because my code goes on to use the
.LookIn command to search the designated directory for as many files of a certain type there are, then it opens each file one by one and does stuff to them.
I just don't want to have to hard code the path to the directory in the macro script. I want the user to be able to browse for it when they run the script.

Is there an easy way to do this that I am completely overlooking??

Thanks,

Help With Excel Macro
I am trying to create a macro that will automatically copy a heading and paste it into the cell beside it if the cell is blank, otherwise copy the heading already in the cell and do the same.

For example:

H I J K L M N
1 Heading1 Blank Heading2 Blank Blank Heading3 Blank

"H" starts the column headings all the way to "N"
1 is the first row

I want the macro to be able to copy heading1 in cell H1 and paste it into cell I1 since it is blank. Then it goes to cell J1 and notices the cell is not blank, so it copies the contents in J1 and pastes it into cells K1 and L2 since they are blank. Then it goes to cell M1 and sees it isn't blank, so it copies the cell and pastes into cell N1 because that cell is blank.

How on earth do I get the macro to do this for me??? The headings constantly change and will sometimes have headings and other times will be blank.

Any help would be greatly appreciated.

Thanks,
Boochy

Excel Macro Vb
i want to make a macro that enters the name onto the tab from a list, but when i run the macro it just returns TRUE my macro code is as follows

Sub Sheet_Name()
'
' Sheet_Name Macro
' Macro recorded 13/07/2005 by asiddle423
'
Dim x
Range("A3").Select
x = Selection.Copy
Sheet16.Name = x
Sheets("Sum").Select
End Sub

Excel Macro Run From VB
I have a master excel file with a macro which opens and manipulates other excel files. The macro works perfectly when I simply open the master file and run it from there.

My Problem occurs when I run the macro from a VB app. In short... All of the macro works fine except for one line (the most important on of course).

Code:

Public Sub Retrieve_CF(Range_Refresh As String)
Dim setSheetOption As Long
Dim strSheetName As String
Dim lnRetrieval As Long

On Error GoTo Retrieve_Err
'Sheet1.Activate 'Activate the sheet where the report is located. Tho the name of the sheet is not sheet1 it can be referenced as such because it is
'the first sheet in the report

'Essbase function that is used to retieve data from the current sheet and highlights
'the range in the sheet that needs to be refreshed

setSheetOption = EssVSetSheetOption(xlTargetWorkbook.ActiveSheet.Name, 13, True) 'Use Alias'
setSheetOption = EssVSetSheetOption(xlTargetWorkbook.ActiveSheet.Name, 11, True) 'Retain Formulas
setSheetOption = EssVSetSheetOption(xlTargetWorkbook.ActiveSheet.Name, 5, 1) 'No indentation
strSheetName = xlTargetWorkbook.ActiveSheet.Name

'**********The following line doesn't work*****************
lnRetrieval = EssVRetrieve(xlTargetWorkbook.ActiveSheet.Name, range(Range_Refresh), 1) 'Retrieve Data from specified range of cells
'**************************************************
Worksheets(xlTargetWorkbook.ActiveSheet.Name).range("a1").Select 'puts cursor in the upper left corner of the report
RetrieveCount = RetrieveCount + 1
GoTo Sub_Complete:

Retrieve_Err:
ErrorString = ErrorString & "Error: " & Err.Description & " #" & Err.Number & " Retrieval area:" & Range_Refresh & vbCr
Resume Next
Sub_Complete:

End Sub

Of the lines above work fine with the exception of the line with the notation above it.
The function "EssVRetrieve" returns an error "The current sheet cannot be determined"

If you notice I grab the sheet name with "strSheetName " which is correct
and the functions above it work properly too.

I can't figure out why running it from a VB app would be any different than running it internaly. I even created a new VB project with stripped down code so all it does is open up the master file and run the macro. it still has the same problem.

Is it possible that there could be a conflict with VB thinking that my Master excel file is active versus the target file?

Thanks in advance for the help.

TK

Macro In An Excel
Hi there!

How can I know if an excel file has a macro? I am using Excel Object in Visual Basic 6.0.. Kindly give me an idea in the code that I will use. Maybe there is a property in Excel that tells if the Excel has a Macro.

Thanks!

IANIAN

Run Excel Macro From VB
Hiho,

i have the the same problem at the moment :

i've coded a macro called etics in Excel, no i want a command_button in my vb application which runs the macro....

how can this be done ? Please give me an example code, my english is not so good.

thx Salva

Excel Macro Help
Hi,
I am fairly new to Programming and i am stuck with an assignment in school.
The thing i have to do is to find the last Non-Zero value of a particular column and write the value of that cell to a another cell. All this has to happen on change of value in the column. Is this possible. Thanks in advance.

Macro Excel To VB 6
I am working on linking complex macros excel into a VB program and to VB to macro excel. Firstly what I would like to do is have the user put inputs in VB. Then link those inputs to the input textbox (form in excel - 'User Defined Functions (UDF's)' [identifiable by doing an Alt+F11 & looking for macros that start with 'Function Somename']) in the original Macro Excel form . Have the Macro Excel spreadsheet do all the calculations. Then, link the output from Macro Excel back to VB and display it.

Basically I want the inputs in VB, have Macro excel do all of the work then link the output back to VB. These Macro excel were a system for a machine.

Please Help!!
fiz1058

Excel Macro Help
Hi

i'm not sure if i'm posting in the correct area but here goes.
i would like to get certain rows hidden if a value in the "I" column equals "hide"
as i have a "if"formula in that cell to test other cells.

In short
IF column "I" = "hide" then row is hidden
print report
return rows to visible [un hide]
end macro

i have no experience in this area but i'm sure it probably is a simple bit of code. if anyone could assist it would be greatly appreciated.

Excel Macro
Hello,

I have one excel file that is generated with the next format:

1 row: [Cat on first columm]
2 row: [Sub Cat on de second columm]
3 row: [cod_product][desc][price]
4 row: [cod_product][desc][price]
5 row: [cod_product][desc][price]
(...)
e thus successively, i.e. when i have a new cat it will put in the first columm and the others are blank, one i have a new sub cat, it will put in the second columm and the others are blank, this sub cats, in the rows after have products.

What I would like to do is to create a macro that modify the format to the folow:
1 row: [cod_product][desc][price][Cat][Sub Cat]
2 row: [cod_product][desc][price][Cat][Sub Cat]
3 row: [cod_product][desc][price][Cat][Sub Cat]
4 row: [cod_product][desc][price][Cat][Sub Cat]
(...)

Some one have one ideia how to make this?

Thank you all

Excel Macro Help
How do i make a macro check whether the contents in my cell is being truncated? If it is truncated, adjust the rowheight so that the content of the cell is not truncated. Thank you.

Excel Macro
Hi,

I am creating an excel file under an application written with VB6. After creating the excel file I also add some macro attached to a combobox as:

With ActiveWorkbook.VBProject.VBComponents("Sheet1").CodeModule
StartLine = .CreateEventProc("Change", "ComboBox1") + 1
.InsertLines StartLine, _
'--My macro code is in here----
End With

then I quit the excel application as:

oBook.SaveAs "C:sample.xls"

oXL.Quit

My problem is that the Visual Basic Editor of Excel remains opened until I close my application. How to make it closed immediately?

Thanks

Excel Macro
I'm at work and a long time ago I modified a template for the budgets we do here and it's uses macros to do some advanced figuring that couldn't be done with regular excel formulas. Anyway one part of the macro sets a string variable something like this

Code:
NoGoMessage = "A solution couldn't be found due to the 100% or greater tax rate" & chr(13) & _
"You must figure this by hand"

msgbox NoGoMessage

So the problem is when it gets to the chr(13) it throws and error, says something about a compile error, something about not being able to find something. But it started doing this when a few of the computers were upgraded to windows XP. I have 2000 and it works fine in windows 2000 and when I search through the object browser chr can be found under the strings class under VBA just as it is on my computer. I know I don't have specifics but if anybody has encountered this before I'd appreciate help. Preferbly a change to excel and not the macros because there of hundreds of these and the lady that works with them isn't the most computer literate so it's a struggle to get her to edit the macro and remove the chr(13). I'll try to post more specifics when it happens some more.

Excel + Macro VB Help
Hi,

I would like to make a small excel invoice. I have the whole layout done. Now what I want to do is make a few drop down boxes with different names and each linked to a different value. Here is one.

1 box:

Baseboards
Baseboards up to 3"
Baseboards up to 4 1/4"
Baseboards up to 5" to 6 1/4"
Baseboards up to 7" to 9 1/4"

Now the above should be in a box on the excel file where the user will select one of those options and it will use the right price to calculate the total.

Prices:

Baseboards up to 3" ---------------> 0.075
Baseboards up to 4 1/4" ---------------> 0.130
Baseboards up to 5" to 6 1/4" ---------------> 0.143
Baseboards up to 7" to 9 1/4" ---------------> 0.200

So when the user selects one of those and inputs a quantity it will show the price in the box next to the quantity.

Any help would be greatly appreciated.

Thank You So Much.

Run Excel Macro From VB.Net
Just a quick question is there anyway to run an excel macro from VB.net
I can open excel spreadsheet and manipulate the cells from vb.net, I have a lot of macro in excel that I want to link into a series of buttons on a form in vb.net. Is this possible if yes how do I go about doing that ?

EXCEL And MACRO Help?
hey
I am new to this forum and using macros in excel file.
I have a excel file. I want to do something so that when i finish entering things in sheet 1 , my sheet 2 gets printed.
Is there any way i can creat a macro and run it. I am a newbie in macro.
IW ill appreciate your help.
thanks
Deepak

Excel Macro Help
Problem Solved.

Excel-Macro And ASP
Hi,

I was programming an asp site to start a word template that includes a macro. This macro reads Variables from the ActiveDocument. The following example will show how it works. But my problem is not the macro and not word... it is that i need it now for EXCEL and something is not working with the Variables. The ActiveWorkbook-Object does not know the Variables-Methode.

My Question:
How do I have to modify my Code that I can submit Parameters to the EXCEL instead of WORD?

*******************************************
The ASP/Word-Macro Example:

In my ASP I set the Variables:
Set Doc = Word.Documents.Add(template, False, 0, True)
Doc.Variables.Add "FTPUploadString", "<%=aString%>"

In my Word-Macro I read the Variables:
strSomething = ActiveDocument.Variables("aString").Value
*******************************************

Lotus Macro To Excel Macro Please Help!!

I know nothing about Lotus but I need to convert Lotus macro to Microsoft Excel. Can anyone help