Portable MSOffice 2007 Error while Runing VBA form-Initializing Places

Sanatanab

New Member
Joined
Nov 26, 2012
Messages
1
Hi,
Warm Greeting To all. I am New to This forum. I have a problem Regarding Excel VBA Form in Portable-2007, Please Guide Me.

I have created a Form in excel VBA that open one excel, get range of value then paste spacial value in master excal, Close previous excel without save and repeat same step for another excel.close all source excel and stay opened master excel.I have place a Browser for assigning the path.

When opening Portable 2007 Excel I enable the Marco.

I have tested many times, It runs perfectly, But sometime two different Errors shows.

1> When Click Browser Msg shows "Initializing Places" , and notresponding the excel.

2> When Browser passes without error and at final stage, Means after appended two excel, before closing source excel an error shows "Method'PasteSpecial' of Object "Range' Failed'.
(I have use last code to open the path folder)

Please check the code.
"
Set fs = CreateObject("Scripting.FileSystemObject")
Set xl = CreateObject("Excel.Sheet")
Workbooks.Open "LINE.dbf"
Workbooks("LINE.dbf").Sheets("LINE").Range("A2:A500").Copy _
Workbooks(Mynewname).Sheets("Block name").Range("C3:C500").PasteSpecial xlPasteValues
Application.DisplayAlerts = Flase
Workbooks("Line.dbf").Close False

Set fs = CreateObject("Scripting.FileSystemObject")
Set xl = CreateObject("Excel.Sheet")
Workbooks.Open "POINT.dbf"
Workbooks("POINT.dbf").Sheets("POINT").Range("A2:A500").Copy _
Workbooks(Mynewname).Sheets("Block name").Range("F3:F500").PasteSpecial xlPasteValues
Application.DisplayAlerts = False
Workbooks("Point.dbf").Close False
Workbooks(Mynewname).Save

Shell "Explorer.exe /n,/e," & srcpath, vbNormalFocus

"
Any correction. Please Help me.

Thank You in advance.
Sanatana
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top