Devam Ediyor

Excel VBA Programming

Okay here are the problems that I am facing:

Firstly, every time that I open a workbook and I try to record a macro it gives me this message "Personal Workbook in the startup folder must stay open for recording" and it does not let me record until I open the "personal" excel file manually. The problem here is that in order to open the personal file manually, I have to go to the XLSTART file. This means that the "Personal" file is already in the XLSTART file, so I do not understand why it gives me that message in the first place.

The other problem that I have has to do with recording the macro. I want to record some steps that I perform on the "Underpad + Adult - main1" workbook and then use the macro to perform the same tasks on other workbooks such as the "Avantage - Corresp + Costs1" Workbook but it does not work properly. More specifically I record a macro during which I copy all the information on every single sheet from the "Underpad + Adult - main" (eg the "Correspondance" sheet) and paste it on the sheets of the "Avantage - Corresp + Costs1" workbook. Although I am able to record the macro, when I run it, it either does not copy paste all the sheets or it does not paste everything.

Furthermore when I try to run the macro on another workbook other than the "Avantage - Corresp + Costs1" Workbook the macro does not run at all and it gives me an error where it say that I have to debug it. Is there any way that I can make the macro work on any workbook?

Below you can find the Code of the macro that I have recorded. Also I have attached the "Underpad + Adult - main1", "Avantage - Corresp + Costs1" as well as the "Bazaar - Corresp + Costs1" file so you can test whether it works.

So here is the code:

Sub testing3()

'

' testing3 Macro

'

' Keyboard Shortcut: Ctrl+h

'

Sheets("Correspond").Select

[url removed, login to view]

[url removed, login to view]

Windows("Avantage - Corresp + Costs1.xlsx").Activate

Sheets("Correspondance").Select

[url removed, login to view]

[url removed, login to view]

[url removed, login to view] = False

Windows("Underpad + Adult- main1.xlsx").Activate

Sheets("Costs - Adults").Select

[url removed, login to view]

[url removed, login to view]

Windows("Avantage - Corresp + Costs1.xlsx").Activate

Sheets("Cost - adult").Select

[url removed, login to view]

[url removed, login to view]

[url removed, login to view] = False

Windows("Underpad + Adult- main1.xlsx").Activate

Range("E33").Select

Sheets("Costs - Underpads").Select

[url removed, login to view]

[url removed, login to view]

Windows("Avantage - Corresp + Costs1.xlsx").Activate

Sheets("Cost - underpad").Select

[url removed, login to view]

[url removed, login to view]

[url removed, login to view] = False

End Sub

Beceriler: Excel

Daha fazlasını görün: why do i want to work here, where i find programming tasks, vba work, vba with, vba programming in excel, vba excel programming, selection problem, programming tasks in c++, programming problems, programming keyboard, programming in vba, programming in excel vba, programming in excel 2010, programming in excel, programming from, programming for excel, programming error, me excel, macro programming in excel, excel vba macro programming, excel to application, excel programming vba, excel c# programming, excel 16, c# programming problems

İşveren Hakkında:
( 1 değerlendirme ) Kingston, Canada

Proje NO: #714291

Seçilen:

mike121zz

very easy job, will take half an hour once full workbook is received.

1 gün içinde 30$ USD
(1 Değerlendirme)
1.0

10 freelancer bu iş için ortalamada 51$ teklif veriyor

ExcelGurus

Hello, Please take a look at your PMB. Thank you, David

in 3 gün içinde65$ USD
(8 Değerlendirme)
4.7
punshar71

hi i can help you with this problem pls send me all the files..

in 2 gün içinde50$ USD
(0 Değerlendirme)
0.0
FinAnalyst

+++Plz Check PMB+++

1 gün içinde 50$ USD
(0 Değerlendirme)
0.0
Ahsanzahir

we believe in fare dealings

in 10 gün içinde30$ USD
(0 Değerlendirme)
0.0
ibrahimhspl

I am familier with excel & have more than 7 years expereince. So i think the project will be completed with in 15 days.

in 15 gün içinde100$ USD
(0 Değerlendirme)
0.0
centzbanaag

Hi Sir, The problem you are encountering is caused becaused you are copying from a worksheet, before you can copy a worksheet you need to open it. There is a solution for these (1) code so that it will automaticall Daha fazlası

1 gün içinde 60$ USD
(0 Değerlendirme)
0.0
Kumarsagar

Process : Support (MIS) Platform : Ms Office, VBA, Macro and SQL Duration : July 2009 - Till Date. Organization Profile: First Indian Corporation Pvt. Ltd ([url removed, login to view]) is a member of First Americ Daha fazlası

in 2 gün içinde35$ USD
(0 Değerlendirme)
0.0
anatprog

I can do it. There's no attached files to make full test.

in 4 gün içinde60$ USD
(0 Değerlendirme)
0.0
pepsmich

Hi! Click Tools-->Options-->Select "General" tab. Make sure that "Ignore Other Application" is unchecked. If this won't help, I would need a copy of your workbook.

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0